DSXchange

I am trying to import a Progress table definition from DataStage Manager using the the import table definition ODBC table definitions. I have the Progress ODBC drivers installed on my DataStage server. I have also, added the necessary DSN, services, and host definitions entries. I get the following error message when I try in import:

DSR.MetaGeta(GET.TABLES)(SQLConnect('trhead','dstage')): BCI Error:
SQLSTATE=S1000,CODE=0,[DataStage][SQL Client][ODBC][INTERSOLV][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS

Anyone have any ideas what the problem might be?

Does the user ID you're using have privileges sufficient to SELECT the system tables in the Progress database?
What are the permissions on the PROMSGS file?

Hi,
It could be PROPATH problem or file permissions.
Make sure file is in PROPATH and is readable to the application under the enviornment it is run.

Ketfos

I have all the permissions that Ray and Ketfos suggested.

Someone told me last night that I needed the Progress database installed on the DataStage server. Can someone confirm this?

you will need to install Progress client (networking) and also the odbc driver.

Thanks 1stpoint.

I had the odbc drivers installed already. But I didn't know that I needed the Progress Client installed as well. It doesn't make sense to me.

Unless they are 'wire' drivers, ODBC typically (always?) needs the client to piggy-back over - regardless of database.

I'm not familiar with the term 'wire' driver. I've been a UniVerse/Unidata programmer for 15 years and all this Database stuff is new to me. Is SQL Server a 'wire' driver? I've been importing table definitions from it for a while without installing the client.

Thanks again for your responses.

It doesn't have anything to do with the database iteself. Wire Drivers are a type of ODBC connection that do not require client libaries. DataDirect has a nice little page here that should help explain the difference.