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

Hi Ginny,

I finally got to the bottom of this. It turns out that my laptop had the
'Personal' edition of SQL Server 2000 installed. This edition doesn't seem to
listen for any tcp connections at all. I installed the 'Developer' edition of
SQL Server 2000 and all is good!

Thanks again for all your help.

Regards,
Matthew

"Ginny Caughey [MVP]" wrote:

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: VS 2008 Team - Database not supported / Cant load file or ass
    ... Visual Studio 2008 Team Database Edition ... SQL Server 2005 Enterprise SP2 ... Unable to add data connection. ... Install the following from Microsoft SQL Server 2008 Feature Pack RC0, ...
    (microsoft.public.vstudio.general)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • Re: Mobile 5 Emulator not Connecting to SQL Server
    ... Nino Benvenuti wrote: ... See if you can ping your SQL Server. ... Deploy your application to the emulator, ... This app is using CF 2.0 and all of the SQL Connection .dlls are being ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Using Vs2003 with a WinCE device
    ... Please note that the Addin to Vs2003 did install properly and I can create ... Netcf Apps that deploy to the Emulator. ... The WinCE Utils puts it here, ... >> connection but it refers to the following files that should have been ...
    (microsoft.public.dotnet.framework.compactframework)