Connect to named istance from compact framework

Question

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 29-Sep-14 22:53pm

N. Altamura

Updated 30-Sep-14 0:21am

Kornfeld Eliyahu Peter

v4

Add a Solution

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, ...)?

N. Altamura 30-Sep-14 6:26am

Yes, I set default port 1433 in configuration

Kornfeld Eliyahu Peter 30-Sep-14 6:28am

Can you see the property page of the instance and check if remote connections are enabled?

N. Altamura 30-Sep-14 6:39am

Kornfeld Eliyahu Peter,

as I wrote in the question, I write a console application, and use the same connection string to read data from database.

I do this test from another PC. So the remote connection is absolutely enabled!

Sinisa Hajnal 30-Sep-14 6:42am

Try explicitly setting port in the connection string...
I used MC9090 and MC9190 extensively over last 4 years and the only trouble I ever had is occasional DNS trouble. Try using IP address instead of server name. If it helps and the device connects, go to your DNS master and ask him to resolve this for you :)

N. Altamura 30-Sep-14 7:05am

Have already used named istance?
I use IP adress of database server to avoid specific dns problem ...
But the application not work!

Sinisa Hajnal 30-Sep-14 7:54am

Yes, I used specific instance(s) and never had any trouble with them?! I'm sorry, I have no idea what could be the problem - I never had any with instance names only with DNS and ports. And I used: Win 5.0, WinCE and Win 6.5 versions of the devices OS (and Psion, Datalogic both old and new, Intermec and several others besides Motorola)

N. Altamura 30-Sep-14 8:12am

Would you post a sample of connection string for specific istance so I could confront with mine?

Sinisa Hajnal 30-Sep-14 8:35am

I'm on different work place since 5 weeks ago. So no, I cannot. Let me get back to you tomorrow, I'll check at home if I have some backup somewhere.

N. Altamura 30-Sep-14 8:40am

OK, thanks!

Kornfeld Eliyahu Peter 30-Sep-14 7:54am

You may have to add "Integrated Security = SSPI" to your connection string...

N. Altamura 30-Sep-14 8:56am

Good idea, but application don't work!

connectionString = "Data Source=192.1.2.3\IstanceName;Initial Catalog=DbName;Integrated Security=SSPI;User ID=Domain\User;Password=Pass;"

Sinisa Hajnal 1-Oct-14 2:37am

I've looked up my connection strings and found nothing definitely wrong with your string so I googled.
Several things:
1. port is a MUST for named instance - and it has to be fixes on the server, not dynamic - I never paid attention to this, but I remember googling this and setting up each server in 2010 :)
2. Try double slashes database \\ instance - I didn't use this
3. Try adding space " " right after your domain name - the same
4. Use IntegratedSecurity - I did use this on each and every connectino string since connecting to named instance is through named pipe, you HAVE to have User ID=myDomain\myUsername;Password=myPassword - check bolded link below

I admit I didn't read deeply into any of this - but look for further clues:
http://sampath.wordpress.com/2007/03/20/connecting-to-sql-server-express-from-a-pocket-pc-application/

From MS forums: try adding space before your instance name (you know, one empty char, not literal word space :p)
found a solution - just one space:
connectionString = “Server=1.1.1.1{space}\MS2005;Database=DB1;...

http://www.connectionstrings.com/sql-server-2005/

Could you post your connection string not as listing of separate parameters, but as you have it written (replace sensitive info of course)

N. Altamura 1-Oct-14 3:13am

Hallo Sinisa,
thanks for your kind answer!

I googled for this problem too and founded the same tips.
Today I try this tips in a more comprehensive manner and hope to find a solution.

I'll let you know if some particular tip is the right tips

By
N.

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

Connect to named istance from compact framework

Add your solution here

Preview 0

Connect to named istance from compact framework

Add your solution here

Preview 0

Existing Members

...or Join us