Microsoft KB Archive/175090

From BetaArchive Wiki

Article ID: 175090

Article Last Modified on 5/2/2006


  • Microsoft Visual InterDev 1.0 Standard Edition

This article was previously published under Q175090


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

<asp file name and line number>


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'


  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.


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.


For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

Keywords: kberrmsg kboracle kbide kbprb KB175090