Mrdenny 
46795 pts. | Jul 6 2008 12:45AM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Q:
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??
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??
ASKED:
Jul 5 2008 5:55 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
