Rocket U2 | UniVerse & UniData

 View Only

 Unidata ODBC - Are there any resources for debugging failing ODBC connections with Unidata?

Kevin King's profile image
Kevin King posted 01-07-2025 13:10

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.

Thomas VanKirk's profile image
Thomas VanKirk posted 01-07-2025 13:17

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

John Jenkins's profile image
John Jenkins posted 01-07-2025 18:04

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

Kevin King's profile image
Kevin King posted 01-08-2025 13:28

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.

Kevin King's profile image
Kevin King posted 01-09-2025 08:27

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.

John Jenkins's profile image
John Jenkins posted 01-09-2025 16:05

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\newhome
UDTACCT=C:\U2\ud73\demo
TRACE_LEVEL=3

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

Regards

JJ