Why I can't connect sql server 2000 with wm5 or emulator ?
Why I can't connect sql server 2000 with wm5 or emulator ?
I used windows server 2003, sql server 2000 Enterprie SP4, visual studio 2005.
My this code can connect to sql server with win application (.net framework 2.0) but can't connect to sql server with device application (.net compact framework).
Dim strconAsNew SqlConnection("Data Source=192.168.0.3;Initial Catalog=nortwind;User ID=sa")Try strcon.Open()
Dim sqlcomAsNew SqlCommand("select * from products", strcon) Dim sAsString = sqlcom.ExecuteScalar.ToStringCatch exAs Exception MessageBox.Show(ex.Message.ToString,
"")Finally strcon.Close()
EndTryQuestion
1. How to tip for setup and config windows server 2003 and sql server 2000 can connect with device?
2. What's IP of device in running ?
[2004 byte] By [
Pickup] at [2007-12-24]
Here are few check points:
1. Make sure you can ping server from device (use ping in vxUtils – free utility).
2. Make sure your server is configured for TCP connections.
3. Make sure firewall allows requests to pass to TCP port used by server (use port scan in vxUtils).
4. Make sure you're using proper credentials. Remember there's no login procedure on device, so you have to provide login/password in connection string. You sill can use windows authentication protocol, however.
5. Make sure server port is specified in connection string unless standard is used.
6. Finally, make sure you're printing errors from error collection available in SqlException. That might have a clue at what’s wrong.
Note you need real network card, wireless or wireless. AS would only work if your server is running on the same PC as Active Sync.
Hello,
I have a similar problem. I'm developing an application that will run on a pocket pc; I'm using VS2005 with its pocket device emulator "pocket pc 2003 SE". I want to connect the pocket simulator to a sql server that runs on my PC. I'm able to connect from a remote workstation to the sql server using management studio.I'm able to develop a windows application that connect from a remote PC to the sql server. I'm also able to connect the pocket emulator to the internet using active sync.
I can also develop application for sql mobile.
But when I try to run the application for the pocket pc that has to connect to the server I get the error message:"Unable to connect to the server".
I think that the reason is that the pocket emulator hasn't a network connection with the PC (sql server).
I have read about this on some forums of a loopback interface and I created it but I am still not able to ping the emulator from the PC or to ping the PC from the emulator (I have installed a pocket ping).
Can someone help me?
Thanks.
"Data Source=serverIP,1434;Initial Catalog=yourdatabase;User ID=yourUser;Password=yourpsw;"
Use this Connectionstring, It works for me.
Julio.
