Showing posts with label sqlconnection. Show all posts
Showing posts with label sqlconnection. Show all posts

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.

Sunday, February 12, 2012

connect to sqlserver by sqlconnection from windows CE 5.0

Currently I cannot connect to a database, I got the system.exception “PlatformNotSupportedExcoption”. This database is Polish (COLLATE Polish_CI_AS), when I collate this database to latin general it works fine. I connect by using the system.data.sqlclient.sqlconnection, as far as I can see I cannot set the locale identifier here… What can I do?

Thanks for your help!

regards, Jan

You'd need a device with Polish locale support or you would need to change database collation.

|||

thx.

Is it possible to update only the localized sqlce components at the device?

Thanks!