freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Michael Peppler <mpeppler AT peppler.org>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] DBD:Sybase connect failure
- Date: Mon, 02 Jun 2008 21:07:03 +0200
Goldstein, Ian wrote:
my $db="testdb";
my $user="xyz\\abcdg";
my $pass="Apr-2008";
my $dbh =
DBI->connect("DBI:Sybase:server=sqlserver;database=$db,$user,$pass" ) ||
die "Database connection not made: $DBI::errstr\n";
When I run the script, I get the following error:
DBI
connect('server=sqlserver;database=FACSOLAPCore,cibna\x582406,Apr-2008',
'',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY =
(78) NUMBER = (34)
Server sqlserver, database Message String: Adaptive Server connection failed
The DBI->connect() call syntax is wrong.
You need:
$dbh = DBI->connect('dbi:Sybase:server=sqlserver', $user, $pass);
Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler AT peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
-
[freetds] DBD:Sybase connect failure,
Goldstein, Ian, 06/02/2008
-
Re: [freetds] DBD:Sybase connect failure,
Michael Peppler, 06/02/2008
- Re: [freetds] DBD:Sybase connect failure, Goldstein, Ian, 06/02/2008
-
Re: [freetds] DBD:Sybase connect failure,
Michael Peppler, 06/02/2008
Archive powered by MHonArc 2.6.24.