Page 1 of 1

How to connect to ODBC DSN files?

Posted: Fri Nov 04, 2011 9:32 pm
by ouch
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.

Re: How to connect to ODBC DSN files?

Posted: Sat Nov 05, 2011 4:04 am
by DACM
Looks like a bug to me. :(

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.

Re: How to connect to ODBC DSN files?

Posted: Fri Sep 28, 2012 8:46 pm
by au55260
:DJdbcOdbc Dsn connection for Window 7 64 bit machine

follow the following step;

right click on data source (odbc) under administrative tool

go to the properties.and change the following things
target :%SystemRoot%\SysWOW64\odbccad32.exe

start in :%SystemRoot%\SysWOW64

press ander and as admin
regards
anurag Upadhyay(india)

Re: How to connect to ODBC DSN files?

Posted: Wed Aug 28, 2013 6:30 am
by mysorian
The other users have provided the correct answer. ODBC Manager in WIndows 7 (x64bit) comes up with a default. To pick the correct ODBC Manager you type ODBC in Start and you will be shown both of them. You pick the one you want.

If you like a step-by-step guidance follow this link here:
http://hodentekmsss.blogspot.com/2013/0 ... o-sql.html

Of course, the above is for a SQL Server.