Creating a DSN-less Connection to a Datasource.

Please fill out all of the Information and Click on Generate.
Choose your Database Type:
Your Site's IP Address
Database Location (Relative - Non SQL)
SQL Server Name (SQL Only)
Database Name (SQL Only)
User Name
Password
 
** For more information about creating a DSN-Less Connection String using OLEDB 4.0 use the following link.
Microsoft Technical Article - Opening a Database (OLEDB 4.0)


Fields

Choose Your Data Type-This field is for selecting the type of database you are connecting to. Selecting the correct type is imperative.

Your Site's IP Address-Enter the Web IP of the customer's site

Database Location (Not Needed if SQL)-This field is for typing the location of the file on your site.
Be sure to type in the full path name, including sub directories, off your root directory.
Example: d:/IP Address/start database location here
If customer's database is in a databases directory and the database is contacts.mdb, you would type in databases/contacts.mdb in the field box.

SQL Server Name (SQL Only)-Enter the IP Address of the SQL server that the customer's database is on.

Database Name (SQL Only)-Enter the Database Name of the Customer's SQL database that you want to connect to

User Name-Enter the user name for the database that you are connecting to (Not needed if database is not password protected)

Password-Enter the password for the database that you are connecting to (Not needed if database is not password protected)