Microsoft KB Archive/175090

= PRB: "Unclosed Quote" Error when Calling Oracle Stored Procedure =

Article ID: 175090

Article Last Modified on 5/2/2006

-

APPLIES TO


 * Microsoft Visual InterDev 1.0 Standard Edition

-



This article was previously published under Q175090



SYMPTOMS
The following error occurs when previewing an Active Server Pages (ASP) page that calls an Oracle stored procedure:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quote before the character string ' '.





CAUSE
The conditions that cause this error are as follows:
 * 1) Making a call to an Oracle stored procedure.
 * 2) Using the Data Command Control to insert the ActiveX Data Objects (ADO) code that accesses the stored procedure.
 * 3) Editing and closing the Data Command Control at least once after initially inserting the control.
 * 4) Choosing the stored procedure name from the Command Text drop-down list box in the Data Command's property sheet.

The Data Command Control incorrectly parses the Command Text being assigned to the cmdText object. The second time the DataCommand Control is opened it parses the sting as follows:   cmdTemp.CommandText = 'dbo.my_stored_proc' Which should be the following:   cmdTemp.CommandText = 'dbo.my_stored_proc'



RESOLUTION

 * 1) Open the Data Command Control.
 * 2) Manually enter your stored procedure name (for example, "my_stored_proc") in the Command Text property box.
 * 3) Close the control and preview the page.
 * 4) It works. If you open the control again and close it, it still works.



STATUS
Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Behavior

 * 1) Open or create a Visual InterDev project.
 * 2) Add a data connection to an Oracle database.
 * 3) Add a new ASP page to the project.
 * 4) Insert a Data Command Control.
 * 5) Choose the data connection created in step 2 above from the Data Connection drop-down list box.
 * 6) Choose "Stored Procedure" from the "Command Type" drop-down list box.
 * 7) Choose one of the stored procedures available to your database from the Command Text drop-down list box.
 * 8) Save and preview the ASP file.

