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)
The following examples provide methods to connect to Microsoft Access, Excel, or to Microsoft SQL databases using ODBC connection strings. These examples will need to be configured to your particular directory path and database name.