connecting to sql 2005ce

dartas · 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 · 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 · Post by **dartas** » Mon 23 Feb 2009 07:45

all ok. thanks hmelihkara for the help