Select the database type from the drop down menu:
• If you are using database shortcuts, simply pick the shortcut name from the list for which you are approved.
• If you select a built-in list, select the particular table you want to use from the drop down list.
• If you select access
• Click browse and find the pathway to your Access database. A typical pathway may look like, C:\Documents and Settings\user\My Documents\dbname.mdb.
• Click Select to return to the datasource tab
• If you select a different type of database, click browse and select the DSN connection from the list of System DSNs.
When you successfully connect to the database you should now see options in the Table/Query Name field. If you do not see anything, it does not necessarily mean you are not connected. If your database has more than 300 tables and queries you may have to type the name of the table you want. For example, most Oracle databases can easily have 500 tables in them. Rather than wasting resources pulling all of that information into Campaign Enterprise, the field
changes from a drop down, to a text field and you need to enter the name yourself. A typical name for an Oracle table might be
OWNER.ORACLETBL.FIELDS. (Oracle likes the tables to be in all caps). Once you have successfully selected the table, the Email address is populated with the fields found in the selected table.
• Select the email address field. This is the field in your database containing the email addresses.
• Select the unique ID. This step is optional for now, but is important for the advanced features. If your email addresses are truly unique, you can use the email address field here.
To ensure that you are connecting ok, click on the Preview button and examine the table. You can look at the other fields from the additional drop down menus and clicking the Refresh button. Click Return to get back to the data source tab. The preview only shows the first 100 records in your database, but displays the total number of records at the top of the page. If the number of records in your table exceeds the limits of the evaluation, or the licensed edition of Campaign Enterprise, you will see a warning message next to the total. Prior to sending, you will need to filter your list to only send the authorized number.
ODBC Connection
When connecting to a database, if an ODBC Connection is selected, then a list of current System DSN (Datasource Name) entries will be displayed. When you select one of the DSN sources from the list, a DSN string appears in the
Datasource box. You may need to add other information to this connection string such as a username and password. Most ODBC Connection Datasource entries will look like the following:
DSN=MYDATASOURCE;UID=username;PWD=password;
You have the option of filling in the Datasource box manually without using the Browse button.
System DSN entries can be added by going to the ODBC Administrator in the Control Panel.
OLE DB Connection
If you have a very large database or are using complex filters to coordinate your campaigns, we recommend that you use an OLE DB connection string for your database connection. Here are some of the more popular database formats with their basic connection strings. Simply enter the OLE DB string in the connection field directly.
Sample OLE DB Connection Strings (variable portions are indicated in
RED)
MS Access
For Standard Security:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DatabasePath\\MmDatabase.mdb; User Id=Username;Password=Password;
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\DataBasePath\\mydb.mdb;Jet OLEDB:System Database=System.mdw;
MS SQL Server
For Standard Security:
Provider=sqloledb;Data Source=ServerName;Initial Catalog=DatabaseName;
User Id=Username;Password=Password;
For Trusted Connection security: (Microsoft Windows NT integrated security):
Provider=sqloledb;Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;);
To connect to a "Named Instance" (SQL Server 2000) you must to specify Data Source=Server Name\Instance Name like in the following example:
Provider=sqloledb;Data Source=ServerName\InstanceName;Initial Catalog=DatabaseName;
User Id=Username;Password=Password;
To connect with a SQL Server running on the same computer, you must to specify the keyword (local) in the Data Source like in the following example:
Provider=sqloledb;Data Source=(local);Initial
Catalog=DatabaseName;User ID=Username;Password=Password;
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;