Mssql DBD::Sybase

kpaxian25 has asked for the wisdom of the Perl Monks concerning the following question:

I installed DBD::Sybase, freetds when i ran my script

use DBI;
BEGIN {
    $ENV{'SYBASE'} = '/usr/local/freetds';
    $ENV{'TDSVER'} = 7.0;
}
$dbh = DBI->connect("dbi:Sybase:server=10.0.0.1", "$db_username", "$db
+_password")
        or die "\nCouldn't connect: " . $DBI::errstr;
[download]

--------------------------------------------------- error message ct_send(CS_DESCRIBE_INPUT) returned 0 at /usr/local/lib/perl5/site_perl/5.8.0/i386-freebsd/DBD/Sybase.pm line 133, <DATA> line 283. Segmentation fault (core dumped)

any help will be much appreciated. Thanks

Comment on Mssql DBD::Sybase Download Code

Replies are listed 'Best First'.
Re: Mssql DBD::Sybase by dtr (Scribe) on Dec 01, 2005 at 22:39 UTC
Are you connecting to an actual Sybase server, or to MS-SQL? If connecting to Sybase, I don't think you can use any protocol version other than 4.0. And I think you need to use 8.0 to connect to recent MS-SQL Server boxes - particularly if you've got UTF8 data on the server end. So, can you try changing the TDSVER variable, and see if that fixes things?	[reply]
Re^2: Mssql DBD::Sybase by Anonymous Monk on Dec 02, 2005 at 16:35 UTC
I am connecting to MS sql server . changed to 8.0 same error message.	[reply]
Re: Mssql DBD::Sybase by mpeppler (Vicar) on Dec 02, 2005 at 18:11 UTC
That's not the whole script, is it? My guess is that your script uses placeholders, and placeholders aren't supported yet by FreeTDS. Re-write your script to interpolate the values in the $dbh->prepare() call and you should be good to go. Michael	[reply]