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

Answer: How do I connect to Microsoft SQL server 6.5?

( #37543=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > How do I connect to Microsoft SQL server 6.5? contributed by wardk

I would second using

  • DBI
  • DBD::ODBC

Be sure to install MDAC 2.1 (or higher)

Also, ignore any advice to use DSN's on the machine, you should really build a complete connect string in your code. that way you stay portable. Nothing like moving it to a newer bigger machine (inevitable with NT) and then having to hand-build a DSN.

You should get suprisingly good results from a combination of Perl and ODBC. It sure beats using that other product from our pals in Redmond.

Comment on Answer: How do I connect to Microsoft SQL server 6.5?
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (2)
As of 2014-10-25 08:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (142 votes), past polls