Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: Using DBD::ODBC and cygwin to connect to MS SQL?by genio (Beadle) |
on Jul 13, 2016 at 21:34 UTC ( [id://1167735]=note: print w/replies, xml ) | Need Help?? |
To explain this a bit, you need two things outside of Perl, FreeTDS, and iODBC/UnixODBC. I use UnixODBC, so setup for iODBC may vary slightly. FreeTDS is the driver you'll use to actually handle the connection to the database via ODBC. Given that, you have to tell UnixODBC how to use the installed FreeTDS driver.
· Once FreeTDS is installed, make sure it is installed to work with UnixODBC via tsql -C
Then, your connection string will be as follows in Perl:
Once you get things working, please line out the steps for me and I will update the gist here: https://gist.github.com/genio/7c7fc52fcb8be5d486aa to reflect this environment's process.
In Section
Seekers of Perl Wisdom
|
|