Cannot connect to server (SqlException) from Pocket PC [modified]
-
I'm trying to connect my pocket pc 2003 emulator to my loopback adapter, which is a virtual network, however I always get an SqlException error or sometimes a "Cannot connect to server or server does not exist." I don't know what I'm doing wrong, but I was able to get it working on the first PC. Now that I'm trying to do it again. It doesn't work. Here are the following configurations I've made already: - Installed Virtual PC 2007 - Installed Microsoft Loopback Adapter - Configured TCP/IP settings in SQL Server Configuration + Enabled IP1 + Set dynamic ports and tcp ports of IP1 to blank + IP1 has a default IP address of 127.0.0.1 (which I think is for the loopback stuff) + Set IPAll TCP port to 1433 and left dynamic port to blank x In the previous laptop that I configured, I had an IP2 which I placed another IP address. I can't remember if I placed my PC's IP there or the IP address I used for the TCP/IP properties of my loopback adapter which is 192.168.0.1. (I don't know why I don't have IP2 in this current laptop) And a subnet mask of 255.255.255.0 as indicated on all instructions from MS and the net. + I've also tried changing the .0.1 to other numbers up to 255. I haven't tried them all though but I tried a couple of those and it still didn't work. x Restarted the service. - Allowed corresponding permissions in the database like Connect,Update,Select,etc. - Configured Emulator properties and set the NE2000 PCMCIA to Microsoft Loopback Adapter - Turned off the firewall - Allowed my database to login in Windows Authentication and SQL Authentication mode. + I only get it working, when I cradle it with ActiveSync 4.5 + I've repeatedly installed and uninstalled the loopback adapter but still with the same result. :( + I've also downloaded and installed Virtual PC 2007 SP1. An update for the previous VPC 2007 for Windows XP SP3s. Still, I tried and it still gets the error. Sigh... Here's the screenshot of the error I'm getting: http://img365.imageshack.us/my.php?image=sqlexceptionhf5.jpg By the way, here is my connection string in my code:
"@Data Source=ralph,1433;Integrated Security=true;Initial Catalog=MMDAserver;User ID=dummy;Password=12;"+ I've also tried using the laptop's IP address than using the computer name as aforementioned, but it still gets the error. Does anyone know how I can deal wi
