[thelist] ASP/ADO ConnectionString for SQL Server database

[Joshua Olson]

----- Original Message ----- 
From: "Sarah" <poohbear at designshift.com>
Sent: Thursday, October 16, 2003 1:01 PM


> So I did some searching for information on the ADO ConnectionString, and
> tried this (and got the same error message):
>
>    Provider=sqloledb;Network Library=DBMSSOCN;Data
> Source=xxx.xxx.xxx.xxx,1433;Initial Catalog=myDatabase;User
> ID=myUsername;Password=myPassword;

> Does anyone have a suggestion of a different ConnectionString I can try?

Provider=SQLOLEDB.1;Password='[password]';Persist Security Info=True;User
ID=[username];Initial Catalog=[dbname];Data Source=[servername]

Make sure the following are all true:

1.  Port 1433 is open between the web server and the database server.
2.  Make sure the MDAC versions are IDENTICAL on both machines.  MS has a
tool called comcheck that you can get off their site.  I highly recommend
that you get the latest version from MS and install on both boxes if you
have any doubt.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com
706.210.0168