Re: TADOConnection LogInPrompt

Typical, two minutes after I post (having spent a happy couple of hours
trying to figure it out for myself) I notice I've used a TADOConnection and
a TQuery rather than TADOQuery. Corrected this and everything works as
expected. Sorry for the trouble.

--
Ken Davies

"Ken Davies" <krdavies@xxxxxxxxxxx> wrote in message
news:4400a3f4@xxxxxxxxxxxxxxxxxxxxxxxxx
I've just received and installed Delphi 2006 Professional. Everything went
perfectly with the install so I tried creating a small test database
program. This works except that despite setting loginprompt to false on
the ADOConnection, when I run the program it's still asking for the
username and password (which I've set in ConnectionString). The
interesting thing is that if I set loginprompt to true then I get the
dialog twice. It's as if the ADOConnection and the ADOQuery are both
asking for a user name and password if loginprompt=true but only the
ADOQuery is if loginprompt=false. Any idea what I've missed?

I should mention that I've been using Delphi since version 2 (and Turbo
Pascal before that) and I've been using ADO components to access Access
databases since D7 so hopefully I've not done anything truly daft.

TIA

Ken Davies




.

Relevant Pages

  • Re: How to access MSSQL through ISAPI Filter?
    ... First I thought I also had to use a Critical Section but it seems that Critical Sections are not necessary because the adoConnection and adoQuery variables in your example are local variables. ... Here, adoConnection, adoQuery and CS are global vars, I thought I ... could reuse these connections. ...
    (borland.public.delphi.database.ado)
  • Re: How to access MSSQL through ISAPI Filter?
    ... Kees de Winter wrote: ... adoConnection:= TAdoConnection.Create; ... Here, adoConnection, adoQuery and CS are global vars, I thought I ... What am I doing wrong (using Delphi 5 ...
    (borland.public.delphi.database.ado)
  • Connections with Gupta hangs
    ... I create a ADOConnection and then I execute an ADOQuery. ... the ADOQuery and the ADOConnection and move on to the next store. ... ADOStoreConnection.CursorLocation:= clUseClient; ...
    (borland.public.delphi.database.ado)
  • How to access MSSQL through ISAPI Filter
    ... procedure InitializeDBConnection; ... adoConnection:= TAdoConnection.Create; ... adoConnection.ConnectionString:= GetConnStringFromRegistry; ... Here, adoConnection, adoQuery and CS are global vars, I thought I could ...
    (borland.public.delphi.database.ado)