Just another Perl shrine | |
PerlMonks |
Re: DBI connecting to MS SQL Server TLS 1.2by Tux (Canon) |
on Sep 30, 2019 at 07:01 UTC ( [id://11106859]=note: print w/replies, xml ) | Need Help?? |
I recently worked from perl on Linux with a MS SQL server database, and got the best results with FreeTDS:
The biggest difference between FreeTDS and the MS ODBC driver is the return type of UUID field. The MS ODBC does not allow nested queries, whereas the FreeTDS driver does. So I used the ODBC driver to make a CSV dump of the database and the FreeTDS driver to actually work with the database. For ODBC I did
Also make sure you put the fully qualified hostname in the server name. localhost will not work. Enjoy, Have FUN! H.Merijn
In Section
Seekers of Perl Wisdom
|
|