Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

OK

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?