GasGiant
|
Recently, two IS Tech customers have had trouble connecting to ODBC because the system DSN for Pervasive does not show up in Data Sources. As it turns out, both locations had updated to Win2008 with 64-bit. Last night I found the answer to the problem on the Tek Tips forum. Simply put, Pervasive 10.10, though it has a much improved and built in ODBC, has no 64 bit ODBC. The 32-bit ODBC support must be installed as a separate function from the Pervasive install. Here is the quote from tek-tips.com: "You'll need to use the 32 bit ODBC Administrator. It's in the C:\WINDOWS\SYSWOW64 directory. You can also create the DSN/DBN through the PCC. The 64 bit PSQL engine is 64 bit for Btrieve only. The ODBC is still 32 bit. " Another issue is that you must be an "elevated administrator" for Win2008/Vista in order to perform system DSN functions.
|