[freetds] DBD::Sybase not connecting - acts like it is not using FreeTDS [SOLVED]

[Darrell Cormier]

I have searched the archives and did not find an answer to my issue.

<SNIP>

However, when I attempt a connection to the same server used for the tsql
test mentioned above, I get the following message when the statement
DBD::Sybase::st execute failed: Server message number=7202 severity=11
state=2 line=1 server=DLUS2-SQL text=Could not find server 'dlus2' in
sys.servers. Verify that the correct server name was specified. If necessary,
execute the stored procedure sp_addlinkedserver to add the server to
sys.servers. at <path to perl script>/devices.pl line 19.
Can't Execute the shipping data SQL statement: Server message
number=7202 severity=11 state=2 line=1 server=DLUS2-SQL text=Could not
find server 'dlus2' in sys.servers. Verify that the correct server name was
specified. If necessary, execute the stored procedure sp_addlinkedserver to
add the server to sys.servers. at <path to perl
script>/devices.pl line 19.
<SNIP>
Thanks,
D

I have solved this issue. The problem was in the way that the table
is referenced in the query using older versions DBD::SYBASE.

In the older version (i.e. roughly 2005 time frame) the "FROM"
statement in the query would require the table listed as:

<host>.<database>.<db owner>.<table>

evidently that has changed. I dropped the above to just <table> and
it functioned as expected.



Thanks, and sorry for the three identical original posts.



--DC