comment on

We have done *exactly* what you need at our office, using the DBD::JDBC driver with DBI.

DBD::JDBC will require you to have access to the Microsoft's JDBC drivers (which are freely available). You'll have to run a small java-executable that comes with DBD::JDBC on your Unix system which relays request from the Perl module to the jdbc driver.

The only problem we had was that the java-executable sometimes just decided to die. Because we only needed access for a batch job, we decided have our perl script start and stop the executable and the respective beginning and end of the job...

Nicest about this solution is you only use a plain perl module, and plain java and the MSSQL jdbc-jar, so you can easily do this on any platform without compiling a thing.

In reply to Re: Connecting to MS SQL server from Linux / Unix by Gilimanjaro
in thread Connecting to MS SQL server from Linux / Unix by allyc

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Pathologically Eclectic Rubbish Lister
	PerlMonks