FW: Progress DB from dotNet

From: Steven Mulkerrins

Date: 1 Jul 2004

Hi All,

I'm trying to read the schema from a progress database from a .Net program
through ODBC. I keep getting error 20003 (state 42000), lookup this up I see
it's usually caused when there's table/field names with '-' in them (which I
have to deal with in some legacy databases). Has any body got any tips for
doing this kind of thing ? I know that when you have a table/field name you
can put quote marks around it but what I'm trying to do here is load the
schema so I can see the table/field names. Is it possible to read from _File
and _Field ?

I'm trying to create a generic reporting tool that let's the user select a
database and then which tables/fields they want maybe someone knows a
workaround ?


Thanks,
Steve