Re: Using TADOConnection with MSSQL, login failure

srdaniel,

You are connecting differently at run-time than at design time? You are
using NT-Authentication and running the app on a machine (or user login)
that does not have access to the target SQL server? Gremlins have taken over
your servers and playing games with you?
Your setup sounds straight forward enough, so unless you have gremlins
running around causing trouble (those little green guys certainly can),
there has to be a simple piece of the puzzle being overlooked (ex. OnCreate
event of the form/datamodule you change/clear the
TADOConnection.ConnectionString property)

Good luck,
krf


"srdaniel" <daniel.raith@xxxxxxxxx> wrote in message
news:465c9c64$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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


.