LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

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

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

Print Reply
Douglas Palmer <[log in to unmask]>
Thu, 9 Mar 2006 12:36:21 -0500
text/plain (40 lines)
In trying to setup a UODBC datasource, I am seeing this error when 
using the CHANGELOG functions:

 >>> Error X'0100002B' opening DBMS connection <<<
  -> Severity: Error
  -> Facility: DBMS interface
  -> Abstract: No such column

How can I tell exactly what SQL/insert it tried to run?

Here are my setting in go.user (password changed):

UODBC_DSN="listserv"
UODBC_UID="listserv"
UODBC_AUTH="XXXXXXX"
export UODBC_DSN UODBC_UID UODBC_AUTH
CHANGELOG_DBMS="ALL"
export CHANGELOG_DBMS
CHANGELOG_DBMS_TABLE="changelog timestamp listname recordtype parameters"
export CHANGELOG_DBMS_TABLE

and the structure of the table is:

table changelog (
     timestamp DATETIME YEAR TO FRACTION,
     listname VARCHAR(40),
     recordtype VARCHAR(40),
     parameters VARCHAR(255)
)

The isql from unixODBC has no problem accessing this table.

-- DCP


-- 
Douglas Palmer                  Chief Deputy for Automated Svcs
225 Cadman Plaza East           Voice: 718-613-2291 Fax: 718-613-2256
Brooklyn, New York 11201                USDC-EDNY 

ATOM RSS1 RSS2