Call Stored Procedure by MS-Access?

Posted in 2003

Andreas Schlegel — Fri, 23 May 2003 15:24:31 +0200 — source: Usenet: comp.databases.informix

Hi, I just tried to execute an Informix stored procedure calling it from MS-Access. But I always get the ODBC error 3146. My code: Set ws = CreateWorkspace("wmk", "admin", "", dbUseODBC) Set conn = ws.OpenConnection("conn1", dbDriverNoPrompt, False, "ODBC;DATABASE=smart;UID=informix;PWD=informix;DSN=test") conn.Execute "sp_test", dbExecDirect This code works fine with SQL-Server. May be someone has some experience in using Informix and Access together. Greetings, Andreas