Re: SQL Server CE Noob Setup Help

Tech-Archive recommends: Fix windows errors by optimizing your registry

John,

I'm not sure that CE 4.2 is supported as a data source location for SQL Mobile on VS 2005, even though you can run the apps you create with it. You might consider copying the sdf file to your desktop computer and using that with the VS 2005 Data Source tools.

--
Ginny Caughey
Device Application Development MVP


<ibidibi411@xxxxxxxxxxx> wrote in message news:495c7b3f-c44f-4896-851b-c39c9838e6a6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I'm using an Intermec Pocket PC v4.20.1081 with an ARM PXA255
processor. It is connected to my computer, with is running SQL Server
and Visual Studio 2005. I am using VB to write database apps on the
Intermec.

Anyway, I can get my app to deploy perfectly on the Intermec and have
no trouble, but every time I try to set up a database using Data/Add
Data Source from VS2005 it gives me a vague error that there's
something wrong with the setup. I select Database, then New
Connection, Microsoft SQL Server Mobile Edition, then Active Sync
Connected Device, enter a file name and get the error:

"Microsoft SQL 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."

I get the same error if I do the test connection as well.

Prior to this I installed the MSSQL/CE 3.5 cab files onto the device
through ActiveSync. I copied the files from the Devices\wce400\armv4
folder and ran them on the Intermec.

Any guidance on how to get started with this would be greatly
appreciated. There doesn't seem to be much in the way of step-by-step
walkthroughs or guides for getting this stuff to work...

Thanks,

John Davis

.

Relevant Pages

  • Re: VB code for filtering mail merge
    ... Peter thank you very much. ... database icon to select your Word data source, specify query options, then ... field and you should see what the SQL looks like. ... Connection string so that when you try to re-execute the recorded macro, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: VB code for filtering mail merge
    ... record in the macro recorder in Word 2002/3. ... database icon to select your Word data source, specify query options, then ... field and you should see what the SQL looks like. ... Connection string so that when you try to re-execute the recorded macro, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: VB code for filtering mail merge
    ... SQL statement area. ... The filtering options I selected while recording that macro did produce the ... What actually works depends largely on the data source and partly on the ... Connection string so that when you try to re-execute the recorded macro, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Accessing Mobile SQL databases in VB2005. Do you need SQL Mgt.
    ... CSV could still be a good approach for what you want to do. ... > Found a number of references to sqlcese30.dll, all for mobile processors ... > PC need to be posted to the Desktop which will run SQL Express. ... >> Ginny Caughey ...
    (microsoft.public.pocketpc.developer)
  • Re: SQL Mobile web downloads have gone live!
    ... Microsoft SQL Server 2005 Mobile Edition Device SDK - The SDK ...
    (microsoft.public.sqlserver.ce)