ODBC Issues with SQL Server
Jump to navigation
Jump to search
Useful tips for ODBC and MS SQL Server and stored procedures
- 1: When retrieving data from an ODBC database, for certain setups I got the error ‘invalid cursor state’. This occurred sometimes when I used a stored procedure to retrieve data.
Problem Source: The stored procedure returns values, and not records from a table or view in the database, as Planimate expects.
- 2: Running a stored procedure gives error "connection is busy with results for another command"
The solution is to use the following script in the ODBC object in PL:
"set NOCOUNT on;
EXECUTE spName"
worked on:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
idkbase note 323