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,
It should be working with the same connection string from 2000 -> 2005.
What is the error message? Please update your question and include the error message!