Using SQL Server 6.5, Delphi 3.02 C/S

Does anyone know why Delphi cannot connect to SQL Server 6.5 via trusted
connection when using the native MSSQL database driver name?

When I try this I get the standard database invalid login message:
"Unknown user name or password"  BDE error 10036.

However, when I try this with an alias setup for the ODBC driver, it works
fine for both trusted and standard login.

 Is there a way for Delphi to login to SQL Server via both trusted and
standard methods using the native driver?

All help appreciated - thanks!
SteveC
sclaf...@ozemail.com.au

I have not tried this, but here goes.

The trusted connections will only work with te following network
protocols -- named pipes and MultiProtocol. None of the other ones support
trusted connections. The ODBC and DBlib can also be set up to use trusted
connections.

The other thing is, what do you mean by trusted. I am assuming that you mean
Integrated security ie where NT will do the logon to the SQL server based on
the NT user ID.

Hope this helps
George Aligianis

I tried this with SQLserver 6.5 using named pipes, and it DOES NOT WORK.

This is not a SQLserver issue.  This used to work with SQL Links, and SQL
Server 6.5 it does not work with the current version of SQL Links.

Do we have to go back to ODBC to get a trusted connection (yes, a trusted
connection means integrated security, a feature in SQL server that allows
security to be based upon a persons network login).