Skip to main content

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them.

For example:

DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:
33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlying
database do not provide the requested feature.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=upsodbc

This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them.

For example:

DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:
33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlying
database do not provide the requested feature.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=upsodbc

This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

Hello. We use Easysoft's ODBC driver to connect from UniData to SQL.

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them.

For example:

DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:
33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlying
database do not provide the requested feature.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=upsodbc

This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

Kevin,

Take a look at the TRACE_LEVEL setting in the ud_database file. This is covered in the U2 Client documentation rather than in the database documentation itself. I;d also recommend testing ODBC basics using the 'demo; account first.

Regards

JJ

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them.

For example:

DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:
33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlying
database do not provide the requested feature.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=upsodbc

This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

John, which client document specifically spells out the TRACE_LEVEL options?  I'm looking at the document for 5.1 clients and not seeing anything in there.

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them.

For example:

DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:
33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlying
database do not provide the requested feature.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=upsodbc

This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

Additionally, the only document I can find talks about using Windows servers for Unidata.  I'm trying to set up a ODBC connection to a Linux machine and not finding any information about configuration or debugging.  Any direction you could point me in would be most appreciated.

I have a customer who is attempting to setup a Fedex machine, connecting it to Unidata to transfer data.  The same ODBC driver works perfectly on another system.  On this system, we get odd errors and I have zero clue how to research them.

For example:

DataSource.Error: ODBC: ERROR [SICOO] [Rocket U2][U2ODBC][1801668]Error ID:
33 Severity: ERROR Facility: DBCAPERR - The UV/ODBC server or the underlying
database do not provide the requested feature.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=upsodbc

This happened when attempting to retrieve data through the 32-bit ODBC connector using a 32-bit Excel.  It was able to authenticate and return a list of table names, but when attempting to view the fields inside of the tables, this was the error.

Kevin,

It should be in the documentaiton somewhere, though you can also find references in the Rocket KnowleddgeBase - here's a clip from there showing the setting:

file: ud_database

DATABASE=newdemo
UDTHOME=C:U2 ewhome
UDTACCT=C:U2ud73demo
TRACE_LEVEL=3

There are additional Knowledge entries on tracing ODBC using various methods - hoping it helps.

Regards

JJ

Terms & ConditionsAccessibility statement