How to connect to ODBC DSN files?
How to connect to ODBC DSN files?
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
Re: How to connect to ODBC DSN files?
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.
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
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: How to connect to ODBC DSN files?
JdbcOdbc 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)
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
Re: How to connect to ODBC DSN files?
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.
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)