SQL Server connect from Linux to Windows 2008by anotherdj (Initiate)
|on Jan 26, 2012 at 15:43 UTC||Need Help??|
anotherdj has asked for the
wisdom of the Perl Monks concerning the following question:
I need some help on how to connect to a SQL Server database from one server to another.
A perl script is on a Ubuntu server which I need to read data from a SQL Server table on another server which is a Windows 2008 R2 64 bit.
On the Ubuntu server DBD::OBDC or DBD::W32OBDC are both installed.
From what I gather is the the connection string involves the creation of a DSN as the data source.
Do I create a DSN on the windows server or do I simply connect to the database with the server ip address and database name.
Usually if I run the script on the same server as the database I simply create the DSN.
Any guidance is appreciated.