Page 1 of 1

Windows Authentication Mode

Posted: Thu 21 Dec 2006 08:53
by corneliusd
I'm upgrading a VCL.NET application from Delphi 2005 Arch to Delphi 2006 Pro and evaluating the dbExpress driver for SQL Server 2000. I was using Borland's dbExpress driver in the earlier Delphi, of course, and have been connecting to SQL Server via Windows Authentication so I wouldn't have to store any username/password in an .INI file as I move between two different development environments and my client's installation.

Now, with CoreLab's dbExpress, I don't see the "OS Authentication" parameter available and AFAIK I must now pass in a username/password. Is there a way to force this option in code? Or is it just not supported at all? If it's not supported currently, will it be in the future?

Thanks!

Posted: Thu 21 Dec 2006 16:22
by Jackson
If User_Name parameter of the TSQLConnection object is not set (User_Name=''), Windows Authentication connection mode is used.

Posted: Thu 21 Dec 2006 17:13
by corneliusd
Excellent! That worked!

I finally found the mention for it in the ReadMe.HTML file.


Thanks much for the quick reply.