Can't get SQL Connection string with IP address to work

[Bryan]

Hello,
I am using a windows mobile device with pocket PC, for some reason I cannot
get the sql connection string to use IP address instead of machine name. I
can get the IP to work with same connection string on my desktop PC to
server. I am thinking that there must be something different in the
sqlclient for the compact framework.
My connection string that works looks like this:
Data Source=MachineName\SQLEXPRESS;Initial Catalog=MYDB;User
ID=myid;password=mypass

I want to get this to work:

Data Source=192.168.0.15\SQLEXPRESS;Initial Catalog=MYDB;User
ID=myid;password=mypass

Any and all help is greatly appreciated!
Thanks,
Bryan

 

[Ginny Caughey [MVP]]

Bryan,

It works for me on my machine, but I also include the port number as well as
the IP address. You do have tcp/ip enabled for Express, right? It's disabled
by default.

Here's some code:

string hostComputerIP = "169.254.25.129,2301";
//open Connection to SqlExpress using IP address and port
// this example uses SQL Server authentication
string connString = "Data Source=" +
hostComputerIP + ";Initial Catalog=Northwind;user id=sa;password=Password!";

 

[Bryan]

Yes, I had to turn that on to get it to work even with machine name. I tried
the IP address with the port number, it didn't work either.

Thanks for your suggestions!

Any more help out there?

Bryan

 

[Ginny Caughey [MVP]]

Bryan,

The other might be that you can't reach the machine. If you've got IIS
running on your computer, you could try surfing to that ip address.

 

[Darren Beckley]

If it works using a hostname without dots, but doesn't work with dotted
address, I would guess it's a Connection Manager configuration issue.
Connection Manager will by default assume any address with dots in is on
"The Internet". Try changing "Programs that automatically connect to the
Internet should connect using:" to be "My Work Network" i.e. both Internet
and private networks use "My Work Network" settings. You'll find this under
Start -> Settings -> Connections -> Connections -> Advanced -> Select
Networks. Alternatively, you could add an exception for 192.168.* or
similar - see Exceptions button in same place as Select Networks.

Hope that helps,
Darren

 

[Bryan]

Thanks Darren,
Unfortunately I have it set up like that already, it does not work...

 

[Bryan]

Yes, that works. I can get to that IP address with the pocket IE.

 

[Ginny Caughey [MVP]]

Bryan,

Can you connect to that server from the desktop using the IP address?

 

[Bryan]

Still unresolved, Shall I contact support from MS with this issue?

Bryan