On 11/24/06, Matthew Persico <[EMAIL PROTECTED]> wrote:
On 11/23/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Hi Matthew,
>
> The real problem is that there is no way to detect that we're trying to
> connect to a rep server, so DBD::Sybase still tries to use teh ct_option()
> calls, and to get the version of the server (via select @@version).
>
> Obviously these errors aren't "real" errors - so I guess there are two
> possible solutions.
>
> 1 - on your end, check for error 2056 and if so ignore the content of
> errstr:
>
> $dbh = DBI->connect(....);
> if($dbh->err && $dbh->err != 2056) {
> print $dbh->errstr;
> }
>
> It's obviously not a clean solution, but it should work.
I will test this for my immediate problem and report back.
Reporting back - works just fine.
>
> 2 - we add a new connection attribute that tells DBD::Sybase to not call
> ct_option, and to not try to get the version. Maybe something like
>
> $dbh =
> DBI->connect('dbi:Sybase:server=MSTR_REP;serverType=OS;...',
> 'sa', '...', ...);
>
> where OS means OpenServer. This could then be useful when connecting to
> other types of openserver apps, not just RepServer.
That makes plenty of sense to me. I suggest the default be set to ASE
if not specified and the allowed values will be
ASE - Adaptive Server Enterprise
ANY - Anywhere
IQ - IQ
OS - Open Server
RS - Replication server
because I am going to implement these in my DBI->connect wrapper.
<snip>
--
Matthew O. Persico
