[freetds] connecting to two databases with the same name but ondifferent servers

Chris Brookes cbrookes at gmail.com
Fri Jul 20 21:35:06 EDT 2007


On 20/07/07, Reid, Roger L. <roger.reid at dpw.com> wrote:

> It would help to know what doesn't work, what error, whatever.

BI connect('rmengDbBackup','dba',...) failed: Server message
number=911 severity=16 state=0 line=0 text=ASA Error -83: Specified
database not foundOpenClient message: LAYER = (0) ORIGIN = (0)
SEVERITY = (78) NUMBER = (46)
Server rmengDbBackup, database
Message String: Login incorrect.
 at /tmp/test.pl line 10
problem with db connection Server message number=911 severity=16
state=0 line=0 text=ASA Error -83: Specified database not
foundOpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78)
NUMBER = (46)
Server rmengDbBackup, database
Message String: Login incorrect.


> but I havn't used it in a while: check the CPAN page on DBI and you should be >OK.   Just remember that the config entry is the dataserver, not the database.

I tried to use database= but didn't have any luck.  I guess this
behaviour is only seen on Sybase ASA? Anyway I wrote a quick patch
that addressed the issue. If the patch isn't necessary I'd be
delighted to run the stock code, but from what I can tell it does
appear to be needed.

Thanks for your feedback.

Chris


More information about the FreeTDS mailing list