Sybase ODBC - Does anyone know what this means

Author

Does anyone know what this means

Germano

2005-06-03, 8:23 pm

Hi,

We bought this LISTSERV product from LSOFT because we were told that it
could use ODBC to connect to any database, but after making several attemps
to use it and several emails back and forth with Tech Support, we were given
the following. Does anyone know what if this "escape clause" that they are
talking about is true?

Thanks

This error indicates that the DBMS does not support any kind of "escape
clause" for the LIKE operator. In practice, it means that whenever LISTSERV
attempts a search containing a percent sign or underscore, the results will
be incorrect (you may also get an ODBC error). This makes the DBMS unusable
as a data store for LISTSERV lists. However, if you only plan to use the
DBMS for mail-merge jobs, this restriction may be immaterial as LISTSERV
will only be executing the SQL SELECT statements (by definition read-only)
that you provide in the mail-merge job.

In short, Sybase cannot be used for a DBMS-based LISTSERV List because
LISTSERV cannot reliably write to the DBMS. Sybase could be used as source
data for mailings by using a DBMS SELECT statement (Admin page of the WWW
interface or Maestro) but all updating and data entry must take place
directly in the database outside of LISTSERV.

Millard F. Brown III

2005-06-06, 11:23 am

I believe this is a technique for specifying the character(s) to use as the
escape character (i.e. {escape "\"}) which allows you to 'escape' special
characters in the LIKE match string, including them in the search as that
literal character. So, "...LIKE '\_%' {escape ''}" says to match everything
that begins with an underbar.

Regards,
Millard[TeamSybase]

On 3 Jun 2005 12:04:02 -0700,
in sybase.public.connectivity.odbc
Germano <Germano_Silva@Brown.edu> wrote:
>Hi,
>
>We bought this LISTSERV product from LSOFT because we were told that it
>could use ODBC to connect to any database, but after making several attemps
>to use it and several emails back and forth with Tech Support, we were given
>the following. Does anyone know what if this "escape clause" that they are
>talking about is true?
>
>Thanks
>
>This error indicates that the DBMS does not support any kind of "escape
>clause" for the LIKE operator. In practice, it means that whenever LISTSERV
>attempts a search containing a percent sign or underscore, the results will
>be incorrect (you may also get an ODBC error). This makes the DBMS unusable
>as a data store for LISTSERV lists. However, if you only plan to use the
>DBMS for mail-merge jobs, this restriction may be immaterial as LISTSERV
>will only be executing the SQL SELECT statements (by definition read-only)
>that you provide in the mail-merge job.
>
>In short, Sybase cannot be used for a DBMS-based LISTSERV List because
>LISTSERV cannot reliably write to the DBMS. Sybase could be used as source
>data for mailings by using a DBMS SELECT statement (Admin page of the WWW
>interface or Maestro) but all updating and data entry must take place
>directly in the database outside of LISTSERV.
>
>

Regards,
Millard[TeamSybase]

Paul

2005-06-06, 11:23 am

Hi,

Do you have an samples of this? I am not sure which escape clause they
refer to - ODBC or ASE?

pv

"Germano" <Germano_Silva@Brown.edu> wrote in message
news:42a0a9a2$1@foru
ms-1-dub...
> Hi,
>
> We bought this LISTSERV product from LSOFT because we were told that it
> could use ODBC to connect to any database, but after making several
attemps
> to use it and several emails back and forth with Tech Support, we were
given

> the following. Does anyone know what if this "escape clause" that they are
> talking about is true?
>
> Thanks
>
> This error indicates that the DBMS does not support any kind of "escape
> clause" for the LIKE operator. In practice, it means that whenever
LISTSERV
> attempts a search containing a percent sign or underscore, the results
will
> be incorrect (you may also get an ODBC error). This makes the DBMS
unusable
> as a data store for LISTSERV lists. However, if you only plan to use the
> DBMS for mail-merge jobs, this restriction may be immaterial as LISTSERV
> will only be executing the SQL SELECT statements (by definition read-only)
> that you provide in the mail-merge job.
>
> In short, Sybase cannot be used for a DBMS-based LISTSERV List because
> LISTSERV cannot reliably write to the DBMS. Sybase could be used as
source
> data for mailings by using a DBMS SELECT statement (Admin page of the WWW
> interface or Maestro) but all updating and data entry must take place
> directly in the database outside of LISTSERV.
>
>

Germano

2005-06-06, 8:23 pm

I don't have anything, just the email they sent me saying that their
software wiol not support Sybase as the back-end because of this issues with
the ODBC driver. This was after the sales guy told us that it would and
after we purchased the product. The only good news is that we will be able
to return it.

"Paul" <Paul@sybase.com> wrote in message news:42a4701b@forums
-1-dub...
> Hi,
>
> Do you have an samples of this? I am not sure which escape clause they
> refer to - ODBC or ASE?
>
> pv
>
> "Germano" <Germano_Silva@Brown.edu> wrote in message
> news:42a0a9a2$1@foru
ms-1-dub...
> attemps
> given
> LISTSERV
> will
> unusable
> source
>
>

Paul

2005-06-07, 11:23 am

Do they bundle the odbc driver in their product? I am asking because we now
have 2 different versions of ODBC For ASE:

Sybase ASE ODFBC Driver is the OEM version - this has been the "traditional"
driver. Currently it is file version 5.00.0056, in the 12.5.1 SDK ESD08

Also, ASE ODBC Driver by Sybase ("Adaptive Server Enterprise") is also in
teh same ESD.
Just curious if this vendor has tried that particular driver. It is
currenly file version 12.5.1.465, located under %SYBASE%\DataAccess\
odbc

-pv

"Germano" <Germano_Silva@Brown.edu> wrote in message
news:42a4a928$1@foru
ms-1-dub...
> I don't have anything, just the email they sent me saying that their
> software wiol not support Sybase as the back-end because of this issues
with
> the ODBC driver. This was after the sales guy told us that it would and
> after we purchased the product. The only good news is that we will be able
> to return it.
>
> "Paul" <Paul@sybase.com> wrote in message news:42a4701b@forums
-1-dub...
the[color=darkred]
LISTSERV[color=darkr
ed]
WWW[color=darkred]
>
>

Germano

2005-06-10, 7:23 am

No, I'm using the one that gets installed with the Open Client. I also
downloaded an eval copy of the ODBC from DataDirect and had the same issue.

I'm sending the software back and getting my money back.

Thanks

"Paul" <Paul@sybase.com> wrote in message news:42a5cd1a@forums
-2-dub...
> Do they bundle the odbc driver in their product? I am asking because we
> now
> have 2 different versions of ODBC For ASE:
>
> Sybase ASE ODFBC Driver is the OEM version - this has been the
> "traditional"
> driver. Currently it is file version 5.00.0056, in the 12.5.1 SDK ESD08
>
> Also, ASE ODBC Driver by Sybase ("Adaptive Server Enterprise") is also in
> teh same ESD.
> Just curious if this vendor has tried that particular driver. It is
> currenly file version 12.5.1.465, located under %SYBASE%\DataAccess\
odbc
>
> -pv
>
> "Germano" <Germano_Silva@Brown.edu> wrote in message
> news:42a4a928$1@foru
ms-1-dub...
> with
> the
> LISTSERV
> WWW
>
>

Sponsored Links