Creating ADO Connections
Should you wish to manually set up an ADO connection, rather than using the Connection Wizard, the steps to set up the connection are as follows:
When you are in the ADO Administrator, click the New Connection Button
The first three selections are standard from Microsoft. If you select ODBC then your pre-existing ODBC Connection will be configured for ADO use. Other refers to additional ADO connections provided by other vendors e.g. Informix.
Clicking on OK shows the screen above.
Fill in the fields that define your ADO connection, (NB: these will vary depending on the ADO connection type you select):
Provider The Database you will be accessing
Data source/Server The name of the SQL Server
Workstation The name of the Web server
User ID Login ID, if using SQL Security
Password Password, if using SQL Security
Initial Catalog/Database The name of the database.
Packet Size The amount of data to read at once. The default is typically OK
Connect Timeout How long to wait for a command to return before failure.
Windows Security For a Windows login account vs SQL Security to access the DB.
Next step is click the Test Connection to make sure it is working. A successful connection you will produce a summary of the test.
Note: if you are using Windows Security, connections that work with the account you are presently logged in under, may not work for the account that the web service providers uses. Your host provider can help you work within the security settings of your host server.