Skip Navigational Links
LISTSERV email list manager
LISTSERV - COMMUNITY.EMAILOGY.COM
LISTSERV Menu
Log In
Log In
LISTSERV 17.5 Help - LSTSRV-L Archives
LISTSERV Archives
LISTSERV Archives
Search Archives
Search Archives
Register
Register
Log In
Log In

LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Menu
LISTSERV Archives LISTSERV Archives
LSTSRV-L Home LSTSRV-L Home

Log In Log In
Register Register

Subscribe or Unsubscribe Subscribe or Unsubscribe

Search Archives Search Archives
Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: DBMS list using MS Access
From:
Nathan Brindle <[log in to unmask]>
Reply To:
LISTSERV give-and-take forum <[log in to unmask]>
Date:
Mon, 26 Jun 2000 15:03:35 EDT
Content-Type:
text/plain
Parts/Attachments:
text/plain (25 lines)
When starting LISTSERV with an Access database as the DBMS source, you
are most likely seeing errors like

> DBMS: ACCESS (3.5 Jet)as no ESCAPE clause, errors will occur!
> Multi-row operations are unavailable
> Cursor behaviour limits ability to commit before logical close
> [SEVERE] '=' operator is case-insensitive, results may be incorrect!
> [FATAL] LIKE operator has no ESCAPE clause, errors will occur!
> [SEVERE] FOR UPDATE clause not supported, no locking will occur

This error:

> [FATAL] LIKE operator has no ESCAPE clause, errors will occur!

in particular militates against using an Access DBMS table as a DBMS
list source.  In fact the documentation says that this error "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 statements that
you provide in the mail-merge job."

Bottom line is that we don't support Access as a DBMS for DBMS lists.

Nathan

ATOM RSS1 RSS2

COMMUNITY.EMAILOGY.COM CataList Email List Search Powered by LISTSERV