Monday, 19 March 2012

Connect Sql server Mobile with VS2005

I have a default SQL server 2005 setup on my machine.

There is a large database to whom i can connect.

I made my own data by Sql server Mobile on my local machine and then try to connect it

to the the application in visual studio 2005.

But it each time it gives that the port cannot be open.

I am a native client for SQL server.

Do we have any idea how wil i connect to database local to machine with the

application in Visual studio 2005 with C# language.

thanks

Prashant Gupta

The actual message i am getting

Microsoft SQL Native Client Version 09.00.2047

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

TESTS FAILED!

Sorry, but your question is off topic here, since this is the forum with smart device development. Move to Sql Server 2005 forum.

Hint: it seems like the connection string is not correct.

Thanks!

|||Please post your connection string. Make sure that you enabled remote connections (see the screencast on my site for more information how to do this)

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Do you need more help, or did you solve the problem ?
Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment