Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Multiple ADO connections

Multiple ADO connections

Multiple ADO connections

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...


RE: Multiple ADO connections

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.

RE: Multiple ADO connections

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.

RE: Multiple ADO connections


Ever notice how fast Windows runs? Me neither.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close