OleDbConnection.GetOleDbSchemaTable will do what you want. You may have to decode some of the values it provides, though. For example, a MEMO field in Access shows up as a field of DBTYPE_WSTR and has the DBCOLUMNFLAGS_ISLONG bit set (0x80 or 128 in decimal) when you look at the rowset of COLUMNs (OleDbSchemaGuid.Columns). The columns in the schema rowset that you are looking for are DATA_TYPE and COLUMN_FLAGS.
The OleDb data provider is the best provider for DBMS independent metadata, as the Odbc data provider does not yet support this completely (it would have to get this info through ODBC's SQLColumns or SQLSpecialColumns). Hope this helps, Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Chris M. Szurgot [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 3:45 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] ADOX in .NET I'm not the person who originally asked, but this is something I've been looking at lately. Just how do you get schema information in a DBMS independent way? In particular, I'm looking at Access & DBFs, and want to know when something is a memo, which is not something you can get from a dataset schema. Thanks, Chris -----Original Message----- From: Beauchemin, Bob [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 5:54 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] ADOX in .NET There is no replacement yet for ADOX. You can use it through COM interop. Do you need to access (read) tables metadata or *define* tables, indexes, etc? To read metadata on a DBMS independent (OleDbConnection.GetOleDbSchemaTable) or SQL Server-specific (but standard) "select * from information_schema.xxx" basis is certainly possible. I'm almost certain (not knowing exactly what you are doing) that using DataSet doesn't get you what you want. Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Alireza Kheyrollahi [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 2:17 PM To: [EMAIL PROTECTED] Subject: [DOTNET] ADOX in .NET ----- Original Message ----- From: Alireza Kheyrollahi To: dotnet discussion Sent: Sunday, May 05, 2002 10:03 PM Subject: ADOX in .NET Hi all, Does anyone know what has replaced ADOX in .NET? In my new project I need access to tables metadata (like field names, types, foreign keys and ....) Does DataSet class impements those functionalities? Thanks Ali You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
