Sqlce installation Configuration

Installation and configuration of sqlce + PDA + SQL2000

In practice over the past few days, it is really necessary to write something out and record your own experience, so that you will not be able to forget the issues of classes in the future. First, let's talk about sqlce, it is a database service program running on PDA, currently I use it mainly through PDA and MS-SQL2000 for data publishing and subscription.
Installation configuration file:
1. SQL Server 2000 SP1: SQL2KRSSP1-CHS.EXE (download from Microsoft's website)
2. IIS and sqlce Connection Manager: sqlce20sql2ksp3a.exe (downloaded from Microsoft website)
First install: 1, then install 2,

There is basically no major problem during installation of 1. During installation of 2, note that you need to set up the directory where sscesaw.dll is located and use configure connectivity support in IIS manager, create a virtual directory. If it is in NTFS format, you must set the NTFS promissions item. Otherwise, a call to sqlserver repl will appear during synchronization... I didn't set it before, so I got it for two days. This problem always occurs and my head is big! After setting it, enter the following in the IE address bar:Http: // localhost/Virtual directory/sscesaw.dll/

If the SQL ce... and other words are displayed on the page, it indicates that the configuration has been completed! The next thing is how to create a publishing and subscription. You have time to write it again!

 

My current configuration is Windows XP sp2,sqlserver200020.sp4,sqlce20sql2ksp4.exe

(1) sqlserver2000 SP4 is easy to install. After decompression, run Setup. dat directly.

Ensure IIS Installation

(2 after installation sqlce20sql2sp4.exe

I. Follow the prompts to install
Ii. Go to the SQL Server ce virtual directory creation wizard Interface
Iii. Enter the name "sscepubs" for virtual directory (you can name it yourself)
Iv. Select "Anonymous Access"
V. Next step, no selection
Vi. Installation Complete
(3) Modify SQL Server 2000
Go to the Enterprise Manager of SQL Server, select security in the running sever, create a new login, add the user iuser _ computer name (Internet Guest Account), and go to the database

Select the database to be accessed, add the role "db_owner", and click "OK" to complete permission settings.
(4) test whether the installation is successful
Enter http: // server IP Address/sscepubs/sscesaw.dll in IE. If the connection is successful and "SQL Server ce agent" appears"

You can use sqlceremotedataaccess to synchronize data.
Pull extracts data from the SQL Server database and stores it in the table of the SQL Server ce database.
// Connection string to the SQL server.
String rdaoledbconnectstring = "provider = sqloledb; Data Source = mysqlserver; initial catalog = northwind;" +
"User ID = username; Password = <password> ";

// Initialize RDA object.
Sqlceremotedataaccess RDA = NULL;

Try {
// Try the pull operation.
RDA = new sqlceremotedataaccess ();

RDA. internetlogin = "mylogin ";
RDA. internetpassword = "<password> ";
RDA. interneturl = "http: // server IP Address/sscepubs/sscesaw.dll ";
RDA. localconnectionstring = @ "provider = Microsoft. sqlserver. oledb. ce.2.0; Data Source =/SSCE. SDF ";

RDA. Pull (
"Employees ",
"Select * from employees ",
Rdaoledbconnectstring,
Rdatrackoption. trackingonwithindexes,
"Errortable ");
}
Catch (sqlceexception ){
// Use you own error handling routine.
}
Finally {
// Dispose of the RDA object.
RDA. Dispose ();
}

Push transfers the changes in the extraction table tracked in the SQL Server ce database back to the SQL Server table.
String rdaoledbconnectstring = "provider = sqloledb; Data Source = mysqlserver; initial catalog = northwind;" +
"User ID = username; Password = <password> ";

// Initialize RDA object.
Sqlceremotedataaccess RDA = NULL;

Try {
// Try the pull operation.
RDA = new sqlceremotedataaccess ();

RDA. internetlogin = "mylogin ";
RDA. internetpassword = "<password> ";
RDA. interneturl = "http: // server IP Address/sscepubs/sscesaw.dll ";
RDA. localconnectionstring = @ "provider = Microsoft. sqlserver. oledb. ce.2.0; Data Source =/SSCE. SDF ";

RDA. Push ("mylocaltable ",
Rdaoledbconnectstring,
Rdabatchoption. batchingon );
}
Catch (sqlceexception ){
// Use you own error handling routine.
}
Finally {
// Dispose of the RDA object.
RDA. Dispose ();
}

 

Install. Net CF and SQL ce Components

Netcf. Core. ppc3.arm. Cab system_sr_chs.cab sqlce. ppc3.arm. Cab sqlce. Dev. ppc3.arm. Cab SQL. ppc3.arm. Cab