[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