Connection String Error

[James-R]

I am trying to make a program for a WM5 Pocket PC.

I want it to use an access db for storing all the data when I tried this:

Dim sqlCon As New Data.SqlClient.SqlConnection()
        sqlCon.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=ProStudent.mdb"
        'sqlCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\ProStudent.mdb;"
        sqlCon.Open()

It said that there was an option error with the connection string.

What am i doing wrong? / What connection string should I use ?

[techgnome]

You're using the wrong data access classes..... SQLClient is ONLY, I repeat ONLY for SQL Server. If you are trying to access an Access databse, use the OLEDBClient namespace. And use the JEt driver, not the access driver.

-tg

[petevick]

Hi,
you can't access an access database directly from PPC - your options are SqlClient to access SqlServer or SqlCEClient to access SqlMobile on the device.
There is an article here on accessing a database on the PPC and here on accessing SqlServer from your PPC.

There are 3rd party solutions to access MDB's from the PPC, including 1 from my company, SqlLinkCE

Pete