SQL Server Connectivity

From: "jeevs" <jeevan.ingale@xxxxxxxxx>
Date: 30 Jan 2007 05:53:48 -0800

Hi everyone...

Want to connect to SQL Server from perl on Unix.

I am using

freetds 0.64
perl 5.008
DBI 1.53
Sybase 1.07

My freetds.conf has the following settings

[file1]
host = x.x.x.x
port = 1433
tds version = 7.0

But when i try to connect to the sql server

$dbh = DBI->connect("DBI:Sybase:server=$server",$user,$pass) or die
"cant connect ==> $DBI::errstr";

I get

[jeevan@localhost jeevan]$ perl test.pl
DBI connect('server=MyServer70','EmployeeProjectNamesForHelpdesk',...)
failed: (no error string) at test.pl line 7
cant connect ==> at test.pl line 7.

Any Directions will be appreciated.....

.

Prev by Date: Re: confusion with splitting columns using [-n, -n] (e.g; my ( $country, $bytes ) = ( split )[ -2, -1 ])
Next by Date: Re: execution of script in one shell
Previous by thread: Re: confusion with splitting columns using [-n, -n] (e.g; my ( $country, $bytes ) = ( split )[ -2, -1 ])
Next by thread: How do I output an array twice via pipe instead of only once?
Index(es):
- Date
- Thread

Relevant Pages

Re: How to access MS Access from Perl?
... if you were to later migrate to MS SQL Server or Oracle ... minimize your load on the database server's compiled procedure cache. ... On the other hand, if startup time for your perl script is an issue, and ... slightly preferable to the bulkier DBI + DBD::ODBC. ...
(comp.lang.perl)
Re: Perl 6 DBI API ideas
... Though I didn't raise my hand when you asked for people to contribute to a DBI module for Perl 6, I've had some ideas that I thought about sharing. ... I would also love to see some standardization on the driver names ("mysql" when it's normally written ... DBI is supposed to be query language agnostic, even if SQL is the most commonly used group of languages, and if a user can declare this explicitly, it saves the driver from having to guess what they were given, which might be ambiguous. ...
(perl.dbi.users)
Problem of DBI build
... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
(perl.dbi.users)
Problem of DBI build
... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
(perl.dbi.users)
Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
... T> expected a mature library like DBI to behave like this. ... I learned plenty about the perl side of things from her posts. ... closely represent the SQL idea of a null. ... trivially easy to perform bulk loads using the DB's particular ...
(comp.lang.perl.misc)