Multiple ADO connections

[GhostWolf]

Is there something that limits a program to a single ADO connection?

I'm trying to create a program which opens two ADO connections, (via the Jet driver to an Access database, and via the Client Access driver to an AS/400), concurrently. The Jet connection works just fine, but the CA one doesn't.

The CA connection is opened, but no data is being retrieved.

Other of my programs which use ADO to connect to the same databases separately do exactly what they're written for, but this one...

 

[genomon]

I routinely use multiple connections. If you are absolutely certain the connection is opened, it could be something simple like a mis-spelled table or field name, or SQL syntax in your code. Why not post back an example & we'll have a peek?

Ever notice how fast Windows runs? Me neither.

 

[GhostWolf]

Checking, (in debug mode), shows that the State = 1 for both connections, so I'm pretty sure they're open.

...

Right now I'm feelin' about like an idiot!!

In the process of typing the SQL select statement the program generates I discovered my error - darned wildcards!

I put the wrong one in the AS/400 statement.

Thanks for taking the time to make me look more closely at this.

 

[genomon]

oops......


Ever notice how fast Windows runs? Me neither.