Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

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

by imp (Priest)
on Jan 25, 2007 at 14:16 UTC ( #596486=note: print w/ replies, xml ) Need Help??


in reply to Sql server + DBI package + freetds module = problem :)

Could you provide the DBI error string? Saying "it failed" doesn't provide enough information to diagnose your problem.


Comment on Re: Sql server + DBI package + freetds module = problem :)
Re^2: Sql server + DBI package + freetds module = problem :)
by alex452 (Novice) on Jan 25, 2007 at 15:15 UTC
    here is what i see from my test script above ----------------- DBI connect('server=212.247.84.54:1433;database=JACKPOT','sa',...) failed: OpenClient message: LAYER = (6) ORIGIN = (8) SEVERITY = (5) NUMBER = (3) Server 212.247.84.54:1433, database Message String: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found. at alextest11.pl line 4 Cannot connect to database: OpenClient message: LAYER = (6) ORIGIN = (8) SEVERITY = (5) NUMBER = (3) Server 212.247.84.54:1433, database Message String: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found. --------------

      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);

        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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://596486]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2014-11-26 19:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (172 votes), past polls