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

Yay, you've compiled the stuff, so that's a first good step!

The next step is to set up the DBI_ environment variables as documented in the DBI documentation. Likely, this is some database user, password and dbi:ODBC:some-odbc-dsn according to what you have available in your environment.

Replies are listed 'Best First'.
Re^6: install_driver(ODBC) mac mojave 10.14.2
by raventheone (Novice) on Jan 22, 2019 at 07:27 UTC 
    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]
[reply]
[d/l]

      "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]

In Section Seekers of Perl Wisdom