|
| 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.
|
|