Mobile 5 Emulator not Connecting to SQL Server

  • Thread starter Thread starter JackW9653
  • Start date Start date
J

JackW9653

We are building a new Pocket PC Application in VS2005 from an exisiting
one that was created in VS2003. We use TCP/IP to connect to SQL Server
via wireless.The existing application uses the following connection
string:

<add key="connStr" value="Data Source=192.168.0.12,1433;Initial
Catalog=IPED;User ID=User01;Password=PW01"/>

We upgraded the app to VS2005 and after some tweaking of 3rd party
controls we got it to compile. We have installed the Emulators from the
Mobile 5 SDK and can deploy it fine, but we get the dreaded "SQL Server
not Found or Access Denied" on the Emulator. But if we deploy to an
actual device it connects to SQL without a problem.

We have tried everything we have read in the forums and can not solve
this issue. Any help would be appreciated. Since the connection string
works on the device it has eliminated all of the other factors, so it
has to be an emulator issue. I have also set a static ip on the
emulator, but that didn't help either.

Thank you in advance for any help,

Jack Willhoite
Senior Software Architect
MEDadept
 
Jack,

In your post you noted that you had tried "everything you read in the
forums" and had even given the emulator a static IP; however, I'm not clear
if you have ruled out any general network connectivity issues with the WM5
emulator. Can you point Internet Explorer Mobile to an internal (i.e.
192.168.x.x) site (or even to your SQL Server at 192.168.0.12) and connect?
I know it is rather basic, but before we go diving down a potentially more
complicated path I wanted to be clear on this point.

Also, is your app CF 1.0 or CF 2.0? You noted that you upgraded it from
VS2003 to VS2005, but I didn't pick up if you changed the targeted CF version
as well.
 
Hello Nino,

Thanks for the reply. I do not have an internal site to connect to, so
I'm not sure how to rule out the general network connectivity issues.

This app is using CF 2.0 and all of the SQL Connection .dlls are being
deployed with the app to the emulator.

Jack
 
Jack,

A few suggestions:
1) Install PocketPing
(http://www.luzerner-singknaben.ch/kalian/pocketping.php) on your emulator.
See if you can ping your SQL Server.

2) Deploy your application to the emulator, then cradle it(be certain to
select 'Allow connections to one of the following' with a value of 'DMA' in
the ActiveSync connection settings). You can use the Device Emulator Manager
(under the Tools menu in VS2005) to cradle it (and you can cancel out of the
AS partnership request so that you'll only have a Guest partnership).

3) Try the virtual switch network driver as Barry Bond noted in the
following post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=357116&SiteID=1

I would suggest option 2 as the quickest, least-pain route to being certain
about having connectivity on your network.

hth,
Nino
 
Nino,

Thank you very much. It was the DMA setting in Active Sync. I changed
that and the world is a wonderful place again.

Jack
 
Back
Top