SQL Server connectivity with SmartDevice app

First, let me say a BIG THANK YOU to the awesome MVPs who freely share their
knowledge that they worked so hard to earn. Where would we be without you?
Many thanks - you do a fantastic service.

I read the November 24 post in the pocketpc.developer.network forum that
said that it should be
possible to connect to SQL Server through a SmartDeviceApplication. I have a
working Windows App that talks great with SQL, so I copied over the exact
same connection info, but the SmartDeviceApp just times out as it is trying
to connect, even with a huge timeout string. It's not an issue with the
handheld, because I'm just trying to run it using the PC2003 emulator. The
code is so simple - below is a snippet from the load event of the form. It
does display
the "trying" msgbox OK, then after 500 seconds dies. HUGE gratitude in
advance for any hints.


Dim myConnString = "User ID=sa;Data
Source=cindylulaptop;Password=;Initial Catalog=M1_DD;Persist Security
Info=True;Packet Size=4096;Connect Timeout=500"
Dim myConnection As New SqlClient.SqlConnection(myConnString)

MsgBox("trying...")
myConnection.Open()
MsgBox("success")

myConnection.Close()

Darren
Thu Apr 28 23:02:09 CDT 2005

Cindy,

Can you verify that you can reach your development machine from the
emulator? (go to Pocket IE in the emulator and try to hit your default
web page on IIS). If so, you may get a quick fix by simply using the IP
address of cindylulaptop versus the machine name in your connection string.
--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"CindyLu" <CindyLu@discussions.microsoft.com> wrote in message
news:A97DBB1C-A22F-401C-A221-6C6D0B0855F3@microsoft.com...
> First, let me say a BIG THANK YOU to the awesome MVPs who freely share
> their
> knowledge that they worked so hard to earn. Where would we be without
> you?
> Many thanks - you do a fantastic service.
>
> I read the November 24 post in the pocketpc.developer.network forum that
> said that it should be
> possible to connect to SQL Server through a SmartDeviceApplication. I
> have a
> working Windows App that talks great with SQL, so I copied over the exact
> same connection info, but the SmartDeviceApp just times out as it is
> trying
> to connect, even with a huge timeout string. It's not an issue with the
> handheld, because I'm just trying to run it using the PC2003 emulator.
> The
> code is so simple - below is a snippet from the load event of the form.
> It
> does display
> the "trying" msgbox OK, then after 500 seconds dies. HUGE gratitude in
> advance for any hints.
>
>
> Dim myConnString = "User ID=sa;Data
> Source=cindylulaptop;Password=;Initial Catalog=M1_DD;Persist Security
> Info=True;Packet Size=4096;Connect Timeout=500"
> Dim myConnection As New SqlClient.SqlConnection(myConnString)
>
> MsgBox("trying...")
> myConnection.Open()
> MsgBox("success")
>
> myConnection.Close()
>
>

CindyLu
Sun May 01 19:01:01 CDT 2005

Darren - that was a great idea - wish I'd thought of it. But even though IP
is an enabled protocol for the SQL server, substituting its IP address for
the machine name still yielded the same results.

And I hate to confess what a greenie I am at this, but opening an instance
of IIE and entering the IP address of the machine launching the emulator
resulted in the emulator stating that I have to configure a proxy server.
Have to? That's weird - I don't have one, and didn't know it was a
requirement. Clicking on "setup a proxy server" on the emulator brought me
to a screen to do so, if I clicked on "This network connects to the Internet"
and OKed it, the setting doesn't stick. Auggh! Should it be this hard?
THANK YOU for your help!!!!!

CindyLu

"Darren Shaffer" wrote:

> Cindy,
>
> Can you verify that you can reach your development machine from the
> emulator? (go to Pocket IE in the emulator and try to hit your default
> web page on IIS). If so, you may get a quick fix by simply using the IP
> address of cindylulaptop versus the machine name in your connection string.
> --
> Darren Shaffer
> ..NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "CindyLu" <CindyLu@discussions.microsoft.com> wrote in message
> news:A97DBB1C-A22F-401C-A221-6C6D0B0855F3@microsoft.com...
> > First, let me say a BIG THANK YOU to the awesome MVPs who freely share
> > their
> > knowledge that they worked so hard to earn. Where would we be without
> > you?
> > Many thanks - you do a fantastic service.
> >
> > I read the November 24 post in the pocketpc.developer.network forum that
> > said that it should be
> > possible to connect to SQL Server through a SmartDeviceApplication. I
> > have a
> > working Windows App that talks great with SQL, so I copied over the exact
> > same connection info, but the SmartDeviceApp just times out as it is
> > trying
> > to connect, even with a huge timeout string. It's not an issue with the
> > handheld, because I'm just trying to run it using the PC2003 emulator.
> > The
> > code is so simple - below is a snippet from the load event of the form.
> > It
> > does display
> > the "trying" msgbox OK, then after 500 seconds dies. HUGE gratitude in
> > advance for any hints.
> >
> >
> > Dim myConnString = "User ID=sa;Data
> > Source=cindylulaptop;Password=;Initial Catalog=M1_DD;Persist Security
> > Info=True;Packet Size=4096;Connect Timeout=500"
> > Dim myConnection As New SqlClient.SqlConnection(myConnString)
> >
> > MsgBox("trying...")
> > myConnection.Open()
> > MsgBox("success")
> >
> > myConnection.Close()
> >
> >
>
>
>