connecting to remote sql database

[Russ Green]

i'm trying to build an app to connect to a remote sql database from my
windows mobile device and VB.NET (CF3.5) in VS2008 Pro. Trouble is I can't
import System.Data.Sql or System.Data.SqlClient. Am I supposed to be able
to?

Russ

 

[Chris Tacke, eMVP]

Yes, System.Data.SqlClient is what you should use and it should work.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://community.OpenNETCF.com

 

[Russ Green]

hmm..my app is referencing CF3.5 system.data but I cannot import
system.data.sqlclient or syste.data.sql.....any ideas how I can fix this?
I've tried repairing the .NET CF installation.

 

[Alberto Silva - Microsoft MVP - Device Application]

You are trying do import, but have you added the reference to the project?

--

Alberto Silva
www.moving2u.pt - R&D Manager
http://msmvps.com/AlbertoSilva - Blog
Microsoft MVP - Device Application Development

 

[Russ Green]

Yeah. I have my DAL for my main desktop app as a DLL, in my desktop DAL my
project references System.Data and I can import System.Data.SQLClient and
System.Data.SQL......trying exactly the same on my mobile app.....referenced
the CF3.5 version of System.Data but can only import System.Data.

I've noticed there is a system.data,sqlclient.dll installed with MS SQL
Server Compact Edition. I'm going to try that but it's not what I was
expecting.