Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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

by wardk (Deacon)
on Oct 19, 2000 at 22:37 UTC ( #37543=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > How do I connect to Microsoft SQL server 6.5? - Answer 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?
[Lady_Aleena]: atcroft, that is the goal.
[Lady_Aleena]: atcroft, this is the last of the printing modules I am going to make stop printing, I think.
[Lady_Aleena]: It will leave me with 8 out of 138 modules that print something.

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2017-05-29 02:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?