Click to See Complete Forum and Search --> : Replace OLEDB provider Jet 3.51 with Jet 4.0


February 24th, 2000, 02:45 AM
I wrote an VB application, which works with an Access 97 database via ADO
2.0 on an NT 4.0 machine. Using the 3.51 OLEDB provider the application
works without problems. When I replace the 3.51 provider with 4.0, the
follow problem occures:

With provider 3.51 textfields are returned as "adVarChar". Now with provider
4.0 these textfields are returned as "adVarWChar". This causes some problems
in my application.

Is it possible to make a special setting on the 4.0 provider, that the
textfields will be returned as "adVarChar"?

Orlando