ODBC Issues with SQL Server: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
</font> | </font> | ||
---- | ---- | ||
<font size="2">idkbase note 323</font> | |||
[[Category:FAQ]] | [[Category:FAQ]] | ||
[[Category:Data/Exchange]] | |||
Latest revision as of 02:43, 13 January 2008
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