Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris Brookes" <cbrookes AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] connecting to two databases with the same name but ondifferent servers
  • Date: Fri, 20 Jul 2007 20:35:06 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page