Using AD account to connect to sql server

[Todd Horst]

Using the odbc data direct, provided by infor, you can connect to a MS SQL server using your AD account by setting `AuthenticationMethod=9` in the odbc.ini. Normally its set to 1 for a local sql account.

Im wondering if there is a way to set this in your code rather than in the ini file.

I suspect something like SQLSetConnectAttr but havent figured it out. Any help would be helpful 🙂

Topic

[Jim Kosloskey]

Yes you can. Go to the Progress DataDirect Web site under support and Documentation.

In there you will find the complete documentation for the ODBC Drivers for the various DBs.

Here is the link I got to which shows the allowable attributes:

http://media.datadirect.com/download/docs/odbc/allodbc/#page/odbc%2Fconnection-option-descriptions-for-sql-server-wi.html%23

By the Way, the ODBC Integrations I set up while at MDACC (quite a few) did not use the .ini file for specific target DB references. We did the specification via the Connect String at execution time for a number of reasons.

If you would like to discuss my odbc/Cloverleaf experiences email me.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies