Good morning/evening!

I have D6 build 6.163 and a problem...
My MS SQL server is configured for Windows Authentication, so I can't
connect from BDE via SQL Links to Database. I got "Not associated with a
trusted SQL Server connection" error message, but ADO components are working
fine.
I'm going to use TDatabase component with StartTransaction-Commit methods,
so ADO isn't i need.
What have I to do to solve my problem?

Jaroslav Demin

I'm using ado last year, but, this code will working ok with D5 & SQL 7
look part 5 x Editnn.Text ...

GL

  with DB.Params do
  begin
    Clear;
    Add('APPLICATION NAME=');
    Add('BATCH COUNT=200');
    Add('BLOB EDIT LOGGING=');
    Add('BLOB SIZE=32');
    Add('BLOBS TO CACHE=64');
    Add('DATE MODE=0');
    Add('ENABLE BCD=FALSE');
    Add('ENABLE SCHEMA CACHE=FALSE');
    Add('LANGDRIVER=');
    Add('MAX QUERY TIME=300');
    Add('MAX ROWS=-1');
    Add('NATIONAL LANG NAME=');
    Add('OPEN MODE=READ/WRITE');
    Add('SCHEMA CACHE DIR=');
    Add('SCHEMA CACHE SIZE=8');
    Add('SCHEMA CACHE TIME=-1');
    Add('SQLPASSTHRU MODE=SHARED AUTOCOMMIT');
    Add('SQLQRYMODE=');
    Add('TDS PACKET SIZE=4096');

    Add('DATABASE NAME=' + EdServer.Text);
    Add('HOSTNAME=' + EdHost.Text);
    Add('SERVER NAME=' + EdServer.Text);
    Add('USER NAME=' + EdUser.Text);
    Add('PASSWORD=' + EdPassw.Text);

  end;
  DB.Open;

news:3c0e3eef_2@dnews...

For me it's working only if your alias in client of mssql is configured for
using named pipe
and your are leaving USER NAME and PASSWORD blank (null).

"Jaroslv Demin" <jde...@hotmail.com> a crit dans le message de news:
3c0e3eef_2@dnews...

in other terms :
You have to make sure that the Sql Client
Configuration is set to default to Named Pipes in order to use Trusted
Connections.

"Philippe Makowski" <makow...@a6cmo.fr> a crit dans le message de news:
3c0ea5b8_2@dnews...

Thank you Philippe!
All are working fine!
Jaroslav Demin

news:3c0ea6cf_2@dnews...