Re: Using TADOConnection with MSSQL, login failure

srdaniel has brought this to us :
I finally got a TADOConnection object to connect to my MSSQL database at design time. I can even hook up a TADODataSet->TDataSource->TDBGrid and see data.

However if I try to run the application (Delphi7) I get an error: "Login failed for user XYZ"

Why does it work at design time but not run time? Any ideas?

srdaniel

Firewall. Very strict policy which does not allow connections to programs that are not specifically allowed to connect.

There is not other reason I could think off.

Regards
Yannis.


.

Relevant Pages

  • Re: Using TADOConnection with MSSQL, login failure
    ... You are connecting differently at run-time than at design time? ... using NT-Authentication and running the app on a machine (or user login) ... Your setup sounds straight forward enough, so unless you have gremlins ...
    (borland.public.delphi.database.ado)
  • Re: INSERT command doesnt work in Access
    ... > The reason I am using this is rather to allow quick assessment of ... > meaning of fields in complex query at design time not at run time. ... Why would I use notepad for any real development? ... if you are the only one use a database its merely a personal preference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DataGridView.CurrentCell bug?
    ... Well, as is often the case I have found the cause, but not the reason. ... At design time I set grdMain's ContextMenu to cmsGrid. ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: INSERT command doesnt work in Access
    ... The reason I am using this is rather to allow quick assessment of meaning of ... fields in complex query at design time not at run time. ... but imagine that someone uses date in text format for some reason. ... One of reasons Microsoft advices against hungarian notation now (yet 3-5 ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Aligning Controls at Designtime
    ... much whatever panels or forms you choose at design time. ... Hmmm. ... One more reason for me to start looking at Delphi... ...
    (microsoft.public.vb.general.discussion)