Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re^5: install_driver(ODBC) mac mojave 10.14.2

by Corion (Pope)
on Jan 21, 2019 at 19:10 UTC ( #1228776=note: print w/replies, xml ) Need Help??

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 line 10. Error connection to databse [unixODBC][Driver Manager]Can't open lib ' +SQL Server' : file not found (SQL-01000) at line 10.

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

        looks like there is no driver installed: DESKTOP-J2QR254:~ raventheone$ more .odbcinst.ini [ODBC Drivers] [ODBC Connection Pooling] PerfMon = 0 Retry Wait =

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1228776]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2020-08-13 02:37 GMT
Find Nodes?
    Voting Booth?
    Which rocket would you take to Mars?

    Results (69 votes). Check out past polls.