Hi,

I was wondering if it is possible to call SQLTables and
SQLColumns for the ODBC classes in .NET. I see a method
in the OLE DB classes to get schema information, but I
haven't found this in ODBC.

Any ideas?

Hi Sandy,

I'm not quite sure what you need to do. Are you going to get the table and
column information for a database? Can you tell me what's the database
system? And which method did find in OLE DB class? Please provide me with
more information, so that I can deliver my assistance more quickly.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------

Hi Sandy,

There doesn't seems to be a method like GetOleDbSchemaTable in ODBC,
because ODBC deal with so many database systems that differs from each
other. However, there's a GetSchemaTable method in the OdbcDataReader class
to get the column information in a table. If you need to obtain information
about tables, I think you can use an adapter to fill the tables to a
DataSet, and get some of them from DataSet.Tables property.

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdataodbcodbcdatareaderclassgetschematab letopic.asp

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------

Hi Kevin,

GetSchemaTable is exactly what I need for the column
information. My only remaining problem is that I need to
know the names of all of the tables in the database. I
want to show the user a list of table names and let them
pick the ones they want to view.

Thanks for all of your help,

Sandy

Hi Sandy,

There doesn't seem to be such a function in ODBC to return all the table
names in a database. As I said in my last post, because ODBC deals with so
many database systems, and they are different from each other, .NET ODBC
Provider might not provide such a method.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."


--------------------
<1d6f01c38766$8075bec0$a401280a (AT) phx (DOT) gbl>
<KIACpqIiDHA.688 (AT) cpmsftngxa06 (DOT) phx.gbl>

I tried :
OdbcDataAdapter DA_Schema = new OdbcDataAdapter("SELECT * FROM
INFORMATION_SCHEMA.TABLES "+
"WHERE TABLE_TYPE = 'TABLE' "
,
// "ORDER BY TABLE_TYPE",
DB_Connection);

but recieved an error that INFORMATION_SCHEMA.TABLES .mdb does not exist.
This works on SqlCe. I would be a pity not to get the Table Names with the
ODBC Driver.
The GetOleDbSchemaTable Function with OleDb works with Access Databases.
Mark Johnson, mj10777.de.eu



"Sandy Pham" <Sandy.Pham (AT) FrontRange (DOT) com> schrieb im Newsbeitrag
news:292701c386cb$3842a280$a001280a (AT) phx (DOT) gbl...

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/odbc/htm/odch21bpr_11.asp

the url above has a reference to the SQLTables function
that Sandy was asking about. I also was wondering why
support for these function wasn't included in the ODBC.NET
Data Provider. The GetSchemaTable function in the
OdbcDataReader class requires that a query be submitted
first. In previous versions of ODBC, you could call
SQLTables to get a list of tables and views in a database
without having to submit any queries.

The SQLColumns function would return column attributes in
a similar manner but this too is missing from the ODBC.NET
Data Provider API.