Hi All,

I was wondering if it is physically possible to have an SQL Server CE 2.0 [or 3.0] connect to SQL Server 2005 Express Edition via RDA. And if it is, is this an officially supported scenario by Microsoft? I haven't been able to find any official info on this issue. Is this documented somewhere on some MS pages? Regarding synchronization I could only find out that Merge Replication works with SQL Server 2005 Express Edition with it being only a subscriber but I found nothing about Remote Data Access synchronization with a SQL Server CE 2.0 or 3.0

Thanks,

Marius

Hi,

I noticed that a lot of people are saying that RDA does not work with SQL Express, yet it looks like it is working. I am just not sure if this is a supported Microsoft scenario. I wasn't able to find any official documentation stating that RDA is or is not possible with SQL Server 2005 Express Edition. If you have any references about this issue please let me know.

Thanks a lot!

Eddy,

I am not connecting SQL Mobile to SQL Express. Rather, I am connecting SQL Server CE 2.0 to SQL 2005 Express. Specifically, I use RDA synchronization [Push/Pull/SubmitSQL.] I would be interested to find out if you have problems w/ SQL Mobile connecting to SQL 2005 Express via RDA.

Note that I am not doing anything special to get these two to work (other than installing the SQL 2000 connectivity tools instead of SQL 2005 ones on the server side)

Marius

RDA and Merge Replication with SQL Server 2005 Express Edition are not *supported* by Microsoft,

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation