How to connect to ODBC DSN files?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
ouch
Posts: 27
Joined: Thu Oct 13, 2011 11:14 pm

How to connect to ODBC DSN files?

Post 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.
OpenOffice 4 on Windows 7 64bit
User avatar
DACM
Volunteer
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: How to connect to ODBC DSN files?

Post 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.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
au55260
Posts: 2
Joined: Fri Sep 28, 2012 8:34 pm

Re: How to connect to ODBC DSN files?

Post 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)
openoffice 3.1 on window 7
mysorian
Posts: 4
Joined: Wed Aug 28, 2013 5:18 am

Re: How to connect to ODBC DSN files?

Post 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.
OpenOffice 4.0 on Windows 7 (x64)
Post Reply