ODBC Issues with SQL Server

From Planimate Knowledge Base
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

Retrieved from ‘https://wiki.planimate.com/index.php?title=ODBC_Issues_with_SQL_Server&oldid=1987’