Connection Strings with VBScript and Sql2000

Try it like this see if it works, usually does:
strDBConnect = "Provider=SQLOLEDB;Data Source=tcp:mssql10.discountasp.net;database=DB_430228_homebudget;uid=DB_430228_homebudget_user;pwd=*****;"

 

Thanks very much! That did it.

 

Glad it did bro, my pleasure.
Salute,
Mark

 

Hi,

I'm trying to port an application on my server to DiscoutAsp.net. With this I'm trying to connect to an SQL2000 database from within an ASP program and I get the following message when I try to run the page:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The connection string I'm using is:

'Data Source=tcp:mssql10.discountasp.net;Initial Catalog=DB_430228_homebudget;User ID=DB_430228_homebudget_user;Password=*****;' (in Session('StrDBConnect') in my code)

And the code is basically:

Set Session('objConn') = Server.CreateObject('ADODB.Connection')
Session('objConn').Open Session('strDBConnect')

I'm using this string because it was given to me on the SQL2000 Management page in DiscountAsp.net.

Help please.

Keith