Repost: Why can't access my local SQL Server from PocketPC 2003 SEEmulator

  • Thread starter Thread starter Ilya Tumanov [MS]
  • Start date Start date
I

Ilya Tumanov [MS]

Good, that leaves only incorrect connection string. Your connection string
using named instance "Server=VES\SQL2K" which is not going to work as
devices do not support named pipes (that's how it connects to named
instance - by connecting to named pipe). Use something like this instead:
"Server=VES, 1433;"

If you have several instances you would need to specify port number desired
instance is listening on instead of instance name. That works because only
once instance can listen on a port.



Also see this:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=335660&SiteID=1




--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).
 
I (and some other guys here) had asked this before with no response so
far. So I'm reposting the question in a hope than someone have some
clue about this problem.

Environment:
VS 2005
MSDE 2K
PocketPC 2003 SE Emulator, cradled.
PDA IP: 192.168.55.101
Microsoft Loopback adapter. IP: 192.168.10.1

Problem:
When trying to connect to my PC's MSDE 2K server I got an error. The
specific error depends on how I tried to connect to the server:

Server=server\instance: Specified SQL server not found: server\instance
Server=ip\instance: : Specified SQL server not found: server\instance
Server=server\instance,port: Invalid connection
Server=ip\instance,port: Invalid connection

My Connection String is:
Server=VES\SQL2K;uid=sa;pwd=xxxx;Database=zuoz;Persis Security
Info=False;Integrated Security=False;Connect timeout=5;

This same connection string works well from any other program in my PC
AND from Pocket PC 2000 Emulator.


Any ideas on why can connect to SQL Server ?


Victor Espina
 
I should include this too:

a) I disabled my firewall during tests to avoid any blocking problem
b) I checked my SQL Server instalation to verify it is using 1433 port.
c) I installed vxUtils in PPC 2003 Emulator and verified that 1433 port
in my local machine is actually open.
d) I can connect to SQL Server from other applications using the exact
connection string I'm using from PPC. This discard any
connectionstring-related explanations.

TIA

Victor Espina
 
Hum, ok. Good point. I didn't know PPC doesn't support named instances
of SQL Server. I read the link you posted and a dozen more, and still
cant find a way to connect to a named instance using just server and a
port. Could you point to some online material wich explains how to
configure my named instance of SQL Server to allow connections using
just the server name and a given port?

TIA

Victor Espina
 
Ilya, I just installed a default instance of SQL Server Express 2005 in
my PC, using mixed authentication.

Now, when I try to connect to this server from PPC2003SE Emulator I get
"General Network error" error. This is the new connection string I used:

Server=VES,1434;uid=sa;pwd=xxxx;database=mydb;Persist security
info=false; Integrated Security=false; connect timeout=5;


I used vxUtils to check TCP port used by sql server and is open. Also, I
check that I can connect to this new server using the same string
connection I'm using from PPC emulator and it does connect.

So, know that named instances is not the issue, what could be the problem?

I'll really appreciate the help you can give me about this. I have an
important presentation of this app next thursday and I need to have this
figured out by then.

TIA

Victor Espina
 
Back
Top