Download Campaign Enterprise Version 11 - Mass email marketing software

Enterprise Manual
To connect to SQL Server running on a remote computer ( via an IP
address):
Provider=sqloledb;Network Library=DBMSSOCN;Data
Source=90.1.1.1,1433; Initial Catalog=DatabaseName;User
ID=Username;Password=Password;
Oracle
MSDAORA is the OLE DB Provider from Microsoft:
Provider=MSDAORA;Data Source=OracleDB;User
Id=Username;Password=Password;
OraOLEDB is the OLE DB Provider from Oracle:
Provider=OraOLEDB.Oracle;Data Source=DatabaseName;User
Id=Username;Password=Password;
MySql
You must get the syntax exactly correct. The 'yourdatabase' is the name of
the database not the server name. This string will connect to the first
MySQL Server running. If you have multiple options, you may have to
inquire how to make the string work with your server. You will need the
logins to your database. You must replace the 'mysql' part of the above
connection string with the exact name of the MySQL driver installed on your
computer. To find that name you go to the Control Panel > Administrative
Tools > Data Sources (ODBC) and look at the Drivers tab. Track down the
MySQL driver. It must be installed to use the OLE DB connection. They
are available from the internet for free.
driver={mysql};
database=yourdatabase;server=yourserver;uid=username;pwd=password;
option=16386;
Use Basic Filter
If you only want a subset of your list to receive an email, for example only
customers in Idaho, you will need to apply some the basic filter to select your
data.
• Select the field by which you want to sort, in this case “State”
• Select the operand. For numeric values use the “=” sign, for text strings,
you will want to use “Like”
• Enter the value by which you want to sort, in our example “Idaho”
• Click the preview button to ensure that only those records that have a
value of Idaho in the State field are displayed. If you see no records
returned, you likely do not have anything matching your criteria.
The basic filter contains six columns, and five rows. Select the records in the
specified table where the field in selected in the first column equals some value.
In this case:
34