Re^3: Sql server + DBI package + freetds module = problem :)

Specifying an ip address and port number is not the normal way to connect to a Sybase (or MSSQL) database ... check out the "Connecting to Sybase" section of DBD::Sybase - especially the "interface file" section.

-derby

Update: Following my own advice, you can bypass the interface files by specifying host and port in the DSN:

$dbh = DBI->connect(
  "dbi:Sybase:host=db1.domain.com;port=4100",
  $user, $passwd);
[download]

Comment on Re^3: Sql server + DBI package + freetds module = problem :) Download Code

Replies are listed 'Best First'.
Re^4: Sql server + DBI package + freetds module = problem :) by alex452 (Novice) on Jan 25, 2007 at 16:54 UTC
Hi again, Thanks for trying to help guys, Derby, unfortunately the port nr did nothing, i tried, the same result. The problem is, i am now sure of it is that freetds is not used by DBI module. trying to modify SYBASE env variable to point to freetds.conf leads to error messages about missing sybase files like config/objectid.dat	[reply]
Re^5: Sql server + DBI package + freetds module = problem :) by Anonymous Monk on Oct 12, 2011 at 02:56 UTC
Set SYBASE to point to freetds installed directory, and recompile DBD::Sybase (from perl Makefile.PL to make install). It may solve the objectid.dat problem	[reply]