From: Alexander P. <ale...@re...> - 2008-12-08 11:06:39
|
Olaf Kluge wrote: > Hello, > Hi, > I have a problem with the firebird odbc driver. I use a connection with > adodb in microsoft access: (vba) This one is only a test with > test-parameters! > > When I use only a input-parameter, the procedure-call works fine. But the > return-parameter doesn't work, the procedure does not startet. > ADO generates the following statement for ODBC driver in your case - { call TTT(?,?) }. Next Firebird ODBC driver generates statement - select * from TTT(?). Therefore you can not use output parameters but you can use query result set. > If I switch the input/output-parameter (output first), I get an error > message: Laufzeitfehler... [ODBC Firebird Driver]not yet implemented > It is by design. Regards, Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer |