Emulator won't open the SQL network server

[szlamany]

I had to do a hard reset on my pocket pc 2003 emulator.

Now it will no longer open the network sql server - using SQLConnection.

How do I make sure that the emulator has the SQLConnection stuff installed??

[petevick]

Hi,
if you run your app from VS to the emulator, it should re-install SqlCe etc

Pete

[szlamany]

Hi,
if you run your app from VS to the emulator, it should re-install SqlCe etc

Pete

and it is not - this happened on my handheld ppc last month and it fixed itself after installing some new SQLCE downloads on my laptop...

but I cannot get the emulator to do this...

Googling for: specified sql server not found sqlclient emulator

finds some MS Technet sites - but they don't appear to be working right now!

[petevick]

Hi,
just added the references to a new project, and clicked on 'run' in VS2005 and it deployed the following to the emulator:-
Deploying 'C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce400\ARMV4\sql.ppc.wce4.armv4.CAB'
Deploying 'C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce400\ARMV4\sql.dev.enu.ppc.wce4.armv4.CAB'

I then put a connection string behind a button, clicked on it, and all was sweetness and light.

When I went into 'add remove programs' on the settings>remove programs on the emulator, I saw the entries for Microsoft SQL Client there - do you see those on your emulator?

Pete

[szlamany]

Here is a thread where I had the same problem on the PPC itself 2 weeks ago.

http://www.vbforums.com/showthread.php?t=483020

I wish I had a clear experience in troubleshooting that one - it all of a sudden started working after downloading fresh SQL stuff from MS.

We are going with plan B - which is demo how the program works on the PPC without showing them the sync back to network db today (it's in 5 hours - so not much room for error right now).

Here's what my PPC emulator program list looks like - I wonder if I've got some duplicates getting in the way?

[petevick]

Hi,
looks fine - just that you have SqlClient and SqlMobile loaded - shouldn't be a problem.

Is the emulator just failing to connect to SqlServer? Have you cradled the device (In VS2005 Tools>Device Emulator Manager). Here you can open and cradle the emulator.

Pete

[szlamany]

I am back to having issues with this - we are trying to work up a new release of our PPC app after having it in production for a year...

Having problems opening network DB's from my laptop using the emulator. Seems that it's "only" seeing the local sql server 2005 express on the laptop - that is grabbing the connection even though we are asking to open a network DB.

Anyone else ever experience this?

Anyone know of MS acknowledging this error or releasing fixes for it?

I also re-opened this other thread - probably didn't really need to

http://www.vbforums.com/showthread.php?t=483020