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