Re: Stored Procedures

Thanks for your help! I don't want to be a pest but you might know the answer. I have tried your suggestion and I am getting the following error: [Informix][Informix ODBC Driver][Informix]Routine (ebbspdb) can not be resolved. Do you know what this means? Thanks Peter pczurak@bigfoot.com "Eric Dupuis" <Kratka@crosswinds.net> wrote in message news:3978b9b4_2@corp.newsfeeds.com... > I use VB and ADO 2.x through ODBC to connect to > Informix Dynamic server 7.31. The only way that I found to use stored > procedures is to create a recordset and open it using a SQL command that > executes the sp. Here's some sample code: > > Set adoRecSP = New ADODB.Recordset > strSQL = "execute procedure sp_dosomething(" & strSomeParameter & > ")" > > 'execute the statement > adoRecSP.Open strSQL, adoConn, adOpenStatic, adLockOptimistic, > adCmdText > > lngSomeReturnValue = adoRecSP.fields(0).value > strSomeOtherReturnValue = adoRecSP.fields(1).value > > adoRecSP.Close > set adoRecSP = nothing > > > I have had problems with Informix's and Merant's OLEDB drivers, and was > unable to use ADO's command object successfully with an Informix database. > > Eric > ----------------------- > > Peter Czurak <pczurak@bigfoot.com> wrote in message > news:snh7pqfh6tt16@corp.supernews.com... > > Does anyone know how to call stored procedures in Informix through VB6.0 / > > ADO2.1 (What is the syntax). The stored procedure was created and can be > > run in DBAccess, but I can not see the procedure through ODBC driver. > > > > Thanks > > > > Peter > > pczurak@bigfoot.com > > > > > > > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Peter, Is that the correct name of the procedure? Can you execute it in dbaccess on the server side? You might want to try the Openlink drivers at www.openlinksw.com if this is a driver-specific problem. Their drivers work well with sp's Regards, Stephen In article <snhgckah6tt162@corp.supernews.com>, "Peter Czurak" <pczurak@bigfoot.com> wrote: > Thanks for your help! > > I don't want to be a pest but you might know the answer. I have tried your > suggestion and I am getting the following error: > > [Informix][Informix ODBC Driver][Informix]Routine (ebbspdb) can not be > resolved. > > Do you know what this means? > > Thanks > > Peter > > pczurak@bigfoot.com > > "Eric Dupuis" <Kratka@crosswinds.net> wrote in message > news:3978b9b4_2@corp.newsfeeds.com... > > I use VB and ADO 2.x through ODBC to connect to > > Informix Dynamic server 7.31. The only way that I found to use stored > > procedures is to create a recordset and open it using a SQL command that > > executes the sp. Here's some sample code: > > > > Set adoRecSP = New ADODB.Recordset > > strSQL = "execute procedure sp_dosomething(" & strSomeParameter & > > ")" > > > > 'execute the statement > > adoRecSP.Open strSQL, adoConn, adOpenStatic, > adLockOptimistic, > > adCmdText > > > > lngSomeReturnValue = adoRecSP.fields(0).value > > strSomeOtherReturnValue = adoRecSP.fields(1).value > > > > adoRecSP.Close > > set adoRecSP = nothing > > > > > > I have had problems with Informix's and Merant's OLEDB drivers, and was > > unable to use ADO's command object successfully with an Informix > database. > > > > Eric > > ----------------------- > > > > Peter Czurak <pczurak@bigfoot.com> wrote in message > > news:snh7pqfh6tt16@corp.supernews.com... > > > Does anyone know how to call stored procedures in Informix through VB6.0 > / > > > ADO2.1 (What is the syntax). The stored procedure was created and can > be > > > run in DBAccess, but I can not see the procedure through ODBC driver. > > > > > > Thanks > > > > > > Peter > > > pczurak@bigfoot.com > > > > > > > > > > > > > > > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > > Sent via Deja.com http://www.deja.com/ Before you buy.