ANN:Access SqlServerCE from your PC using RemoteSQLCe COM object!

  • Thread starter Thread starter Pete Vickers [eMVP]
  • Start date Start date
P

Pete Vickers [eMVP]

Hi,
we have been working on RemoteSQLCe, and are pleased to announce a COM
component for the PC, enabling it to access SqlServerCE databases directly
from the PC, acting as either a client or a server.

This will allow developers to write software to read the SqlCE database and
update ANY other database directly or through ODBC.

The functionality has been tested with VB.Net and VB6, and works well. In
brief, the methods are:-
Close_Connection, Open_Database, Compress_Database, Drop_Database,
Connect_To_Server, Create_Database, Initialise, List_Bases, List_Tables,
Listen_For_Connection, Movenext, and finally Execute (which allows any Sql
statement to be actioned
on the PPC database).

More details can be found at
http://www.gui-innovations.com/html/remotesqlce_dll.html or the help file
and PDF can be downloaded from
http://www.gui-innovations.com/download/Help_And_Pdf.zip

A demo package can be downloaded at
http://www.gui-innovations.com/html/download_remotesqlce.html which includes
sample code in both VB.Net and VB6

Thanks
 
Looks really exciting!

I have a couple of queries (apologies if this is not the right place to post
these queries)

1) Can we distribute this COM component with our applications or do we need
to make a purchase for each distribution?

2) How is the INSERT performance compared to ADO.NET Command Insert (just a
rough idea would be helpful as we are hoping to do a bulk database update
here.)

Best Regards,
Y. Sivaram
 
Hi,
yes - you can distribute it with your applications.

We use TCP/IP to talk to the PPC, and at the other end, just use standard
SQL to handle the inserts, so you are looking at the same performance (or
slightly worse) than you would get from a PPC application.

We will look at if there is any way to screw more performance out of the
database.

All I can suggest is give it a whirl, although there is a nag screen every
time the .Execute process is called in the eval version. Try timing our
'Select' performance against the 'select' performance of a PPC app, that
should give you some sort of guide

Thanks

Pete


--
Pete Vickers
Microsoft Windows Embedded MVP
HP Business Partner
http://www.gui-innovations.com
 
Hi Pete,

This sounds really useful. I'm going to take a look (just as soon as my
head clears the surface of the water).

Dick

--
Richard Grier (Microsoft Visual Basic MVP)

See www.hardandsoftware.net for contact information.

Author of Visual Basic Programmer's Guide to Serial Communications, 3rd
Edition ISBN 1-890422-27-4 (391 pages) published February 2002.
 
Back
Top