in reply to Re^5: install_driver(ODBC) mac mojave 10.14.2
in thread install_driver(ODBC) mac mojave 10.14.2

i did this in terminal:

export DBI_DSN=dbi:ODBC:<dbname>


in the perlscript i use this (works under windows):

my $myConnection = DBI->connect("dbi:ODBC:Driver={SQL Server};SERVER=<
+db dsn>; database=<dbname>; PORT=<xxxx>;UID=$username;PWD=$password")
or die "Error connection to databse $DBI::errstr";

if i execute it i get this:

DBI connect('Driver={SQL Server};SERVER=db dsn>; database=<dbname>; PO
+RT=<xxxx>;UID=<user>;PWD=<pw>','',...) failed: [unixODBC][Driver Mana
+ger]Can't open lib 'SQL Server' : file not found (SQL-01000) at testp
+erldb.pl line 10.
Error connection to databse [unixODBC][Driver Manager]Can't open lib '
+SQL Server' : file not found (SQL-01000) at testperldb.pl line 10.

[download]

Replies are listed 'Best First'.
Re^7: install_driver(ODBC) mac mojave 10.14.2
by marto (Cardinal) on Jan 22, 2019 at 08:10 UTC

    "works under windows"

    You aren't doing this under windows :) . Check odbcinst.ini there should be a driver name, if this differs from 'SQL Server' use this. I think this should be documented somewhere in the unixodbc docs/driver pages.

[reply]
[d/l]
       
looks like there is no driver installed:

DESKTOP-J2QR254:~ raventheone$ more .odbcinst.ini
[ODBC Drivers]

[ODBC Connection Pooling]
PerfMon    = 0
Retry Wait =

      [download]
[reply]
[d/l]
[reply]
[d/l]

In Section Seekers of Perl Wisdom