Thu, 9 Mar 2006 12:36:21 -0500
|
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
|
|
|