Tech-Today
1.) Download the sqlce3.x installer,
http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en
or
http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en
2.) Install in your desktop computer.
3.) Navigate to where you installed the sqlce, typically you have to navigate here: C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\wce400\armv4
4.) You will notice 3 cab files, copy them all to a temporary folder in your pocket
pc using activesync.
5.) Execute (double click) each to install. To check if you have successfully installed the sqlce, in your pocket pc, a directory like this should exist: \Program Files\SQL Mobile\EN
There you go, you have successfully installed the sqlce database on pocket pc.
Note:
The above libraries are compatible with Visual Studio 2005 development.
For Compact Database that was created on code by Visual Studio 2003 you need to install the cab files stored here:
C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\armv4
sqlce.wce4.armv4 (main database engine)
sqlce.dev.wce4.armv4 (contains query analyzer, etc)
sql.wce4.armv4 (I'm not sure)
If you encounter this problem "you are trying to access an older version of sqlserver compact edition database...". It is very likely that you have created a database in Visual Studio 2003 but deployed the cab files of 2005 or vice versa so watch out.
- How To Deploy Mvc3 Powered Website To Iis
After developing a website powered by MVC3 the next thing is deploying it on server. Our assumption is that the server has dotnet3.5/4.0 installed. Server Setup: 1.) Windows 2003 SP2 2.) Download and install dotnet 3.5/4.0 3.) Download and install MVC3...
- Missing Microsoft Server Management Studio Express After Sql Server 2008 Express Installation
For some reason after I've installed the SQL Server 2008 and SP1 I'm still missing the Management Studio Express that we commonly have when we install the 2005 SQL Server Express. The solution is to download from this link: http://www.microsoft.com/express/Database/...
- Setting Mssql Server 2005 Table 2000 Compatible
Recently I was developing a c# application that uses sqlserver2005 database (express edition) setup on my laptop which has win7 os. The problem is the public server where I will deploy the application is only running a mssql server 2000 database. My application...
- Visual Studio 2008 Freeze After Installation Of Office 2010
I am curious with the new Office 2010 so I installed it to try it out. It was a successful installation no error or whatever. After a day I opened my Visual Studio 2008 and try coding, then it suddenly freezes. Looking at the tasklist, I found an unusual...
- How To Connect To Pocket Pc From Desktop Using Serial Connection (com1)
1.) Install activesync in your desktop as well as pocket pc. You can get it from here: http://www.microsoft.com/windowsmobile/en-us/downloads/microsoft/activesync-download.mspx 2.) In your pocket pc click Start->ActiveSync a.) Click Tools below then...
Tech-Today
Installing SQL Server Compact Edition 3.1 on Mobile Device (Pocket PC)
1.) Download the sqlce3.x installer,
http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en
or
http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en
2.) Install in your desktop computer.
3.) Navigate to where you installed the sqlce, typically you have to navigate here: C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\wce400\armv4
4.) You will notice 3 cab files, copy them all to a temporary folder in your pocket
pc using activesync.
5.) Execute (double click) each to install. To check if you have successfully installed the sqlce, in your pocket pc, a directory like this should exist: \Program Files\SQL Mobile\EN
There you go, you have successfully installed the sqlce database on pocket pc.
Note:
The above libraries are compatible with Visual Studio 2005 development.
For Compact Database that was created on code by Visual Studio 2003 you need to install the cab files stored here:
C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\armv4
sqlce.wce4.armv4 (main database engine)
sqlce.dev.wce4.armv4 (contains query analyzer, etc)
sql.wce4.armv4 (I'm not sure)
If you encounter this problem "you are trying to access an older version of sqlserver compact edition database...". It is very likely that you have created a database in Visual Studio 2003 but deployed the cab files of 2005 or vice versa so watch out.
- How To Deploy Mvc3 Powered Website To Iis
After developing a website powered by MVC3 the next thing is deploying it on server. Our assumption is that the server has dotnet3.5/4.0 installed. Server Setup: 1.) Windows 2003 SP2 2.) Download and install dotnet 3.5/4.0 3.) Download and install MVC3...
- Missing Microsoft Server Management Studio Express After Sql Server 2008 Express Installation
For some reason after I've installed the SQL Server 2008 and SP1 I'm still missing the Management Studio Express that we commonly have when we install the 2005 SQL Server Express. The solution is to download from this link: http://www.microsoft.com/express/Database/...
- Setting Mssql Server 2005 Table 2000 Compatible
Recently I was developing a c# application that uses sqlserver2005 database (express edition) setup on my laptop which has win7 os. The problem is the public server where I will deploy the application is only running a mssql server 2000 database. My application...
- Visual Studio 2008 Freeze After Installation Of Office 2010
I am curious with the new Office 2010 so I installed it to try it out. It was a successful installation no error or whatever. After a day I opened my Visual Studio 2008 and try coding, then it suddenly freezes. Looking at the tasklist, I found an unusual...
- How To Connect To Pocket Pc From Desktop Using Serial Connection (com1)
1.) Install activesync in your desktop as well as pocket pc. You can get it from here: http://www.microsoft.com/windowsmobile/en-us/downloads/microsoft/activesync-download.mspx 2.) In your pocket pc click Start->ActiveSync a.) Click Tools below then...