look for the module
DBI
this is the module which handles databases in
perl
you want to do something like
this:
use DBI;
my $dbh = DBI->connect("dbi:ODBC:driver={SQL
Server};Server=databaseservername_or_ip;database=databasename;uid=databaseusername;pwd=databasepassword;",undef,undef,{
RaiseError => 0, AutoCommit => 0 })
or die "failed: $DBI::errstr";
or die "failed: $DBI::errstr";
this will make a connection to the database.... then
you will have to make queries.... but search for the DBI module and there
is bunch of help on the internet...
Regards
Henrik
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af ukhas jean
Sendt: 14. juni 2006 15:52
Til: [email protected]
Emne: Sql Server 2000 and Perl connectivity. Is it possible??
Hello All,
I wanted to connect to a MSSQL Server 2000 Database and was wondering if
any of you guys can help me with this. I am having Perl 5.6 and am working on
Win XP.
Also, I do have some machines in my workplace that are runnin on
Linux.
Any leads/ advises/ suggestions/ solutions would be very much
appreciated.
I am really stuck and am unable to find any proper solution even after
doing a search with google.
If any of u gurus can help me with even the name of the module that I can
use for this ... i would really appreciate it.
Hoping you will kindly oblige.
Thanks and Regards,
Ukhas Jean
__________________________________________________
Do You Yahoo!?
Tired
of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
