Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > MS SQL 2000

Reply
Thread Tools

MS SQL 2000

 
 
anonymous@coolgroups.com
Guest
Posts: n/a
 
      03-07-2004
Does anyone know how to connect to an MS SQL 2000 db from
Perl?

thanks.

 
Reply With Quote
 
 
 
 
Ben Morrow
Guest
Posts: n/a
 
      03-07-2004

http://www.velocityreviews.com/forums/(E-Mail Removed) wrote:
> Does anyone know how to connect to an MS SQL 2000 db from
> Perl?


I have had success (under linux) with DBI and DBD::Sybase. From Windows
I guess you can use DBD::ODBC.

Ben

--
don't get my sympathy hanging out the 15th floor. you've changed the locks 3
times, he still comes reeling though the door, and soon he'll get to you, teach
you how to get to purest hell. you do it to yourself and that's what really
hurts is you do it to yourself just you, you and noone else ** (E-Mail Removed)
 
Reply With Quote
 
 
 
 
Jim
Guest
Posts: n/a
 
      03-07-2004
my $dbhandle = DBI->connect(
"DBI:ADORIVER={SQL Server};SERVER=$servername;DATABASE=$dbname",
$uid, $pwd,{ RaiseError => [1],
PrintError => [1],
AutoCommit => [1])
) || die "Db connection not made: $DBI::errstr";


(E-Mail Removed) wrote:
> Does anyone know how to connect to an MS SQL 2000 db from
> Perl?
>
> thanks.
>

 
Reply With Quote
 
Jim
Guest
Posts: n/a
 
      03-07-2004
Oh yeah,

use DBI;
use DBI qw(:sql_types);


> my $dbhandle = DBI->connect(
> "DBI:ADORIVER={SQL Server};SERVER=$servername;DATABASE=$dbname",
> $uid, $pwd,{ RaiseError => [1],
> PrintError => [1],
> AutoCommit => [1])
> ) || die "Db connection not made: $DBI::errstr";
>
>
> (E-Mail Removed) wrote:
>
>> Does anyone know how to connect to an MS SQL 2000 db from Perl?
>>
>> thanks.
>>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie chart: ASP.net 2.0, SQL Server 2000, Excel 2000 C Did ASP .Net 3 06-20-2006 08:35 AM
Uploading Data From MS Acess 2000 ti SQL server 2000 =?Utf-8?B?Z2F1cmF2?= ASP .Net 2 01-09-2006 02:42 PM
Microsoft Exchange 2000 Server OR Microsoft SQL Server 2000 Sam MCSE 11 06-03-2005 08:29 PM
2000 MCSE can I take SQL 2000? Harrison Midkiff Microsoft Certification 1 02-25-2005 08:26 PM
Access 2000 or SQL Server 2000 Denis ASP General 1 01-25-2004 03:38 PM



Advertisments