Windows Authentication Mode

corneliusd · Post by **corneliusd** » Thu 21 Dec 2006 08:53

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!

Jackson · Post by **Jackson** » Thu 21 Dec 2006 16:22

If User_Name parameter of the TSQLConnection object is not set (User_Name=''), Windows Authentication connection mode is used.

corneliusd · Post by **corneliusd** » Thu 21 Dec 2006 17:13

Excellent! That worked!

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

Thanks much for the quick reply.