Re: ODBC(No column properties collection) vs Jet (alphabet ordering)

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/28/04 

Date: Thu, 27 May 2004 22:04:16 -0400

Hi Vyacheslav,

There is no magic here. ADOX relies on a provider's capabilities to return
information about database. In case of Jet, it will return some information
about the database objects, because Jet was designed for Access itself. In
a case of OLEDB for ODBC, provider cannot return some information, because
it was designed as a layer between ADO and ODBC driver. Basically it relies
on a capabilities of ODBC. Any reason why you need to use OLEDB for ODBC? 

-- 
Val Mazur
Microsoft MVP
"Vyacheslav Lanovets" <xentrax@umail.ru> wrote in message 
news:uzn7ITAREHA.2404@TK2MSFTNGP11.phx.gbl...
> Hello, All!
>
> I've got a problem.
> While investigating db schema with ADOX + Jet 4.0 I am getting alphabet 
> ordering of columns in tables.
>
> While using OLEDB for ODBC  I am getting Column.Properties.Count == 0 (i.e 
> empty collection)
>
> In result table for Connection.OpenSchema(adSchemaColumns) I did not found 
> a column with _Seed_ value for IDENTITY.
> Did I miss something????
>
> As a solution I am goint to read it twice - with Jet, storing properties 
> in hash map object and then using ODBC - so getting correct ordering 
> position.
> May be there are beter ways to get "Default" and "Seed"(!) values?
>
> Vyacheslav Lanovets
> MCSD
>
>

Relevant Pages

  • Re: RecordSet fails if a field is null ! - unspecified error 80004005
    ... Yeah thats what I was doing to be sure. ... Could your database be corrupt? ... Maybe something is wrong with your Jet components. ... I didnt think you could use ODBC with access... ...
    (microsoft.public.scripting.vbscript)
  • Re: Access SQL Scalar Function DAYOFWEEK Problem
    ... by the JET ODBC driver for the JET engine to understand and process the ODBC ... Scalar Function DAYOFWEEK. ... Dim strConn As String ...
    (microsoft.public.access.queries)
  • Re: Replacement for Dao
    ... then open both and fetch from the database. ... Jet Engine to be deprecated soon - in fact Jet will not be available at all ... > that Jet actually provides ADO support through its ODBC (I am still ... > was straight forward in Dao) and hence ODBC may perform better than ADO. ...
    (microsoft.public.vc.database)
  • Re: ADO.net Code contest
    ... Ah, actually, accessing an Access database is done through JET. ... generic interface like OLE DB or ODBC from any data access interface ... ODBC, OLE DB are ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ODBC Refresh Interval
    ... isn't a huge deal most of the time), is that I can't rely on FindFirst! ... a form bound to an ODBC linked table, ... with Jet x.y, or Jet y.z, or whatever. ... ADO is dead, of course. ...
    (comp.databases.ms-access)