N. America: 800 876 3101 | World: 44 (0) 1753 218 930
|
Replies:
3
-
Pages:
1
-
Last Post:
Sep 6, 2009 2:11 PM
by: olegww
|
|
|
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
|
|
Posts:
2
Registered:
3/26/09
|
|
|
|
Re: Cannot access some tables in Progress db
Posted:
Mar 26, 2009 11:10 AM
in response to: Alan Hood
|
|
|
Hi,
use this: "select * from SPORTS.PUB.Customer Customer_0";
|
|
Posts:
3
Registered:
8/24/09
|
|
|
Posts:
3
Registered:
8/24/09
|
|
|
|
|
