Creating a windows Authentication DSN
This is a discussion on Creating a windows Authentication DSN within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Can this code be changed to use the windows Authentication instead of the SQL Server login? http://www.mvps.org/access/tables/tbl0014.htm...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 10:05 PM
| ||||
| ||||
 Creating a windows Authentication DSN Can this code be changed to use the windows Authentication instead of the SQL Server login? http://www.mvps.org/access/tables/tbl0014.htm      |
|
02-27-2008, 10:05 PM
| ||||
| ||||
| Re: Creating a windows Authentication DSN You need to add the keyword/value of Trusted_Connection=Yes so you could try modifying the SQLConfigDataSource code by including: "Trusted_Connection=Yes" & Chr(0) You can find the ODBC API reference for SQLConfigDataSource at: http://msdn.microsoft.com/library/de...dbc_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 > |
 |
« Changing the database from MSAccess to MSSQLServer.
|
SQL server becomes case sensitive if I choose collation as : Chinese_PRC_BIN »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:51 AM.
