SQLServer access from CompactFramework

[neodatatype]

Hi all,

 

I wonder if I can do a connection to an SQL server DB from my PocketPC using the Compact Framework.

 

Someone can tell me if it is possible and how?

 

I tryed to compile a simple app from a dos-shell (csc.exe) but if I use the /nostdlib option, it cannot find the SqlClient namespace :(

 

 

i.e.:

%WINDIR%\microsoft.net\framework\v1.1.4322\csc.exe /t:exe /noconfig /nostdlib /r:%palm_sdk%\mscorlib.dll /r:%palm_sdk%\system.dll /r:%palm_sdk%\system.data.dll /r:%palm_sdk%\system.data.common.dll /r:%palm_sdk%\system.data.sqlclient.dll /r:%palm_sdk%\system.xml.dll /r:%palm_sdk%\system.drawing.dll /r:%palm_sdk%\system.windows.forms.dll /out:%palm_out% *.cs

 

why?

[angula]

Check out this excellent article.

 

http://www.ftponline.com/vsm/2003_10/magazine/features/thews/

[davesil2]

not quite what I was looking for

 

I don't see how that link helps me. There wasn't any code really and the information was about windows CE sql server and storing a database on that.

 

I am looking to be able to save files (ie. command.com) into a database (SQL server or MS Access) and be able to retrieve from that same database.

 

In MS Access you create and unbound OLE object in the form view, if your in the database you can right click and go to insert and insert a package file.

 

I'm looking for the code in VB .Net to be able to do the same thing you can do in Access (code for SQL server would be good as well, but either one).

[robplatt]

I'm new to .net, and I was able to whip up a sql app in no time. My device connects to my sql 2000 server at work and pulls data in usin SqlClient.

 

open your project and reference the SqlClient component.