Saturday, February 25, 2012

connecting sql server intalled on a persnal pc

Hi,

I'm trying to connect to sql server (installed on my personal PC) from a pocket pc using sqlconnection (Both are connected to my Router).

But every time I run my program on the pocket pc I get sqlexception when trying to open the connection.

I have already configured the sql server to accept remote connections...

1. what should I do?

2. Is it possible to open the sql server on my PC for remote connections (internet)?

3. How should I configure my Router so it wont block the connections?

1: Check this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=962226&SiteID=1 and this:

http://support.microsoft.com/kb/287932

also show us your connection string, as SqlClient from compact framework has some restrictions.

2: Yes, but it is not recommended.

3: See 1.

No comments:

Post a Comment