What a right B$#@#(*&$(#
Turns out that once the password has been used to connect, it is no longer
valid and any attempt to reference the "password" in the ado connection
properties causes an Invalid Variant Operation error - It's a ADO thing
nothing to do with Delphi. Setting "Persist Security Info=Yes" does not help
either - This was using SQL server logins not NT logins.
Myles.
> -----Original Message-----
> From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 12, 2000 7:48 PM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: ADO COnnections.
>
> Myles
>
> It's the sort of thing you have to track down to an line of code and
> post a message hoping that Mark Edington will pick up on it
>
> He's preety good on the interesting stuff
>
> Neven+
> ----- Original Message -----
> From: Myles Penlington <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Monday, June 12, 2000 5:46 PM
> Subject: [DUG]: ADO COnnections.
>
>
> > Anybody know the solution to this.
> >
> > Open TADOConnection do stuff Close the connection.
> >
> > Then when attempt to re-open the connection. It all goes to '#%#^ Keep
> > getting "Invalid variant operation". In the TADOConnection.Open method.
> > Any ideas anybody?
> >
> >
> > Regards,
> >
> > Myles Penlington
> > Software Engineer
> > Advanced Management Systems Ltd
> > www.ams.co.nz/email
> >
> > This message is confidential to the person to whom it is addressed. It
> is
> > not to be used, copied or distributed by anyone else. If the message
> has
> > reached you by mistake please contact us immediately and then delete it
> from
> > your system. Thank you for your co-operation.
> >
> >
> >
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> >
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
