Upgraded my ASP backend from SQL 7 to SQL 2000

[Will192]

I have upgraded my ASP webpage backend from SQL 7 to SQL 2000. I'm pretty sure that I have everything setup correctly in the new database. I can log into SQL 2000 through Query Analyzer with the same user id that the webpage uses.

Anyone have any thoughts on why my page times out when it tries to access the database.

Thanks in advance for any responses to this post.

Will Summers

[Ribeyed]

hi,
sounds like it just can't find the database. Can i suggest that you create a new database in SQL 2000 and create a new page to link to the new database and try to eliminate the upgrading part of your process. If you new database and connection works then i would be looking at an error during the upgrade. If your new database doesn't work then you know it’s nothing to do with the upgrading part and maybe looking at configuration and corruption problems. These are only some suggestions, hope they help.

[Will192]

Tried to create the new database and the new page. Didn't work either. I setup the backup server to run on SQL 7 and everything worked fine. I did everything the same except for the SQL 2000. Is there anything that I need to do different to connect to 2000?

Thanks for your reply.

Will192

[ChrisBrown]

Did you make sure that your data connections in Microsoft ODBC were setup correctly and that your .asp file referenced it properly?

[Will192]

Fixed the problem. Now, keep in mind that both installations of SQL Server were set with the same options(sort order, case sensitivity, etc)

Here is the solution:

I changed this line

var strConn = "Provider=sqloledb;Data Source=idev;Initial Catalog=VACATION;User Id=VPIDEV;Password=IDEV";


To read like this

var strConn = "Provider=SQLOLEDB;Data Source=idev;Initial Catalog=VACATION;User Id=VPIDEV;Password=IDEV";


All I did was change sqloledb to SQLOLEDB. Just happened to notice that it was uppercase in my manuals. Thanks for your replies.

Will192

[celebguy_dv]

http://banners.dollarmachine.com/pic/2014000/hal001.gif (http://www.kinkyceleb.com/1261795520)

[celebguy_dv]

http://banners.dollarmachine.com/pic/2014000/hal001.gif (http://www.kinkyceleb.com/1261795520)