get the following erroer when trying to connect to local db on ppc both emulator and device
using vb 2005 to create a PPC 2003 appliction
Unknown connection option in connection string: provider.
the error occurs at the following code
rdaPress.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\newsprint.sdf"
any help would be appreciated
Thanks
GS
Grant - get rid of the Provider= clause. Something like this should suit your needs:
"Data Source='\my documents\newsprint.sdf';Password='';Max Database Size='128';Default Lock Escalation ='100';"
-Darren
