Emulator WINCE with SQL Server

[Guest]

Sometimes, when I try to access a SQL SERVER, the exception is fired.

"SQL SERVER DOES NOT EXIST OR ACCESS DENIED."

Anybody knows was happen?

Rogério

 

[David McNamee]

Sometimes, when I try to access a SQL SERVER, the exception is fired.

"SQL SERVER DOES NOT EXIST OR ACCESS DENIED."

Anybody knows was happen?

Not without more information.

1. Is this message received when accessing Sql Server from your app on the
device?
2. Is your connection string correct? If you're not sure, check
http://www.connectionstrings.com for help.
3. Does the account you are using have appropriate permissions on the Sql
Server?
4. Have you tried using the Sql Server's IP address instead of its host
name?

 

[Guest]

1. Is this message received when accessing Sql Server from your app on the
device?
I receive the message when my app try to connect a SQL SERVER

2. Is your connection string correct?
"Server=10.0.0.1;Initial Catalog=PDV; User ID=sa; Password=senha";

3. Does the account you are using have appropriate permissions on the Sql
Server?
Yes. Sometimes, the connect is ok.

4. Have you tried using the Sql Server's IP address instead of its host
name? Yes. IP and hostname.

 

[Sergey Bogdanov]

Can you try to ping the server? Or if 10.0.0.1 has the IIS try to browse
into it from device to make sure that you have no problems with
accessing to server. Also make sure that firewall does not restrict
access for this device.

 

[David McNamee]

4. Have you tried using the Sql Server's IP address instead of its host
name? Yes. IP and hostname.

Are you able to ping the Sql Server host from the device? You can grab a
ping utility from http://www.cam.com/

-david