RDA Pull from SQL Server 2005

RDA Pull from SQL Server 2005 - sscesa30.dll?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry Simpson - 23 Oct 2006 17:18 GMT

I'm developing an app in VS2005, and want to use RDA to pull from a SQL
Server 2005 database.

I find that I don't have the virtual directory for the agent set up like I
do for SQL Server CE 2.0 with the directory pointing to a physical direcory
containing sscesa20.dll.

I cannot find sscesa30.dll anywhere. I did find some sglcese30.dll and
others in C:\Program Files\Microsoft SQL Server Everywhere\v3.1 but never
found the sscesa30.dll.

What do I have to do to get this to install and work? I tried just using the
RDA code for the sscesa20.dll and it says incorrect header when I try to
execute....

Help would be great!!

TIA

Harry

Reply to this Message

Alberto Silva - 24 Oct 2006 10:31 GMT

Hi,
You have to install the SQL Server Mobile Server Tools: there are two versions,
one for SQL Server 2000 on the server, and another for SQL Server 2005.

Take a look at this entry from Alex Yakhnin's blog:

http://blog.opennetcf.org/ayakhnin/CategoryView.aspx?category=SQL%20Mobile

Alberto Silva
MS Mobile Devices MVP
http://msmvps.com/AlbertoSilva

> I'm developing an app in VS2005, and want to use RDA to pull from a
> SQL Server 2005 database.
[quoted text clipped - 16 lines]
>
> Harry

Reply to this Message

Harry Simpson - 24 Oct 2006 15:04 GMT

Thanks Alberto - I've installed both of those. I've set up a virtual
directory like i did for 2.0 called SSCE30 in IIS and have it point to the
directory containing the file sqlcesa30.dll.

I then try to navigate to this file in the browser using the
http:\\[MyServerIP]\SSCE30\sqlcesa30.dll expecting to see the familiar "SQL
Server CE Server Agent" in the browser window but instead I get a

Assembly Not Loaded error:
System.IO.FileNotFoundException : Could not load file or assembly
'sqlcesa30[1]' or one of its dependences. The system cannot find the file
specified. For further information, use the Exception Details menu item.

Any idea on what could be happening here? Or is this test of agent not
valid in SQL Server CE 3.0?

TIA

Harry

> Hi,
> You have to install the SQL Server Mobile Server Tools: there are two
[quoted text clipped - 29 lines]
>>
>> Harry

Reply to this Message

Alberto Silva - 24 Oct 2006 17:12 GMT

It seems like a .net related message, but I'm not sure if it requires .NET
1.1/2.0 to be installed on the server... do you have them installed?

Another point, does the iusr_machinename or the authenticated user have read/write
rights on that folder?

Alberto Silva
MS Mobile Devices MVP
http://msmvps.com/AlbertoSilva

> Thanks Alberto - I've installed both of those. I've set up a virtual
> directory like i did for 2.0 called SSCE30 in IIS and have it point to
[quoted text clipped - 49 lines]
>>>
>>> Harry

Reply to this Message

Harry Simpson - 24 Oct 2006 20:25 GMT

Got both 1.1 and 2 installed. iuser has read/write permissions (as set via
IIS virtual web properties).
It says it can't open assembly sqlcesa30[1] and then after I click OK it
opens up an NUnit session with the sqlcesa30.dll[1] in the header.

> It seems like a .net related message, but I'm not sure if it requires .NET
> 1.1/2.0 to be installed on the server... do you have them installed?
[quoted text clipped - 59 lines]
>>>>
>>>> Harry

Reply to this Message