GaryHoff
asked on
How to add areference to SQLClient for Smart Device CE 5.0
How do I add areference to SQLClient for Smart Device CE 5.0?
Just adding using System.Data.SQLClient to my code doesn't work.
I must need to reference and or install an assembly. I've searched for a solution, but haven't found clear steps to do this.
Just adding using System.Data.SQLClient to my code doesn't work.
I must need to reference and or install an assembly. I've searched for a solution, but haven't found clear steps to do this.
add System.Data.SqlServerCe
ASKER
System.Data.SqlServerCe is not a valid namespace either. There are no options in the pulldown when I enter System.Data. it's like there are no namespaces or classes under Data. Clearly, there must be an assembly reference or something I must install. I'll want to access SQL Server 2003 running on a server from the smart device running CE 5.0.
ASKER
I figured it out. I had to add the reference manually. First search for the file System.Data.SqlClient.dll. I found it in "C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin
\Client\v2.0". Go to the project solution explorer--> references --> right click --> Add Refrences, browse and navigate to that file and select it.
\Client\v2.0". Go to the project solution explorer--> references --> right click --> Add Refrences, browse and navigate to that file and select it.
this question might be argued as if post #22862080 does mention "add" :)
ASKER
Add from where? I knew I needed to add a reference. The key is from where.
SqlServerCe is for Compact SQL, I appreciate the effort, but the reply did not help me.
SqlServerCe is for Compact SQL, I appreciate the effort, but the reply did not help me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
True, If I would of added that it didn't show up in the reference assembly list that would of helped, but I didn't even know that at the time I did the post. SqlServerCe didn't show up either. Seems odd that those options wouldn't be there by default. I had go go through about 30 google searches before I put enough info together to figure it out. I'll give you the points anyway, it did give me something else to search on.