Posts:
1
Registered:
4/18/08
|
|
|
|
Cannot access some tables in Progress db
Posted:
Apr 18, 2008 10:33 AM
|
|
|
I am trying to access a Progress database from C# using the DataDirect 4.10 driver.
Unfortunately some of the tables contain a '-' (dash) character in the name.
the code snippet below :-
cmdStr = "select * from pub.ana-codes";
OdbcCom = new OdbcCommand(cmdStr, OdbcCon);
OdbcDR = OdbcCom.ExecuteReader();
produces this error
ERROR [42S02] [DataDirect][ODBC PROGRESS driver][PROGRESS]Table/View/Synonym not found (7519)
I have tried using an escape sequence in the SQL e.g.
cmdStr = "select * from \"pub.ana-codes\"";
but this gives the same error.
Can anybody tell me how to access these tables (I do not have authority to change their names), I do not have an issue with any other tables.
Many thanks
Alan Hood
|
|
