i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

5 pts.
Tags:
Software maintenance
SQL Server 2000
SQL Server 2005
SQL Server upgrades
VB
Visual Basic 6
i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll want to change out to using the SQL 2005 OLE driver.

All the T/SQL code should work fine. At a prior company we had a VB6 application which was using a SQL 2000 database. We upgraded to SQL 2005 with no problem. We were using about 98% stored procedures.

What errors are you getting, and what T/SQL is being run?

It could be that you are trying to use some SQL objects which have been renamed or removed, or the data changed. It could also be that you are trying to use system objects within the master database which they don’t have access to by default any more.

From Ritchie:
Did you install a new version of SQL Server or an in-place upgrade? If it was a new instance the instance name may need referenced in queries. Try to set up a DSN through windows to test if you can physically connect to the database. Make sure that there is no problem with the user you are using to connect to SQL from inside the VB6 program. Open SQL Server Management Studio as this user and attempt a few queries to make sure that this is not a permissions problem.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following