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

On 11/24/06, Matthew Persico <matthew.persico@xxxxxxxxx> wrote:
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.

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
.

Relevant Pages

  • Re: Using SQl to store aspx pages and memory problems
    ... > the text from SQL server and writing it to disk - it all worked very well. ... > the compiling time would still be there and so would the memory issues. ... > For example - I have saved the copy of each invoice I send out to clients as ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: missing computers in browser while browsing domain
    ... Let your server do all the serving, including DHCP, DNS and WINS. ... "Matthew Mucklo" schreef in bericht ... > Yes, on the server at least, Enable NetBIOS over TCP/IP is checked. ... >>>> Both machines are in the list of computers under Active Directory ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: User logins
    ... What kind of server and server OS is the site hosed on?? ... "Matthew" wrote in message ... protect my entire site. ... also every other web page should also be protected but not have to login on every page. ...
    (microsoft.public.frontpage.client)
  • Ow! Dont put your Thumb there!
    ... "Server error: The server extensions were unable to ... Well, if I could find the file to check the permissions, ... Matthew ... Do all of you image work outside ...
    (microsoft.public.frontpage.programming)
  • There WAS another device!!!! Thanks everyone!!!
    ... Matthew ... > server on this network with IP Address, 192.168.168.1, belonging to the ... > The DHCP/BINL service on this computer is shutting down. ... > event log messages for reasons ...
    (microsoft.public.backoffice.smallbiz2000)