ODBC Issues with SQL Server

From Planimate Knowledge Base
Revision as of 02:43, 13 January 2008 by Rick (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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’