|
Mime-Version: |
1.0 |
Sender: |
|
Subject: |
|
From: |
|
Date: |
Thu, 9 Mar 2006 12:36:21 -0500 |
Content-Type: |
text/plain; charset="us-ascii"; format=flowed |
Reply-To: |
|
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
|
|
|