Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple ADO connections

Status
Not open for further replies.
GhostWolf

GhostWolf

Programmer
Joined
Jun 27, 2003
Messages
290
Location
US
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...

 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
oops......
[dazed]

Ever notice how fast Windows runs? Me neither.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question Question
Parsing Names in multiple formats
Replies
5
Views
844
SaltyTheFrog
SaltyTheFrog
Swi
  • Locked
  • Question Question
Adobe SDK
Replies
6
Views
502
Swi
Swi
Swi
  • Locked
  • Question Question
Reading Tab Delimited File Using ADO
2
Replies
20
Views
2K
Swi
Swi
kskinne
  • Locked
  • Question Question
help with code used to update multiple records from datagrid
2
Replies
33
Views
2K
Andrzejek
Andrzejek
malaygal
  • Locked
  • Question Question
Create Excel file and add multiple worksheets
Replies
6
Views
682
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top