Re: SQLCE work with other databases?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Feb 27, 11:28 am, fod...@xxxxxxxxx wrote:
Hello,

I'm working on a project at work for a Logistics company. I am in the
process of developing a manifest application for a mobile scanner
(Symbol MC3000) that runs Windows CE. I have a sample application
thats using the "SqlCeRemoteDataAccess" object. and the app connects
to a SQLCE version running on a server and extracts some data from an
SQL database and then passes it back to the database (.sdf) running on
the server.

Example code:http://csharp.paste-bin.com/13122

The clients Database is actually a FoxPro database, i was wondering if
anyone has had experience or can point me in the direction of if its a
all possible to get SQLCE objects to run with a FoxPro Database on the
server.

can SQLCE connect to a ODBC connector?

P.S. if anyone is interested, this is the URL i used to develop my
application:http://www.ondotnet.com/pub/a/dotnet/2003/01/06/sqlce20.html?page=2

Kind regards,

Mike



First of all, thank you both for your replies.

Ginny with regards to your application still in production,
are you able to give me a little more detail on how this works
and more direction.

from reading your explanation I gather you have the following set up:

http://www.carousel-worldwide.com/images/Scanner_DB_Solution.JPG

Any Advice/Problems you encountered would be of great help.


Kind Regards,

Mike


.

Relevant Pages

  • Re: ODBC access
    ... > one server and use the ODBC driver located on another server? ... I forgot that you're trying to access an ODBC driver as if it ... were a database. ...
    (comp.lang.java.programmer)
  • Re: SQLCE work with other databases?
    ... I used the exact same setup as Ginny Caughey, ... SQLce I have a desktop application that works with a temp SQLce database, ... the server. ...
    (microsoft.public.sqlserver.ce)
  • SQLCE work with other databases?
    ... SQL database and then passes it back to the database running on ... the server. ... all possible to get SQLCE objects to run with a FoxPro Database on the ...
    (microsoft.public.sqlserver.ce)
  • Re: Detecting number ranges
    ... database 1 is on server 3 ... I feel like there's a much nicer way to express this in Ruby, ... Kind regards, ...
    (comp.lang.ruby)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)