Re: Connection to SQL Server from within the emulator - newbie que

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

Matthew,

I tend to more testing with a real device rather than an emulator, so that
might be an option for you. It doesn't have to be the exact device - just
close enough so hopefully you can get past this snag. What is the connection
string that works in the desktop app?

--
Ginny Caughey
Device Application Development MVP


"Matthew" <Matthew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:68ECB22D-7493-4D83-AA53-775140106257@xxxxxxxxxxxxxxxx
Hi Ginny,

Thanks for sticking with me on this one. I have installed the loopback
adapter, checked the IP address and can ping the IP address from the
command
line.

I am now trying to connect but getting a different error now - "Invalid
Connection".

Is there anything I need to change in SQL Server now that I have the
loopback adapater installed? What is the best way to test the SQL
connectiopn
using the IP address with another application apart from the emulator?

Thanks once again.
Matthew




"Ginny Caughey [MVP]" wrote:

Matthew,

If there is no real network address, you can use the Microsoft Loopback
Adapter. Use the search engine of your choice to search for that to see
how
to install it, then use ipconfig.exe to see what IP address the loopback
adapter has.

--
Ginny Caughey
Device Application Development MVP


"Matthew" <Matthew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1CB6455F-FD28-4D23-A4BC-E764FB95AA0E@xxxxxxxxxxxxxxxx
Hi Ginny,

Thanks for your reply. I am using a laptop that has a wireless
broadband
connection but is not plugged into a physical network connection. I
have
tried using IP address 127.0.0.1 but it doesn't work.

I am not really up to speed with IP addresses. How do I know which IP
address to use. Sorry if this is a really dumb question.

Regards,
Matthew

"Ginny Caughey [MVP]" wrote:

Matthew,

Are you connecting to SQL Server using its IP address? For example,
any
localhost address won't work from a device or emulator. If you're
using
Integrated Security you must provide the domain\user name and password
from
mobile devices although you don't from desktops.

--
Ginny Caughey
Device Application Development MVP


"Matthew" <Matthew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:49123094-B987-4514-B6CC-D0323844224B@xxxxxxxxxxxxxxxx
I am trying to connect to a SQL Server database running on my laptop
from
within the emulator. I am receiving the 'SQL Sever does not exist or
access
denied' error. (I can connect to the database sucessfully from
within a
normal Visual Studio Windows application using the same connection
string)

I have the emulator 'cradled' before I run the app. It appears to be
connected as I can browse the Internet from within the emulator.

Are there other emulator settings that need to be changed?

Any help would be appreciated as this has stopped me in my tracks.

Thanks,
Matthew








.

Relevant Pages

  • Re: Connection to SQL Server from within the emulator - newbie que
    ... I have installed the loopback ... adapter, checked the IP address and can ping the IP address from the command ... using the IP address with another application apart from the emulator? ... connection but is not plugged into a physical network connection. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Connection to SQL Server from within the emulator - newbie que
    ... 'Personal' edition of SQL Server 2000 installed. ... using the IP address with another application apart from the emulator? ... to install it, then use ipconfig.exe to see what IP address the loopback ... connection but is not plugged into a physical network connection. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SQL Server connectivity with SmartDevice app
    ... resulted in the emulator stating that I have to configure a proxy server. ... > address of cindylulaptop versus the machine name in your connection string. ... >> possible to connect to SQL Server through a SmartDeviceApplication. ...
    (microsoft.public.pocketpc.developer)
  • Re: connecting app in Pocket Pc emulator to local SQL server
    ... You are having trouble connecting to Sql Server from Pocket PC Emulator. ... values in your connection string is incorrect. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Connection to SQL Server from within the emulator - newbie que
    ... but you can enable it using the SQL Server ... using the IP address with another application apart from the emulator? ... to install it, then use ipconfig.exe to see what IP address the ... connection but is not plugged into a physical network connection. ...
    (microsoft.public.dotnet.framework.compactframework)