ADOX: ODBC(No column properties collection) vs Jet (alphabet ordering)
From: Vyacheslav Lanovets (xentrax_at_umail.ru)
Date: 05/27/04
- Next message: tony: "nText field not displaying (ASP)"
- Previous message: Gary Jenovai: "Problem using FMT=Delimited to read comma delimited"
- Next in thread: Val Mazur: "Re: ODBC(No column properties collection) vs Jet (alphabet ordering)"
- Reply: Val Mazur: "Re: ODBC(No column properties collection) vs Jet (alphabet ordering)"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 May 2004 20:07:50 +0400
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
- Next message: tony: "nText field not displaying (ASP)"
- Previous message: Gary Jenovai: "Problem using FMT=Delimited to read comma delimited"
- Next in thread: Val Mazur: "Re: ODBC(No column properties collection) vs Jet (alphabet ordering)"
- Reply: Val Mazur: "Re: ODBC(No column properties collection) vs Jet (alphabet ordering)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
