newbie sql

[Erwin]

Hi,

I've got a newbie question:

i've got a device running with a WINCE.NET platform including the
webserver functionality.
Is it possible to access/create a localy SQL DataBase from an ASP page
running on that webserver?

and if it is, how? (code example)

i hope you can help me

thanks erwin
..

[Ken Schaefer]

Do you have SQL Server CE? Then you can use ADOCE to access the SQL Server
database from your ASP page running on the CE device.

Cheers
Ken

"Erwin" <erwin.zwart@pts.nl> wrote in message
news:a06a5c16.0307282231.6e9885bf@posting.google.c om...
: Hi,
:
: I've got a newbie question:
:
: i've got a device running with a WINCE.NET platform including the
: webserver functionality.
: Is it possible to access/create a localy SQL DataBase from an ASP page
: running on that webserver?
:
: and if it is, how? (code example)
:
: i hope you can help me
:
: thanks erwin
: .

[Ken Schaefer]

I can't help you with the CE Framework stuff - I don't know enough about it.

With the ADOCE stuff, you need to install that manually (there are
instruction as part of the SQL Server CE 1.1 setup)

Cheers
Ken

"Erwin Zwart" <erwin.zwart@pts.nl> wrote in message
news:eVBIzkbVDHA.1512@TK2MSFTNGP11.phx.gbl...
: Thanks for your reply,
:
: To be honest i don't realy now,
:
: I was able to create a SQL Database programmaticly in C# with:
:
: -----
: SqlCeEngine engine = new SqlCeEngine("Data Source = \\Hard
: Disk\\test.sdf");
: engine.CreateDatabase();
: SqlCeConnection ssceconn = new ...
: etc
: -----
:
: I also tried the following in my ASP Page:
: Set myDB CreateObject("ADOCE.Connection.3.1") but that failed with:
: Can't create object. So i gues it is not there?
:
: When i look into te registry i can see object referring to SSCE
: (SqlServerCE?) but nothing about ADO?
:
: i hope you can help me
:
: thanks Erwin
:
:
: *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
: Don't just participate in USENET...get rewarded for it!