Tibco ADB Adapter Fun continues (elevation and odbc)
I have no idea why this is occurring as I am an administrator of my PC but it is in a corporate environment. Now I have to right click designer and 'run as administrator' to get the adapter tester to work.
Sadly I then ran into issue #2, upon starting the adapter: Error [Database] AEADB-910007
Very similar to a prior post: http://www.salley.us/cmsic/blog/tibco-error-database-aeadb910007-.aspx
Where I had to go to the 32 bit version of ODBC admin to configure the DSN for 6.2 and earlier ADB versions to be happy.
NOW, 6.3 is looking for the 64 bit version of ODBC admin. So I had to go to the Windows\System32 folder and duplicate my DSN that was created in Windows\SysWoW64
Ughh
http://support.microsoft.com/kb/942976 ODBC Administrator tool displays both the 32-bit and the 64-bit user DSNs in a 64-bit version of Windows.
A 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):
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.