Using Visual Basic ADO to Connect to Ingres via ODBC

[Monteleone:Keith]

I am developing a Visual Basic 6.0 Application that uses ODBC to access our
Ingres Database. I am encountering a unique problem in interacting with the
database. The problem is as follows:

I send an SQL statement to ingres through ADO's .execute or .open command,
and it works perfectly fine.
After I have entered a few statements, I will get a syntax error. Based
upon the error messages, I have deducted that parts of the earlier
statements executed have been sent to ingres, along with the new statement.
It is as if the data from the first statement is not being cleared out. Is
there a way to clear it out.

I have checked my sql strings on the VB side, and they are sending the SQL
correctly. The SQL statement leaves the application correctly, but arrives
to oracle with junk data from the previous statement.

Another interesting note is that if I close out of Visual Basic, and open it
back up, the problem is resolved until I run a few SQL statements again.

Any help would be greatly appreciated,

Keith Monteleone

[Bruce Royer]

On 20 Jul 2000 15:33:32 -0500, kmont...@reesebros.com
(Monteleone:Keith) wrote:

We have been using Visual Basic 6 and ADO 2.5 against our Ingres II
databases for a while now but I have never seen this type of problem.

If you could post or send me a code snippet perhaps I can help shed
some light.

What version of ADO and ODBC drivers are you using?
Do you have the latest service packs for Visual Basic 6 (they are up
to service pack 4 now).

Bruce Royer
Systems Analyst
Saskatchewan Energy and Mines
bruce...@sem.gov.sk.ca