Why is FRx behaving like the ODBC data source is set to SQL authentication when you know you set the data source to Windows authentication?
We have run into instances where one computer has two data sources with the exact same name. One of the data sources was created in the 32-bit ODBC data source administrator and the other created in the 64-bit ODBC administrator.
FRx is a 32-bit application that uses 32-bit ODBC data sources. In the FRx Company Information window, when you click the Define button on the Company Specific Information tab it will pull up the 32-bit ODBC data source administrator. Be sure to properly open and define the correct 32-bit ODBC data sources that FRx will use.
The 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe): http://support.microsoft.com/kb/942976
· The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
· The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.