MS SQL Server ODBC - Creating a windows Authentication DSN

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Creating a windows Authentication DSN

Chris

2006-01-23, 7:23 am

Can this code be changed to use the windows Authentication instead of the
SQL Server login?

http://www.mvps.org/access/tables/tbl0014.htm

Sue Hoegemeier

2006-01-23, 11:23 am

You need to add the keyword/value of Trusted_Connection=Y
es
so you could try modifying the SQLConfigDataSource code by
including:
" Trusted_Connection=Y
es" & Chr(0)
You can find the ODBC API reference for SQLConfigDataSource
at:
http://msdn.microsoft.com/library/d...odbc_c_99yd.asp

-Sue

On Mon, 23 Jan 2006 11:24:02 -0000, "Chris" <a@b.com> wrote:

>Can this code be changed to use the windows Authentication instead of the
>SQL Server login?
>
>http://www.mvps.org/access/tables/tbl0014.htm
>

Sponsored Links