local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
Message Boards
Sign up Latest Topics

  Author   Comment  

Posts: 22
Reply with quote  #1 

Why is FRx behaving like the ODBC DSN is set to SQL authentication when you know you set it to Windows authentication?


I have run into instances where there is a 32-bit ODBC DSN and a 64-bit ODBC DSN set up with the same name.

The 64-bit DSN is set to Windows authentication and the 32-bit DSN is set to SQL authentication.


On 64-bit servers, there are two ODBC Administrators, one 64-bit and one 32-bit. The FRx Company Information screen will display the information from the 32-bit ODBC Administrator in the Data Source Name drop down. Clicking on the Define button will bring up the 32-bit Administrator. The 64-bit ODBC Administrator will be displayed if it is started from the Start menu. This may cause confusion, because the list of ODBC Data Sources may be different in the 32-bit than the 64-bit ODBC Administrators. This can cause a DBA to set up another DSN with the same name in the 64-bit ODBC Administrator.

C:\Windows\SysWOW64\odbcad32.exe (32-bit ODBC administrator that can be opened)

Penny Watts of the MSX Group
Previous Topic | Next Topic

Quick Navigation:

Easily create a Forum Website with Website Toolbox.