 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Kelvin Taite
Guest
|
 Posted: Wed Aug 18, 2004 1:38 pm Post subject: PRBLM: Multi-ADO connections on one DataModule |
 |
|
Using Delphi 7
I have an application which analyzes data from one SQL server into another
SQL server. To achieve this I have 2 ADO connections which I open at
runtime.
What happens now is the application will report that I am unable to connect
to the second ADO due to Server not found or Invalid password. It makes no
difference which connection is the first to start, the second will always
fail. Both connections use the same userid. At Design time both connect
until I try to run the app.
Anyone else run into this one? Any ideas?
Kelvin Taite
Provincial Airlines Ltd
|
|
| Back to top |
|
 |
Del Murray
Guest
|
| Posted: Wed Aug 18, 2004 10:15 pm Post subject: Re: PRBLM: Multi-ADO connections on one DataModule |
|
|
When you compile the final version of your program, do you make sure that
the "connected" property is set to false in the tADOConnection object ?
Sometimes it can get set to true when fiddleing arround in a dataset that is
using the connection. The failure is then reported because at runtime the
program tries to connect to your test database, which isn't available. ...
Just a guess though
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
