Re: OleDb connection string to Sql server mobile edition

Thanks Rick,

No help, still getting could not find file.
What I have done so far is copy the files:
sqlceca30.dll, sqlcecompact30.dll,
sqlceer30en.dll,sqlceme30.dll,sqlceoledb30.dll,sqlceqp30.dll,sqlcese30.dll
to my dir and register the sqlceoledb30.dll.

Do i need to do anything in active sync to get up running?

Jonas

"dbgrick" <dbgrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9F7ED9EE-A3D5-4361-98BA-AE9E9DB93FE3@xxxxxxxxxxxxxxxx
Try using the path "\\Program Files\\TM_MOBILE\\TMMOBILE.sdf" You should
not
need to use Mobile Device, and the number of back slashes are important.

Rick D.
Contractor

"Jonas Pedersen" wrote:

I am trying to connect from my application to a sql server on my pocket
pc,
using this connection string.
PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source=Mobile
Device\Program Files\TM_MOBILE\\TMMOBILE.sdf;
I get error:
"The path is not valid. Check the directory for the database.
[,,,Path,,]"
The connection string works in visual studio server explorer.

If I connect to a db on my pc i.e.
PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data
Source=C:\\TM_MOBILE\\TMMOBILE.sdf;
It works fine

Any help would be appreciated.

Jonas





.

Relevant Pages

  • Re: Event Disconnect
    ... I have created an application where the user register some records for the ... Therefore for the year 2004 I use a database called Archive_2004 e for the ... "Val Mazur" ha scritto: ... > Did you hardcode database name into connection string of you application? ...
    (microsoft.public.vb.database.ado)
  • Re: VBEventsRegistration Sample Connection Problem
    ... I think the issue I have is that I am not specifying the folder to connect ... "foo.com" and I want to register the event sink. ... > I am trying to register the sample event sink from Exchange2003 SDK. ... > Here is the connection string from the sample.. ...
    (microsoft.public.exchange.development)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ... When the user exits the dialog box, the driver connects ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Change Connection String at runtime.
    ... easily moved to another database, or have versions for each database. ... connection string to the connectionobject before the connection opens. ... *The Server IP number is different for every deployment. ... It appears that the generated code uses the application settings to ...
    (microsoft.public.dotnet.framework.adonet)
Loading