Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^6: install_driver(ODBC) mac mojave 10.14.2

by raventheone (Novice)
on Jan 22, 2019 at 07:27 UTC ( #1228796=note: print w/replies, xml ) Need Help??


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.

Replies are listed 'Best First'.
Re^7: install_driver(ODBC) mac mojave 10.14.2
by marto (Archbishop) 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.

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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2019-12-07 18:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (162 votes). Check out past polls.

    Notices?