Hi,

I want to connect to SQL server 7 using trusted connection. I looked up
Borland knowledge base and there was a document that suggested passing a
blank user name and password while making connection uses trusted
connection. I tried that in database component and also Database Explorer.
When the user name is null, BDE replaces that with "MYNAME" and when it is
zero length string the connection fails.

What should I do to connect to SQL Server 7 using trusted connection (Not
passing user name and password).

Thanks,
Ali Malekshahi

You must remove the user name from the alias that you are configuring.

In addition, you should go to the Configuration tab in the BDE Adminitrator,
then locate the driver entry for MSSQL.  You need to remove the user name
from there as well.  The BDE seems to use that as a default user name if you
don't remove it.

Also, at least with MS SQL 6.5... you need to have the client computer
configured to use a protocol that supports trusted connections: "Named
Pipes" or "Multi Protocol" (not "TCPIP").

Hope this helps...

<Randy>