I did an install of SQL Anywhere 12 on a Windows 7 box (full install with all components - both 32 bit and 64 bit). No errors and everything works fine in the 64 bit arena. However I have a 32 bit database that I need to work with and I can not set it up in the ODBC administrator (32 bit one).
The problem has boiled down to the fact that the 32 bit driver is not installed (regedit did not show it as being there).
The file is there in the ...SQL Anywhere 12bin32 directory along with dbcon12.dll.
I tried doing regsvr32 dbodbc12.dll and got the error "... module ... dbodbc12.dll was loaded but the call to the DLLRegisterServer failed with error code 0x8000ffff."
I did sfc /verifyonly and no errors were reported.
I am stuck and would appreciate any advice.
asked 01 Feb '13, 15:02
We have heard reports from other customers that some third-party ODBC drivers can obscure or conflict with more "recently" installed ODBC drivers in the ODBC registry (by either corrupting the index or by simply being misconfigured).
There is a support article from DataDirect about the improper registry configuration behaviour with their ODBC drivers.