Re: problem connecting to ADO programmatically

"William Meyer" <meyer.wil@xxxxxxxxx> wrote in news:4814aaa5$1
@newsgroups.borland.com:

Chris.Cheney wrote:

Hi Bill,

Perhaps your ADOConnCAPWatch component has acquired some custom
settings? With the default component and no connection string, an
error SHOULD occur when it is opened - but you say that there is no
error in this case. Try creating the component dynamically (to be
sure it has no custom settings).

<snip>

I will give it a try with those minimal elements. What I find
interesting now is that I took the string constants from the existing
ConnectString I set with the wizard. If I simply copy that to a local
var and copy the local var back to the ConnectString, all is well. If I
try to make any alteration to the content of the string before
assigning it to ConnectString, I get the error. And of course, that
error message is both misleading and unuseful, as it is a) not a
problem with ISAM, and b) it gives no clue what it's unhappy about .


I suspect that when the original ConnectString was set, it had the side-
effect of setting other values in the component. If you then change the
ConnectString in a manner incompatible with those other values, it causes
errors. It can happen at design time too.

BTW what were the original ConnectString values?

HTH

Chris
.

Relevant Pages