How to connect to ODBC DSN files?
Posted: Fri Nov 04, 2011 9:32 pm
How can you connect with these? They don't show up on the odbc browse list, nor does base recognize the file format as ODBC Settings.
Or perhaps OOo/LibO simply doesn't support "File DSN" connections.
As a workaround, setup a "User DSN" or "System DSN" in the system ODBC Data Source Administrator.
As a Windows 7 64-bit user you might have installed both 64-bit and 32-bit versions of the ODBC driver. That's fine -- I have both versions of the Firebird ODBC driver installed. But Base does require the 32-bit driver because Base is a 32-bit app. According to these ODBC driver experts, Windows is smart enough to handle the versions; a 32-bit application will automatically be directed to the 32-bit driver, while a 64-bit app will always use the 64-bit version. And they mention that you can access specific versions of the Windows ODBC Data Source Administrator as follows (but apparently either will suffice due to Windows awareness):
To setup a 64-bit ODBC DSN run: Control Panel > System and Security > Administrative Tools > Data Sources (ODBC) > Drivers (tab)
To setup a 32-bit ODBC DSN run: %windir%\syswow64\odbcad32.exe
Either way, Base opens the applicable system ODBC Data Source Administrator as follows:
New > Database > Connect to an existing database > ODBC > Next > Browse > Organize...
OR
Edit > Database > Connection Type... > ODBC > Next > Browse > Organize...
Otherwise, if your purpose for using "File DSN" was to avoid ODBC driver installation and the associated registry entries, then consider JDBC which requires neither.
JdbcOdbc Dsn connection for Window 7 64 bit machine