Re: Fwd: Can't connect to Sybase Rep server

On 11/23/06, michael.peppler@xxxxxxxxxxxxxx
<michael.peppler@xxxxxxxxxxxxxx> 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.


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>
.

Relevant Pages

  • Re: Performance in multi user environment.
    ... it hits mine hard with just one user. ... just a comment that it's a real problem. ... I still would do a test on the server just to make sure ... Recent versions of Excel will also import some XML schemas. ...
    (perl.beginners)
  • Re: numerous run-time events
    ... but for some reason there are plenty of ... server has encountered numerous run-time events." ... the time the log is getting several zone transfer events? ... To tell you if there is a real problem I would have to know what events are ...
    (microsoft.public.windows.server.dns)
  • Re: AD, exchange, outlook 2003 and terminal services on the same server
    ... Outlook/Exchange seems the real problem, ... File server. ... what's in the folders. ...
    (microsoft.public.exchange.admin)
  • VFP ODBC Problem - Unable to create temporary work files
    ... I have a real problem with our website and I have run out of ideas on how to ... Our ISP has assured as that nothing major has changed with the web server ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.fox.programmer.exchange)
  • VFP ODBC Problem - Unable to create temporary work files
    ... I have a real problem with our website and I have run out of ideas on how to ... Our ISP has assured as that nothing major has changed with the web server ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.data.odbc)