Printable View
while accessing data from SQL Server
through vb program i m getting error
error - "Run Time error" 40002
37000:[microsoft]ODBC Sql Server Driver)[SQL Server] the cursor was not declared
this progrm was made in vb5 and sql 6.5 it is working fine with sql 6.5
but when i m trying to run in on sql 2000 it is giving bove problem
what could be the solution for this as i wanted to upgrade the sql 6.5 to sql 2000
what I think you did not properly import in SQL 2000.That is the resion.
Have you got the correct driver for SQL Server 2000?
You can check in Control Panel, under "Data Sources (ODBC)" (which may be in the "Admin. Tools" folder, depending on your version of Windows). Select the "Drivers" tab, and check that the first part of Version for SQL Server is 2000.
If it is less (probably 6 or 7) then you need to install a newer version of MDAC, see the link below to download it.