Using a DSN-less connection with the Easysoft ODBC-ODBC Bridge
Using a DSN-less connection with the ODBC-ODBC Bridge server (TargetDSN)
This section explains how to use a DSN-less connection to connect to a target DSN when the ODBC-ODBC Bridge server is running on Windows. To do this set the TargetDSN attribute to:
ODBC;key=value
where key=value is the DSN-less connection string to the target ODBC driver. For example, when using the Easysoft ODBC-Oracle WP Driver, your TargetDSN might look like this:
TargetDSN="ODBC;Driver={Easysoft ODBC-Oracle WP Driver};SID=<Oracle SID Name>;UID=<Oracle User>;PWD=<Oracle Password>;Server=<Oracle server IP or DNS Name>;Port=<Port number usually 1521>"
The DSN-less string must be enclosed in double quotes. Any attributes should be semicolon-delimited.
When passing a user name and password, include them in the string using UID and PWD, rather than setting TargetUser and TargetAuth.
You can also include file paths in the DSN-less string. If the file resides on a local drive, reference it using a local path (for example, C:). For files on network drives, use a full UNC path.
Here's an example for an Excel file that's located on a shared network drive:
"ODBC;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=\\\\VBoxSvr\\shared\\Data_Files\\Excel_Contats.xlsx;ReadOnly=Yes"
To get the UNC path of a network folder, run the following in a command prompt:
C:\Users\Richard> net use New connections will be remembered. Status Local Remote Network ------------------------------------------------------------------ V: \\VBoxSvr\tmp VirtualBox Shared Folders W: \\VBoxSvr\shared VirtualBox Shared Folders X: \\VBoxSvr\ownCloud VirtualBox Shared Folders Z: \\VBoxSvr\Dropbox VirtualBox Shared Folders
The Remote column shows the UNC path for each mapped drive.
Important The target ODBC driver's bitness must match the ODBC-ODBC Bridge server's bitness. A 64-bit ODBC driver requires a 64-bit ODBC-ODBC Bridge server. A 32-bit ODBC driver requires a 32-bit ODBC-ODBC Bridge server.
Connecting to the ODBC-ODBC Bridge client with a DSN-less connection
A connection to the ODBC-ODBC Bridge client software can also be established by using a DSN-less connection on any supported platform. The syntax is:
Driver={Easysoft ODBC-ODBC Bridge};ServerPort=<IP>:<PORT>;LogonUser=<Windows username>;LogonAuth=<Windows password>;TargetDSN=<Target DSN Name or DSN-less connection>;TargetUser=<Target ODBC Driver Username>;TargetAuth=<Target ODBC Driver Password>
Note On Linux or UNIX systems, change the Driver attribute from {Easysoft ODBC-ODBC Bridge} to {ODBC-ODBC Bridge} or {ODBC-ODBC Bridge_r} if using the multi-threaded client.