Re: Call Stored Procedure by MS-Access?

Posted in 2003

Andreas Schlegel — Fri, 23 May 2003 17:25:12 +0200 — source: Usenet: comp.databases.informix

Sorry for the thread. Everything works fine if I add the two words "execute procedure" in front of the procedures name. Please forgive ;-) Andreas Schlegel wrote: > 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 >