[thelist] ASP/ADO ConnectionString for SQL Server database
Joshua Olson
joshua at waetech.com
Thu Oct 16 14:33:20 CDT 2003
----- 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
More information about the thelist
mailing list