By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,573 Members | 1,812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,573 IT Pros & Developers. It's quick & easy.

Access db to ado.net data type conversions?

P: n/a
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!
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <br******@adelphia.net> wrote in message
news:uB**************@TK2MSFTNGP12.phx.gbl...
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!

Nov 20 '05 #2

P: n/a
On Wed, 8 Oct 2003 14:10:34 -0400, "Brian Henry" <br******@adelphia.net> 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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.