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
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers