Hi,
I am new to the world of mobile technology and pocket pc's.
Here is a little background.
We have a big enterprise application written in a language called Gupta team
developer. This application currently support downloading some date to a
local database on a laptop. The supported local databases are Sql MSDE, Sql
server 2005 express and Sqlserver 2005 compact.

Since windows mobile 2003 supports sql server 2005 compact I was hoping that
I could use the exact same code for all the data synchronisation.
However as I understood the only way to connect to the database on the
mobile device is from visual studio.
I have tried using the exact same connection string in vs2005.net and my
development tool:
PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source=Mobile
Device\Program Files\TM_MOBILE\\TMMOBILE.sdf;
It works fine from vs.net but not from my dev tool.

So down to the questions:

1) is there a work around so it is possible to connect to the database on
the device using the mobile OLEDB driver?

2) If 1) is a dead end.
How can I programatically (outside visual studio) copy the sdf file from the
mobile device to the desktop pc and back?.
The i could use the same code for the database stuff.
How can I make sure the the application on the mobile device is not
connected to the database?
The solutions can under no cercumstances include any manual steps (beside
docking the pda) as the users of the system is not exactly IT experts.
Is there any way of making my application subscribe to a message, so it will
know when the mobile device is docket?

Please bare in mind that I am new to this world!

I would like to avoid writing any code in visual studion if possible !

Best Regards
Jonas

You connection string looks ok. Can you create a COM object in Gupta and
use code similar to this:
osqlce=CREATEOBJECT('ADODB.Connection')
osqlce.ConnectionString=Connectionstring
n=osqlce.Open()
-Anders

"Jonas Mandhal Pedersen" <jmp@jmp.dk> wrote in message
news:esVxOHjpHHA.4400@TK2MSFTNGP03.phx.gbl...
> Hi,
> I am new to the world of mobile technology and pocket pc's.
> Here is a little background.
> We have a big enterprise application written in a language called Gupta
> team developer. This application currently support downloading some date
> to a local database on a laptop. The supported local databases are Sql
> MSDE, Sql server 2005 express and Sqlserver 2005 compact.
>
> Since windows mobile 2003 supports sql server 2005 compact I was hoping
> that I could use the exact same code for all the data synchronisation.
> However as I understood the only way to connect to the database on the
> mobile device is from visual studio.
> I have tried using the exact same connection string in vs2005.net and my
> development tool:
> PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0; Data Source=Mobile
> Device\Program Files\TM_MOBILE\\TMMOBILE.sdf;
> It works fine from vs.net but not from my dev tool.
>
> So down to the questions:
>
> 1) is there a work around so it is possible to connect to the database on
> the device using the mobile OLEDB driver?
>
> 2) If 1) is a dead end.
> How can I programatically (outside visual studio) copy the sdf file from
> the mobile device to the desktop pc and back?.
> The i could use the same code for the database stuff.
> How can I make sure the the application on the mobile device is not
> connected to the database?
> The solutions can under no cercumstances include any manual steps (beside
> docking the pda) as the users of the system is not exactly IT experts.
> Is there any way of making my application subscribe to a message, so it
> will know when the mobile device is docket?
>
> Please bare in mind that I am new to this world!
>
> I would like to avoid writing any code in visual studion if possible !
>
> Best Regards
> Jonas
>
>