View Data in ODBC Stage for Teradata

rpaulin · Post by **rpaulin** » Wed Oct 10, 2007 8:46 am

Hi,

We've just recently upgraded our 7.0.1 instance to 7.5.2.1 on HPUX. We are now having problems viewing data or querying data through the ODBC stage when accessing Teradata.

The Teradata ODBC drivers and libs have not been touched during the upgrade, and we are using the recommended version for our Teradata instance (3.05.06 for V6R2).

I think the dsenv, .odbc.ini, and uvodbc.config files are all configured properly, as we can get a list of tables and views from our Teradata DB, and import the MetaData for them, but we just can't execute a query or view the data through the DS Browser.

This is the error we are getting:

DSBrowser......DSD.GetDBMSDetails call to SQLAllocStmt failed
DSBrowser......DSD.BCIOpenR call to SQLAllocStmt failed
DSBrowser......DSD.BCIClose call to SQLDisconnect failed

Any thoughts or sugestions?

Thank you!

ray.wurlod · Post by **ray.wurlod** » Wed Oct 10, 2007 4:50 pm

Welcome aboard. Try creating and running a small job to see if the job can access data (the data browser is a different beast).
ODBC -----> Peek

rpaulin · Post by **rpaulin** » Thu Oct 11, 2007 7:57 am

Thank you Ray!

I did just that, and was able to see the records from a table in our database.

That must therefore mean that the ODBC connection is configured properly correct? Does DSBrowser require any additional configuration?

Cheers!

rpaulin · Post by **rpaulin** » Thu Oct 11, 2007 9:14 am

Further to my note above...

I was able to view the data through DSBrowser on the parallel ODBC job, however not using the server ODBC job.

Is there any difference in configuring ODBC between Parallel and Server?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 11, 2007 2:51 pm

No, but they are completely different data browsers - the server one is written in BASIC, the parallel one uses osh.

rpaulin · Post by **rpaulin** » Thu Oct 11, 2007 4:46 pm

That's what I figured.

Therefore I must assume there is something wrong with the DS install, and not my ODBC configuration in the dsenv, .odbc.ini or uvodbc.config.

Do you know of any issues or bugs with the Server ODBC stage? I haven't seen any on the IBM site.

Thanks again!