What is the error you are getting?!? Cheers Ken -----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 Hi, 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"