create procedure error with ODBC-connection
Posted in 2000
Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Server Administration, Versions, Editions & End-of-Life
Hi all,
i am an informix newbie and i'm now at the end of my alternatives with this
problem:
I want to create a stored procedure like e.g.
CREATE PROCEDURE test() END PROCEDURE;over an ODBC-sql connection. I receive the following error message:
"Error: General error.Syntax error (State:37000, Native Code:
FFFFD4CC)".
An ODBC-trace delivers:
"DIAG [37000] [Informix][Informix ODBC Driver]General error.Syntax error
(-11060)"
which gives no detailed error description in the Informix Find Error
helpfile.
It seems to me, that this is no server error message, but an ODBC-client
error.
Registering the stored procedure via dbaccess on the server is no problem,
but i don't want to give remote access for users to the server.
So, is it generally possible to create procedures via ODBC-Connections? If
not, which dbaccess-like client tool is available which connects native to
the Informix CLI-driver? Exists any other possible solutions?
Serversystem:
WinNT 4.0 Server, SP6a, IDS 7.31.TC7
Clientsystems:
WinNT 4.0 Workstation, SP6a, Client SDK 2.50 TC2, MDAC 2.60.6526.3,
Winsql 3.5.11
Any suggestions and help is widely welcome!
Thanks alot,
Bodo
--
Dipl. Wirtsch.Inf. Bodo H'semann
Westf. Wilhelms-Universit't M'nster ' Institut f'r Wirtschaftsinformatik
Steinfurter Stra'e 109 ' D-48149 M'nster
Phone (+49) 2 51.83 38 - 154 ' Fax (+49) 2 51.83 38 - 159
WWW http://dbms.uni-muenster.de/staff/person.php3?id=10