Microsoft® Windows® CE 4.1 (CE .NET)

  • Thread starter Thread starter mehmet demiröz
  • Start date Start date
M

mehmet demiröz

Help me?

Microsoft Visual Basic.NET 2003
SQLServer 2000

Windows Ce.Net 4.1 Emulator or Microsoft Windows CE.NET or
Ýþlemci: Intel® XscaleTM PXA250
Endüstriyel Dayanýklýlýk: 1.2 metreden betona düþmeye dayanýklý
Ýþletim sistemi: Microsoft® Windows® CE 4.1 (CE .NET)
Hafýza: 32MB RAM/ 32MB ROM
Version 4.10(Build 908)



Me.ZConnection = New System.Data.SqlClient.SqlConnection

Me.ZConnection.ConnectionString = “Server=192.168.10.5;password=;user
id=sa;initial catalog=Northwind;”
Try
Me.ZConnection.Open()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Ex.Message(Windows CE.NET SqlClient PlatformNotSupportedException)
 
That would be correct.

You need to use SqlCeConnection and SqlCe objects in
general.


-----Original Message-----
Help me?

Microsoft Visual Basic.NET 2003
SQLServer 2000

Windows Ce.Net 4.1 Emulator or Microsoft Windows CE.NET or
Ýþlemci: Intel® XscaleTM PXA250
Endüstriyel Dayanýklýlýk: 1.2 metreden betona düþmeye dayanýklý
Ýþletim sistemi: Microsoft® Windows® CE 4.1 (CE .NET)
Hafýza: 32MB RAM/ 32MB ROM
Version 4.10(Build 908)



Me.ZConnection = New System.Data.SqlClient.SqlConnection

Me.ZConnection.ConnectionString
Click to expand...
= "Server=192.168.10.5;password=;user
 
and in english ? ;-)

That would be correct.

You need to use SqlCeConnection and SqlCe objects in
general.


-----Original Message-----
Help me?

Microsoft Visual Basic.NET 2003
SQLServer 2000

Windows Ce.Net 4.1 Emulator or Microsoft Windows CE.NET or
Ýþlemci: Intel® XscaleTM PXA250
Endüstriyel Dayanýklýlýk: 1.2 metreden betona düþmeye dayanýklý
Ýþletim sistemi: Microsoft® Windows® CE 4.1 (CE .NET)
Hafýza: 32MB RAM/ 32MB ROM
Version 4.10(Build 908)



Me.ZConnection = New System.Data.SqlClient.SqlConnection

Me.ZConnection.ConnectionString
Click to expand...
= "Server=192.168.10.5;password=;user
 
I really have the same problem and I cannot find the solution. It seems that
the connection string to an EXTERNAL (MC?) SQL Sever (MSDE, 2000, 7, etc) is
failing.
And I think Mehmet doesn't speak English fluently (Lloyd Dupont?)... but his
problem is really clear.
What I need to test, and I think is the solution is the following
StringConnection:

Me.ZConnection.ConnectionString = "Addr=192.168.10.5;password=;user
id=sa;initial catalog=Northwind;"

Just changing Server to Addr... I read it elsewhere... but I haven't had
time to test it. Can anybody tell me if I am right?

Thanks a Lot!
Roberto
P.S: I know my English is not good too.
 
As Lloyd alluded to, you cannot use the SqlClient methods and properties in
the CF. You must use the SqlCEClient methods instead.
 
But Chris... what I think is that you have to use the SqlCEClient if you
need to connect to an SQL Server CE database (stored locally on the PDA)...
but what about if you need to connect to an SQL Server 2000 Database stored
on a Server PC?

Thanks
Roberto
 
Roberto,

You would indeed use SqlClient for connecting to a SQL Server database.
Usually when people have problems making this work it's a permissions issue.
Try putting "Integrated Security=SSPI" in the connection string.
 
Back
Top