I'm writing a simple program for PocketPc in Visual Basic.
I try to establish a connection with dbExemple.mdb an Access database with Data Source Configuration Wizard in Visual Studio 2005 using these parameters:
Data Source: Microsoft Access Database File
Data Provider: .NET Framework Data Provider for OLE DB (compulsory)
The string in advanced properties is:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\dbExemple.mdbTest Connection: Succeeded.
I confirm on the OK button but an error message appear:
The new connection uses a data provider that is not supported.
In server explorer I have
Data Connections ACCESS.D:\dbExemple.mdb Table ... Views... ..... I'm not professional, how can I bypass this problem
Data provider not supported
paulconstantine
Providers supported on devices and included with VS 2005:
SQL Mobile and SQL Server 2000/2005/Express/MSDE (SQL Client).
Providers included with VS 2005 for desktop, but NOT supported on devices:
OLEDB, ODBC and Oracle.
3rd party providers might be available.
Please see this:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=221300&SiteID=1
dshaykewich
I can't find any clear statement of this anywhere, but essentially the only supported driver is the "Microsoft SQL Server Mobile Edition" driver.
The SQL Server Mobile Edition is designed to replace Access on mobile devices.
Steve Teixeira
Tanks
Pedro Damian
Randine
Rachana Rao
We seem to be getting this error when attempting to add a SQL SERVER 2000 Data source into our project. Note, the SQL Server is on another server on our network....
I thought this was supported straight out of the box with windows mobile 5
JC