Re: VB and Oracle ODBC

Are you appending an semi-colon to the end of your SQL statements? If so, remove it, especially if you are using SQLPASSTHRU.

Yes, I know it works in SQL*Plus, but it is not necessary, so try not to use it.

-- 
Slainte mhath
Stephen Lappin



> wangsong <wangs_at_cyberway.com.sg> wrote in article


 <324F8B88.149C_at_cyberway.com.sg>...


> Hi, there

> 

> I'm now using VB 4.0 pro to access Oracle database through ODBC and


 encounter following problems. I would be very grateful if you 


> could shed any light on these problems.



SNIP


>      In the loop, I inconsitently get the error code 3146 which mean


 "ODBC call failed". checked the > SQL statement which 


>      cause problem, I found it is a normal statement and works well when


 I run this statement in > SQL PLUS.  


>