perl connection to sql server

Hello

I am trying to access the sql server 2005 from the solaris operating system. below is the code which i am using.....

while connecting to the server i am getting following error
DBI connect('driver={SQL Server};Server=192.111.17.91; database=FACSOLAPCore;uid
=cibna\x582406;pwd=Apr-2008;','',...) failed: [iODBC][Driver Manager]Specified d
river could not be loaded (SQL-IM003)
[iODBC][Driver Manager]ld.so.1: testdb.pl: fatal: {SQL Server}: open failed: No
such file or directory (SQL-00000)(DBD: db_login/SQLConnect err=-1) at ./testdb.
pl line 10
Database connection not made: [iODBC][Driver Manager]Specified driver could not
be loaded (SQL-IM003)
[iODBC][Driver Manager]ld.so.1: testdb.pl: fatal: {SQL Server}: open failed: No
such file or directory (SQL-00000)(DBD: db_login/SQLConnect err=-1)

Please advice
Any suggestions are welcome ......Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

#!/apps/perl5.8/bin/perl -wT
 
use DBI;
use DBD::Sybase;
 
 
#this is how you connect to MS SQL Server 2005:
 
my $DSN = 'driver={SQL Server};Server=192.111.17.91; database=FACSOLAPCore;uid=c
ibna\x582406;pwd=Apr-2008;';
my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "Database connection not made: $D
BI::errstr\n";
 
#this is how you query the db:
 
# query the database
my $sql = qq{ SELECT * FROM Inventory };
my $sth = $dbh->prepare( $sql );