[thelist] 2 MS SQL (in ASP) Questions

Ken Schaefer Ken at adOpenStatic.com
Thu Jan 10 18:25:24 CST 2008

What is the error you are getting?!?


-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of L L
Sent: Friday, 11 January 2008 9:04 AM
To: thelist at lists.evolt.org
Subject: [thelist] 2 MS SQL (in ASP) Questions

I'm working with MS SQL server 2000 and have installed it locally and imported a db to the local machine for local dev with ASP in IIS.  I have the connection string used for the db on the remote server.  Below is the current string - I've altered it to include 'localhost' and the name of the database, but it still is not connecting.  The pages will connect when the string is altered back to map to the remote server.  Any ideas as to what might be the culprit?

        Case "AMS"
            strConnString = "Provider=SQLOLEDB.1;" &_
                            "Persist Security Info=False;" &_
                            "User ID=test;Password=test;" &_
                            "Initial Catalog=zz_test;" &_
                            "Data Source=localhost"

More information about the thelist mailing list