Does anyone know if there is a free ODBC bridge or an otherwise method
of connecting to a remote ODBC DSN (like if I wanted my linux system to
connect to a ODBC DSN on a windows machine) ? The likes of OpenLink and
Easy ODBC (or whatever its called) are so over priced it's just
ridiculous, possibly even complete rip off... $800 us for a stinkin odbc
bridge... when you can get over drivers completely for free... (what the
hell happened to open course???)

Also, I have UnixODBC on my linux system, I have MyODBC working on there
along with a couple other test DSN's, but if I try

/usr/local/src/odbcsdk/examples/odbctest

or

/usr/local/src/odbcsdk/examples/odbctestw

I get nothing if I try to list:
<odbctest output>
OpenLink ODBC Unicode Demonstration program
This program shows an interactive SQL processor

Enter ODBC connect string (? shows list): ?

DSN                            | Driver
---------------------------------------------------------------
</odbctest output>

I tried exporting env vars:

ODBCINI=/usr/local/etc/odbc.ini
ODBCSYSINI=/usr/local/etc

where /usr/local/etc/odbc.ini is a symlink to /etc/odbc.ini

Why wont odbc show anything?

Seems to be the same deal with isql:

<isql output>
isql -v mytestmysqldb
[unixODBC][Driver Manager]Data source name not found, and no default
driver specified
[ISQL]ERROR: Could not SQLConnect
</isql output>

And yes mytestmysqldb is an actual DSN (using MyODBC driver). Using
ODBCConfig (gui utility) I can see the DSN's and drivers just fine, and
if I open DataManager I can open that DSN and browser the tables just
fine so I know the DSN is setup correctly.

Thansk for any help.

[ Post a follow-up to this message ]