Requirements for Sql Server Mobile and Sql Server 2003 interaction

Folks,

I am trying to use .NET 2005 Beta 2 to write an application targeted to a PPC2003 device. I want to use RDA to Push and Pull data from a Sql Server 2003 database.

This communication fails because I do not have sscesa30.dll in the IIS virtual directory from which the data are pulled.

I would like to know exactly what I need to install on the server so that everything is wired up correctly.

I do not really want to install Sql Server 2005 (CPT) on my server. Is there an SDK that I can install there that makes the sscesa30.dll available? Can it be run without any Sql Server 2005 (CPT) requirements?

Thanks in advance.
-Joel Finkel
finkel@.sd-il.comHi,

I am really not aware of SQL Server 2003. SQL Mobile 3.0 works with both SQL Server 2000 and SQL Server 2005.

I believe that you are working with SQL Server 2000? If so read below!

Given that SQL Mobile 3.0 works with SQL Server 2000. That is you can have SQL Server old version but have the SQL Mobile/CE clients with latest version.

This is what is expected infrastructure:

1) Server Box - SQL Server 2000 SP3a or above
2) IIS Box - Install I1, I2 in order.
3) Device - SQL Mobile 3.0 (Can get from Visual Studio 2005)

I1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=09545A2A-3D2A-4811-AFD5-41AF0F6DF2B3&displaylang=en
I2 - http://www.microsoft.com/downloads/details.aspx?familyid=0A6174A4-C009-4768-8284-698C32EC84E3&displaylang=en

Also, please note that IIS & SQL Server can be on one box. In which case only install I2 on SQL Server Box. You do not need to install I1.

Let me know if you need any more information.

Thanks,
Laxmi NRO, MSFT, SQL Mobile

|||

Thanks for your help, but I have run into issues.

Here is my setup:

IIS 6
Sql Server 2000 (SP4)
Windows 2003 Server

Referring to your note, you write:

"Also, please note that IIS & SQL Server can be on one box.
In which case only install I2 on SQL Server Box. You do not
need to install I1."

Howevever:

When I attempt to install I2, it fails because I have not yet installed I1.

When I attempt to install I1, it fails because I am not running
Sql Server 2000 SP3 or SP3a. I am runnning SP4.

This has now become a critical issue. Any help is greatly appreciated.

|||I2 in the above thread is a beta one by which time SP4 was not shipped.
I2 latest version that works with SP4 is shipped with VS 2005.

The web downloads will be updated with the latest version soon.

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation