Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

by patgas (Friar)
on Jan 23, 2002 at 20:43 UTC ( #140929=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 patgas

It took me weeks to figure out the actual code on how to connect to SQL Server without setting up a DSN on the machine. Hopefully I can spare someone the same pain.

This should give you the basics:

use DBI; use DBD::ODBC; my ( $data_source, $database, $user_id, $password ) = qw( server datab +ase user password ); my $conn_string = "driver={SQL Server};Server=$data_source;Database=$d +atabase;UID=$user_id;PWD=$password"; my $dbh = DBI->connect( "DBI:ODBC:$conn_string" ) or die $DBI::errstr; my $sql = "SELECT * FROM tbl_Foo (NOLOCK)"; my $sth = $dbh->prepare( $sql ); $sth->execute; while ( my $result = $sth->fetchrow_hashref ) { # Your fields can be accessed through the $result hashref, for exa +mple: print $result->{First_Name}; } $dbh->disconnect;

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
Discipulus earthquake in roma..
[Corion]: Discipulus: Whoa! I hope just a minor quake

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2017-01-18 09:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (161 votes). Check out past polls.