is there info about data type conversions between access to ado.net? I have
tried a lot of the ones that say oledb data types should work for and get a
lot of "data type mismatch" errors using them.. is there a sheet somewhere
or a refrence for them? all i really need to know is

Access ADO.NET
Numeric Integer/numeric?
Memo VarWChar?
Text VarWChar?
Date/Time ? (dbdate never seems to work)
Yes/No Boolean

what are the correct conversions of oledb.oledbtype? thanks!

I'll give a very simple way to solve your problem and hopefully help you
stream line your develpment. Open a connection to you access mdb using the
server expolerer. Drag the table you want to use onto your form this will
create a connection object and a data adpater. Look on the tool bar for the
Data menu item click on it the click generate dataset. This will give you a
strongly type dataset that you can use through out your app.

FYI you can even specify which column you want by opening up the table and
highlighting specific fields. You can also change these by opening the data
adapters select commands text attribute. it will open a query builer that
will allow to build what ever type of query make you happy.

Hope this helps you!

-Wiz



"Brian Henry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> is there info about data type conversions between access to ado.net? I
have
> tried a lot of the ones that say oledb data types should work for and get
a
> lot of "data type mismatch" errors using them.. is there a sheet somewhere
> or a refrence for them? all i really need to know is
>
> Access ADO.NET
> Numeric Integer/numeric?
> Memo VarWChar?
> Text VarWChar?
> Date/Time ? (dbdate never seems to work)
> Yes/No Boolean
>
> what are the correct conversions of oledb.oledbtype? thanks!
>
>

On Wed, 8 Oct 2003 14:10:34 -0400, "Brian Henry" <(E-Mail Removed)> wrote:

¤ is there info about data type conversions between access to ado.net? I have
¤ tried a lot of the ones that say oledb data types should work for and get a
¤ lot of "data type mismatch" errors using them.. is there a sheet somewhere
¤ or a refrence for them? all i really need to know is
¤
¤ Access ADO.NET
¤ Numeric Integer/numeric?
¤ Memo VarWChar?
¤ Text VarWChar?
¤ Date/Time ? (dbdate never seems to work)
¤ Yes/No Boolean
¤
¤ what are the correct conversions of oledb.oledbtype? thanks!
¤

OLE fields are System.Data.OleDb.OleDbType.LongVarBinary

You can compare the System.Data.OleDb.OleDbType enum with ADOX.DataTypeEnum in order to determine
the corresponding data column types.


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)