Emulator WINCE with SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Rogerio Jun said:
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?
 
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.
 
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.
 
Back
Top