Duplicate website, from SQL Server 2000 to 2005

I have one directory website which is up and running and using the sql server 2000 database thru Godaddy. I recently made a duplicate of this website as I plan to start a new directory. The only difference will be that Godaddy has assigned it a sql server 2005 database. In respect to the connection string, is there a difference to how it should be typed? Im currently getting an error and not able to connect to the sql server 2005. This is my connection string -

Application("DSN") = "Provider=SQLOLEDB.1;Password=XXX;Persist Security Info=True;User ID=XXXXX;Initial Catalog=AbcHomeInspector;Data Source=XXXXXXXXXXXXX"

I basically switched out/updated the Password, User ID, etc information and left all else as is. Can someone please help me with this. These are the only two lines of code which are different from website to website, as per the different user name, password, Data Sourse,etc...

Thank you very much,

Richi

1 answer