CE .NET Direct Sql Server Connection

  • Thread starter Thread starter Hakan Gumus
  • Start date Start date
H

Hakan Gumus

Hi;

Is it POSSIBLE connect directly to Sql Server via CE .NET using
"System.Data.SqlClient".

I've managed to connect directly to Sql Server via Pocket Pc 2002 but
not couldnt
from CE .NET. It returns me PlatformNotSupportedException.

Below i've put the sample

Imports System.Data.SqlClient

Dim sqlConn As New SqlConnection
sqlConn = New SqlConnection("Integrated
Security=SSPI;Server=HGUMUS;Database=TestDB")
sqlConn.Open
sqlConn.Close
 
Hi Hakan,

What verision of WindowsCE.NET are you using ? 4.0, 4.1 or 4.2? 4.1 or
4.2 is required.

Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: (e-mail address removed) (Hakan Gumus)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: CE .NET Direct Sql Server Connection
Date: 6 Aug 2003 01:05:07 -0700
Organization: http://groups.google.com/
Lines: 18
Message-ID: <[email protected]>
NNTP-Posting-Host: 213.161.149.99
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060157108 31047 127.0.0.1 (6 Aug 2003 08:05:08
GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: 6 Aug 2003 08:05:08 GMT
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-
xit-05!sn-xit-09!supernews.com!postnews1.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:30255
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Hi;

Is it POSSIBLE connect directly to Sql Server via CE .NET using
"System.Data.SqlClient".

I've managed to connect directly to Sql Server via Pocket Pc 2002 but
not couldnt
from CE .NET. It returns me PlatformNotSupportedException.

Below i've put the sample

Imports System.Data.SqlClient

Dim sqlConn As New SqlConnection
sqlConn = New SqlConnection("Integrated
Security=SSPI;Server=HGUMUS;Database=TestDB")
sqlConn.Open
sqlConn.Close
 
Hi Kevin;

Thanks for your reply.
I'm using CE .NET 4.1.

Fortunately we solved the problem which was
caused by our database's Collation Name.

I've changed from
"SQL_Latin1_General_CP1254_CI_AI"

to

"Latin1_General_CI_AI"

and the problem is solved.

I think CE .NET does not support Turkish yet.
 
Hakan,

You are correct. Its a matter of choosing a code-page or collation which
is supported on the device.


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
From: (e-mail address removed) (Hakan Gumus)
Newsgroups: microsoft.public.dotnet.framework.compactframework
Subject: Re: CE .NET Direct Sql Server Connection
Date: 27 Aug 2003 07:24:37 -0700
Organization: http://groups.google.com/
Lines: 18
Message-ID: <[email protected]>
References: <[email protected]>
<[email protected]>
NNTP-Posting-Host: 213.161.149.55
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1061994278 23805 127.0.0.1 (27 Aug 2003
14:24:38 GMT)
X-Complaints-To: (e-mail address removed)
NNTP-Posting-Date: 27 Aug 2003 14:24:38 GMT
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-
xit-09!supernews.com!postnews1.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:32165
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Hi Kevin;

Thanks for your reply.
I'm using CE .NET 4.1.

Fortunately we solved the problem which was
caused by our database's Collation Name.

I've changed from
"SQL_Latin1_General_CP1254_CI_AI"

to

"Latin1_General_CI_AI"

and the problem is solved.

I think CE .NET does not support Turkish yet.
 
Back
Top