Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Connecting from *nix/Apache/mod_perl to SQL Server

by jehuni (Pilgrim)
on Dec 11, 2001 at 19:01 UTC ( #130938=perlquestion: print w/replies, xml ) Need Help??
jehuni has asked for the wisdom of the Perl Monks concerning the following question:

Looks like we're finally getting the opportunity to dump Win2K/IIS/ASP and move to *nix/Apache/mod_perl. (Woo hoo!!!) Problem is, for now at least, we have to keep the databases in SQL Server 2000.

So, the question is: What kind of experiences/recommendations does anyone have with this kind of cross-platform setup?

None of us here have experience in this exact arena, so we're still actively looking for a solid approach. However, here are some of the possibilities we're considering, based mostly on perusing the web for ideas:

So ... tell us what you think ...

-jehuni

  • Comment on Connecting from *nix/Apache/mod_perl to SQL Server

Replies are listed 'Best First'.
Re: Connecting from *nix/Apache/mod_perl to SQL Server
by andreychek (Parson) on Dec 11, 2001 at 20:30 UTC
    Thats certainly an interesting predicement you're in ;-)

    As far as ODBC goes -- in order to do ODBC from your *nix box over to Windows, I believe you will still need a "bridge" to get your there. There are tools that can help you with this, ranging from open source to commercial. You would use unixODBC or iodbc along with it. Check out: (I just searched for "odbc bridge" at freshmeat)

  • dbtcp (Open Source)
  • ODBC-ODBC Bridge (Commercial)

    Now, for FreeTDS. I haven't looked at that in some time.. but I heard a rumour some months ago that SQL Server 7.0 was the last version that it would work with, as MS is moving it away from functioning like Sybase. I'm sure digging through the FreeTDS website would clear that up, but it's something to consider. Even if it still works now.. as soon as MS changes it enough, it may never work again.

    Doing HTTP and XML is always fun, and you could always consider using Apache 2.0, which is supposed to work well on Windows. It's of course in beta now, but I've been hearing good reports about it.

    There are also two other interesting options you can look into. There is the ODBC Socket Server, which is a service which you run on your NT box. It's job is to expose ODBC resources via TCP/IP, making it very easy to access from non-windows platforms. I've never used it, but they claim that it's pretty fast.

    And lastly, you could always consider a middleware/application server product. That might be a bit much for what you're looking to do, but you never know. Anything from IBM's Websphere to the open source JBoss, there's a lot available.

    Good luck!
    -Eric
Re: Connecting from *nix/Apache/mod_perl to SQL Server
by mpeppler (Vicar) on Dec 12, 2001 at 00:11 UTC
    I'd suggest you use DBI/DBD::Sybase + FreeTDS.

    I believe that the latest FreeTDS snapshots include significant improvements, and that placeholders are now supported (or will be when 0.53 is released.)

    Michael

      Does this combination of DBI/DBD::Sybase + FreeTDS work with SQL Server 2000? One of the messages above suggests that this may not be the case.

      -jehuni

        Yes, as far as I know it does work with SQL Server 2000.

        You should check on the FreeTDS mailing list for details (see www.freetds.org for details.)

        Michael

Re: Connecting from *nix/Apache/mod_perl to SQL Server
by strat (Canon) on Dec 11, 2001 at 22:07 UTC
    I haven't tried it yet, but DBI::Proxy might also help you

    Best regards,
    perl -e "print a|r,p|d=>b|p=>chr 3**2 .7=>t and t"

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://130938]
Approved by root
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2018-01-17 10:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How did you see in the new year?










    Results (198 votes). Check out past polls.

    Notices?