I'm not sure why you have

     timestamp DATETIME YEAR TO FRACTION

because I can't even find that in the MySQL documentation -- can you 
give me a pointer?

I didn't have any trouble with simply "timestamp 
DATETIME".  Otherwise my changelog table is identical to yours and 
LISTSERV is not having any trouble with it.

Nathan

At 12:36 PM 3/9/2006 -0500, Douglas Palmer wrote:
>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