From the docs:
serverType
Tell DBD::Sybase what the server type is. Defaults to ASE. Setting
it to something else will prevent certain actions (such as setting
options, fetching the ASE version via @@version, etc.) and avoid
spurious errors.
Where can we find a list of the other types aside from "ASE"?
--
Matthew O. Persico
On Tue, Oct 02, 2007 at 03:07:39PM -0400, Matthew Persico wrote:
> >From the docs:
>
> serverType
>
> Tell DBD::Sybase what the server type is. Defaults to ASE. Setting
> it to something else will prevent certain actions (such as setting
> options, fetching the ASE version via @@version, etc.) and avoid
> spurious errors.
>
> Where can we find a list of the other types aside from "ASE"?
At first glance it looks like that's all it does:
http://search.cpan.org/grep?release=DBD-Sybase-1.08&string=s erverType&F=1&n=1
Tim.
On 10/2/07, Tim Bunce
> On Tue, Oct 02, 2007 at 03:07:39PM -0400, Matthew Persico wrote:
> > >From the docs:
> >
> > serverType
> >
> > Tell DBD::Sybase what the server type is. Defaults to ASE. Setting
> > it to something else will prevent certain actions (such as setting
> > options, fetching the ASE version via @@version, etc.) and avoid
> > spurious errors.
> >
> > Where can we find a list of the other types aside from "ASE"?
>
> At first glance it looks like that's all it does:
>
> http://search.cpan.org/grep?release=DBD-Sybase-1.08&string=s erverType&F=1&n=1
>
Hmm. Forgot about the grep facilites of search.cpan.org. Have to dig
the url oput for that.
Anyway, it appears as if he is taking the info drom Sybase itself. I
should be able to map the underlying CTLib call he's making to the
Sybase docs and figure the list myself at this point.
Sorry to bother...
> Tim.
>
--
Matthew O. Persico
--=_alternative 0020F5A7C1257369_=
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"
In 1.08 the only check is for ASE - so if you pass in anything else then
fetching @@version and a few other things will not be done.
In the next release you can also pass in RA - for ReplicationAgent. This
will also turn off all ct_options() calls. I needed this to be able to
talk to the Sybase Rep Agent for Oracle. This is a java app that reads the
oracle redo logs and sends the data to Sybase replication server. The app
can't handle ct_options() calls, and actually kills the connection if you
use them (not good :-)
Michael
Extranet
matthew.persico@gmail.com - 02.10.2007 21:07
To: dbi-users
cc:
Subject: DBD::Sybase, serverType
From the docs:
serverType
Tell DBD::Sybase what the server type is. Defaults to ASE. Setting
it to something else will prevent certain actions (such as setting
options, fetching the ASE version via @@version, etc.) and avoid
spurious errors.
Where can we find a list of the other types aside from "ASE"?
--
Matthew O. Persico
This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
--=_alternative 0020F5A7C1257369_=--
Sorry, forgot to include the list...
---------- Forwarded message ----------
From: Matthew Persico
Date: Oct 3, 2007 12:16 PM
Subject: Re: DBD::Sybase, serverType
To: "michael.peppler@bnpparibas.com"
On 10/3/07, michael.peppler@bnpparibas.com
>
> In 1.08 the only check is for ASE - so if you pass in anything else then
> fetching @@version and a few other things will not be done.
Can we standardize on
ASE - Adaptive Server Enterprise
ANY - Anywhere
IQ - IQ
OS - Open Server
RS - Replication server
RA - Replication agent
Is there a difference between the last two? Do we need OS as a distinct option?
>
> In the next release you can also pass in RA - for ReplicationAgent. This
> will also turn off all ct_options() calls. I needed this to be able to talk
> to the Sybase Rep Agent for Oracle. This is a java app that reads the oracle
> redo logs and sends the data to Sybase replication server. The app can't
> handle ct_options() calls, and actually kills the connection if you use them
> (not good :-)
>
> Michael
>
>
>
>
>
> Extranet
> matthew.persico@gmail.com - 02.10.2007 21:07
>
>
> To: dbi-users
>
> cc:
>
> Subject: DBD::Sybase, serverType
>
>
> From the docs:
>
> serverType
>
> Tell DBD::Sybase what the server type is. Defaults to ASE. Setting
> it to something else will prevent certain actions (such as setting
> options, fetching the ASE version via @@version, etc.) and avoid
> spurious errors.
>
> Where can we find a list of the other types aside from "ASE"?
>
> --
> Matthew O. Persico
>
> This message and any attachments (the "message") is
> intended solely for the addressees and is confidential.
> If you receive this message in error, please delete it and
> immediately notify the sender. Any use not in accord with
> its purpose, any dissemination or disclosure, either whole
> or partial, is prohibited except formal approval. The internet
> can not guarantee the integrity of this message.
> BNP PARIBAS (and its subsidiaries) shall (will) not
> therefore be liable for the message if modified.
>
> ---------------------------------------------
>
> Ce message et toutes les pieces jointes (ci-apres le
> "message") sont etablis a l'intention exclusive de ses
> destinataires et sont confidentiels. Si vous recevez ce
> message par erreur, merci de le detruire et d'en avertir
> immediatement l'expediteur. Toute utilisation de ce
> message non conforme a sa destination, toute diffusion
> ou toute publication, totale ou partielle, est interdite, sauf
> autorisation expresse. L'internet ne permettant pas
> d'assurer l'integrite de ce message, BNP PARIBAS (et ses
> filiales) decline(nt) toute responsabilite au titre de ce
> message, dans l'hypothese ou il aurait ete modifie.
>
>
>
>
>
>
>
--
Matthew O. Persico