I've been trying to figure this problem out for days now and I just can't seem to figure it out. So if anyone can help, that would be awesome!
So this is simply how I'd like things to be:
All I want to do is connect to an sql server 200 database from a pocket pc. I'm using C# to develop the client side. I'm using SQL Server 2000 sp3a on the server side. And I'm using SQL Server 2000 CE 2.0 sp3a to interact between the two. And I'm using IIS 6.0 to communicate over the internet.
This is what's going on:
I've gone through every tutorial, how to and step by step to correctly setup sql server 2000 and the publication. I've also done the same for double checking the user permissions for the database. At this point, I've basically given everyone full control over everything. I've create a virtual directory for SQLCE and gave full control over that. I've registered both the sscerp20.dll and the sscesa20.dll's. I've created a virtual directory in iis that points to the same directory as sqlce. I've added the IUSR_PCname access to everything everywhere. But no matter what I do, I can't get it to work. I'm able to view and browse and read my virtual directory from the handheld, but I can't get it to work from my own application. I've un-installed and reinstalled everything at least 10 times and did them in different sequence. I cannot figure this out. SQL server 2000, IIS, and SQLCE are all installed on one server, windows server 2003 and I'm developing the client side on another pc, running windows xp. I've checked the Event Viewer and it's saying that my user is sucessfully logging on....but my app is still giving me that error, no matter what. Sorry for such a messy description....but my brain is mush right now. :(
Here are the references that I've used so far with no success:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/sql_serverce_replication_net.asp (I'm using this as a template to configure sql server 2000, the virtual directories, publications, user permissions...I basically stop at the user interface because that's using vb.net and I'd like to use c#)
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcemergereplication.aspx (I'm using this to develop my client side c# code to connect to the database)
http://www.databasejournal.com/features/mssql/article.php/1438231 (I've been using this to supliment the other resources)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/fieldservice_sp.asp (This is the sample app that sparked my interest in doing this)
http://www.dotnet247.com/247reference/msgs/35/177619.aspx (these are some things that other people with my similar problem did to solve it....but not me)
http://www.dbforums.com/showthread.php?t=926219&page=1&pp=15 (this one as well, didn't solve my problem)
Please help! I will try anything to get this to work correctly!
View the Solution FREE for 7 Days
