Page 1 of 1
connecting to sql 2005ce
Posted: Sat 21 Feb 2009 09:01
by dartas
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
Posted: Sat 21 Feb 2009 20:50
by hmelihkara
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
Posted: Mon 23 Feb 2009 07:45
by dartas
all ok. thanks hmelihkara for the help