connecting to sql 2005ce

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dartas
Posts: 18
Joined: Mon 12 Jan 2009 14:40

connecting to sql 2005ce

Post by dartas » Sat 21 Feb 2009 09:01

when i try connect to sql 2005 ce database error occuring:
"Required provider is not installed"

d2009 upd2
mssql2005 sp1
sdac 4.70.0.44trial

hmelihkara
Posts: 21
Joined: Fri 09 Nov 2007 23:29

Post by hmelihkara » Sat 21 Feb 2009 20:50

you can not connect to a windows CE database server with normal providers. You must use Sql Server Compact edition's providers.
Or simply what do you want to do?

1- Connect to a Mobile Database (like PDA, smartphone) from Windows x32/x64 machine?
2- Connect to a Mobile Database (like PDA, smartphone) from PDA itself?
3- Connect to a windows x32/x64 machine's Database from PDA?

-----------------------

1- You need Sql Server Compact Drivers (SQL Server Compact 3.5, its free of charge).
2- You need at least compact drivers and lazarus like ide environment.
3- Not directly possible for now :) but can be made by transferring data over tcp/ip or xml files ;)

dartas
Posts: 18
Joined: Mon 12 Jan 2009 14:40

Post by dartas » Mon 23 Feb 2009 07:45

all ok. thanks hmelihkara for the help ;)

Post Reply