[unixODBC-support] How to odbc.ini and odbcinst.ini -- or how to Server=??? in DSN-Less connect

Dan Wierenga dwierenga at valueclick.com
Tue Jun 3 00:24:34 BST 2008


Hi Michael,

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com [mailto:unixodbc-support-
> bounces at easysoft.com] On Behalf Of Mich 
> Can anyone post an actual working set of config (odbc.ini,
> odbcinst.ini) files for unixODBC built against freeTDS (0.6x) with a
> Driver={XXX} in a SQLDriverConnect call (via perl-dbi, ideally) that
> works, that I can adopt for a test?
> 

With odbcinst.ini defined as 

[FreeTDS]
Description  = FreeTDS driver for MS SQL Server or Sybase databases
Driver       = /usr/lib/libtdsodbc.so.0

Use:

my $dbh =
DBI->connect('dbi:ODBC:Driver=FreeTDS;Server=some.server.com;port=1433',
$user, $password);


HTH,
Dan




More information about the unixODBC-support mailing list