Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: SQL Server connect from Linux to Windows 2008

by mje (Curate)
on Jan 27, 2012 at 10:00 UTC ( #950302=note: print w/replies, xml ) Need Help??

in reply to SQL Server connect from Linux to Windows 2008

You can't use w32ODBC on Linux. You have 3 choices. DBD-Sybase (some restrictions on what you can do - read DBD::Sybase) and freeTDS/sybase libraries, DBI-ProxyServer (you'll need Perl on the Windows machine and it also has some restrictions) or DBD-ODBC, unixODBC and an ODBC Driver. freeTDS comes with an ODBC driver or there are a number of commercial ones. All this is covered in DBD::ODBC's FAQ linked to above including Do I need an ODBC driver?, What is the ODBC driver manager?, Where do I get an ODBC driver manager for Unix/Linux?, How do I access a MS SQL Server database from Linux/UNIX?

If you go the ODBC route and your using your own Perl instead of the system one you'll need to install the unixodbc package and the unixodbc-dev package before making DBD::ODBC yourself or just install everything via the package manager into the system Perl.

You could have easily found all this out yourself by searching for your question on Perl Monks before posting or by reading the FAQ for DBD::ODBC.

  • Comment on Re: SQL Server connect from Linux to Windows 2008

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://950302]
[GotToBTru]: late to the conversation .. but thanks, Corion, for the reminder about Perl::Tidy
[Corion]: GotToBTru: Heh ;) I'm not really endorsing it, as I found that any gains made through it are easily squandered by the hours spent on configuring it. At least in my case :)
[GotToBTru]: Like most Swiss Army Knives, you can cut yourself trying to find the blade you actually want
[GotToBTru]: i am satisfied with the default settings turning the seemingly random formatting into something reliable
[Corion]: GotToBTru: Yeah, I started a quick(ly implemented but slowly running) implementation of a program that would guess the "best" configuration (that is, least amount of changes) from my code, but then found that it stops parsing the source as soon as it ..
[GotToBTru]: sadly, it can't do anything about this
[Corion]: ... encounters sub foo($bar,$baz) {, which is something I like nowadays
[Corion]: GotToBTru: Yeah, that stuff is hard to do away automatically ;)

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (12)
As of 2017-02-27 14:30 GMT
Find Nodes?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?

    Results (387 votes). Check out past polls.