Click here to Skip to main content
15,908,455 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more: , +
Hi everyone,

As wrote in the title I got a problem accessing to a database instance on a mobile application.

Here the scenario:

The application was developed on rugged PDA, Motorola MC9090, and work as a charm.

I used visual studio 2008 for developing application with compact framework 3.5.
The database is hosted on server with MS SqlServer 2005.

The handheld is equipped with Windows Mobile 6.5, the latest version available for this type of handhelds.

The application have no problem to connect to the default istance of SQL database.

Week ago a customer asked to move the existing database to a new database server using a dedicated "named istance".

Checking this scenario in my office I get the error:

"Specified SQL server not found"

and obviously the application can't access to data.

So I test the connection between database server and pda, the pda and the server and everything work fine.

The other test I run is to perform a data access on desktop application using the same connection string.
Also this test run successfully.

For completeness this is the connection string

workstation id = 'MyPda';
packet size = 4096;
user id = sa;
Password = password;
data source = Ipadressofdbsql\Nameofistance;
persist security info = False;
initial catalog = DatabaseName

Where is the error?
Anyone experienced this scenario?

Thanks in advance for your suggestions

Greetings

Nunzio
Posted
Updated 30-Sep-14 0:21am
v4
Comments
Herman<T>.Instance 30-Sep-14 5:11am    
How is your PDA connected to the network?
N. Altamura 30-Sep-14 5:31am    
Via wifi network
Kornfeld Eliyahu Peter 30-Sep-14 6:07am    
A question: can you ping Ipadressofdbsql from your PDA?
N. Altamura 30-Sep-14 6:13am    
Yes, the ping works from pda to server and vice versa
Kornfeld Eliyahu Peter 30-Sep-14 6:20am    
When installing the named instance, did you used the default settings (port, allow remote connections, connection types, ...)?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900