UnixODBC ODC Bridge and "odbctest" question

From: 187 (bigal187.invalid_at_adexec.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 12:33:51 -0800

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.

Relevant Pages

  • Re: Excel cant find FileMaker Pro Files
    ... Excel) as a front end to other databases via ODBC. ... product for using FMP as a data source, mainly because FileMaker Inc ... makes their own driver available for free. ... DSN parameter values, since the driver doesn't include a DSN setup ...
    (microsoft.public.mac.office.excel)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • ODBC Data Source Administrator error
    ... I am getting an error any time I try to adjust my Data Soucre (ODBC) settings. ... Actually I am unable to open any of the DSN connections under User DSN and ... Driver ODBC driver could not be found. ... How do I reinstall these drivers? ...
    (microsoft.public.data.odbc)
  • Re: Configuring FM 9.0 Adv. as ODBC Datasource on Leopard?
    ... in Leopard) to set up a DSN to access FM through SQL? ... that the Sequelink driver is only tested with 1.0.1, ... I have also been unsuccessful in my attempts to setup a DSN to an ODBC ...
    (comp.databases.filemaker)
  • Re: SQLAllocHandle Errort
    ... > Set DConnect = Server.CreateObject ... > [ODBC Driver Manager] Driver's SQLAllocHandle on ... > I have made the dsn using Microsoft ODBC for Oracle 2.573.9030 ...
    (microsoft.public.inetserver.iis)