comment on

It's been a really long time since I used the Sybase DBD driver but I seem to remember that you need to create an entry in an interfaces file to map between a logical server name and the physical server name. Not sure what you mean by "TDS configuration."

If I remember how the interfaces file is configured correctly it looks something like:

[BILLING] 
host = 123.213.13.2
port = 1433
database = BILLING
user = USER
password = PASSWORD
[download]

Then you use the handle BILLING to connect with. Also if memory serves me correctly you have supply the path to the Sybase libraries

BEGIN{  $ENV{SYBASE}='/opt/sybase....handwaving here...';
}
use DBI;
my $dbh=DBI->connect('DBI:Sybase:server=BILLING') or die $DBI->errstr;
[download]

Hope this helps..

Peter L. Berghold -- Unix Professional
Peter -at- Berghold -dot- Net; Blog: http://blog.berghold.net Warning: No political correctness allowed.

In reply to Re: issue with DBI and MS SQL SERVER by blue_cowdawg
in thread issue with DBI and MS SQL SERVER by DanBev

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Do you know where your variables are?
	PerlMonks