RE: Oracle 7.3 + ASP/ADO not running a stored procedure ( error '80040e14' )

In the open statement, without providing the Provider=   information and also instead
of using Data Source option , use DSN=(your ODBC source name) and try. As I have used 
like that and it works fine for me ( the environment being Oracle 7.3 or Oracle 8.0.5
and Microsoft ADO 2.6 Objects library ).

 If this gives you a problem you might need to get the ORAOLEDB provider for Oracle 7.3
and then use the actual database name from the tnsnames.ora file and then give the
Oracle ORAOLEDB provider string name for Provider=  option.

 Good luck!!!

Pankaja
-----Original Message-----
From: Iain Meakin [mailto:[email protected]]
Sent: Thursday, December 19, 2002 12:01 PM
To: Oracle
Subject: [oracle] Oracle 7.3 + ASP/ADO not running a stored procedure (
error '80040e14' )



Hello everybody.  ANy help with this would be appreciated !

Opening oracle connection thus:
SQL_CN2.Open "Provider=MSDAORA.1;Data Source=pimsproduction;User ID={ID};Password={PWD}"

strSqlStatement = "execute test_proc"

Set Comm = Server.CreateObject("ADODB.Command")
  Set comm.ActiveConnection = SQL_CN2
  Comm.CommandType = adCmdStoredProc
  Comm.commandtext = strSqlStatement
Comm.execute


"test_proc" is a simple procedure that does returns no data, and has no parameters, and works OK in SQL*Plus, but from the above ASP code I get:

Microsoft OLE DB Provider for Oracle error '80040e14' 
Syntax error in {call...} ODBC Escape. 

I am completely stuck !  Is it the way I am opening the connection ?

Any help appreciated !

Iain





---------------------------------
With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].