SQL/BDE Trusted SQL Connection
Hi All,
I have written a system in Delphi 5, the database backend being SQL Server
7.
I connect using the BDE ....... There are 40 user workstations that
successfullly connect to the server and the application runs with no
difficulty.
2 machines were redone, FORMAT & RE-INSTALL. The operating System loaded is
Windows 2000, BDE is loaded but the application refuses to connect
generating an error:
LOGIN INCORRECT ....
LOGIN FAILED
Unable to establish a trusted sql server connection. User "MYNAME"
incorrect.
I use the follwoing code to connect to the db:
Database1.KeepConnection := False;
Database1.Connected := False;
Database1.params.clear;
Database1.params.Add('USER NAME=');
Database1.params.Add('PASSWORD=');
Database1.params.Add('DATABASE NAME='+edtDatabaseName.Text);
Database1.params.Add('SERVER NAME='+edtServerName.Text);
Database1.params.Add('MAX QUERY TIMEOUT=-1');
Database1.params.Add('HOST NAME=' + UpperCase(BDEInfo1.NetUser));
Database1.params.Add('TIME OUT=-1');
Database1.Connected := True;
Any ides ??
Regards