ODBC Issues with SQL Server

Useful tips for ODBC and MS SQL Server and stored procedures

1. 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.

1. 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