connection to a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

how can I connect a wince mobile computer to a database loacted on a
computer running under winxp using the wifi network.
 
Christian,

Since you didn't say what the database on the WinXP computer is, the most
general answer is to use either Web Services or TCP/IP. If the database is
SQL Server, you have merge replication and RDA as options as well assuming
you're storing the data on the mobile device in a SQL CE or SQL Mobile
database.

Ginny Caughey
..NET Compact Framework MVP
 
Christain,

I should also mention that SqlClient is also an option if your desktop
computer is running SQL Server.

Ginny
 
Hello,

I have to create an application on a windows CE mobile computer, this
application has to connect to a SqlServer 2000 database located on a windows
XP desktop.
How can I do that ?

I'have tried using the System.Data.SqlClient.dll from the .NET compact
framework
My ConnectionString is "user id=sa;data source=FGUL506907WXP;persist
security info=True;initial catalog=IDPS;password=xxx"

but when I try to connect with the option doing

mConnection.Open();

A PlateformNotSupportedException is caught

I don't find answers to correct this problem.
Visual .Net is well configured to create the mobile application.

Christian
 
Of course some informations are missing.

In fact I try to connect a windows CE 4.2 mobile computer to a SqlServer
2000 database located on a windows XP pro desktop.
I tried it creating an apllication using the System.Data.SqlClient.dll file.
The connectionString i use is "user id=sa;data source=FGUL506907WXP;persist
security info=True;initial catalog=IDPS;password=xxx"

the problem is when I use the Open command, a PlateformNotSupportedException
is caught

Visual Studio is well configured to create a mobile application because
without using the database, all applications work well.

I don't know where is the problem and what I can do to correct this
 
i am student devbeloping a pocket pc project. When deploying it gives me error this error after it has loaded a number of namespaces

Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%\mmts\system.windows.forms.dll'. Error 0x80070070: There is not enough space on the disk.
Device Connectivity Component


From http://www.developmentnow.com/g/18_2005_8_0_0_570988/connection-to-a-database.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com
 
I'm not sure what platform (ce, mobile, or ppc) you're working on, but
the deployment process is trying to copy some files to the "Storage"
portion of your memory.

The error is telling you that there is not enough storage memory
available to hold the files it wants to copy. You are either out of
memory, or more likely, you need to allocate more memory away from
"Program" memory to "Storage" memory.

On ce, this is done using the "System" applet in the control panel.
Select the memory tab and move the slider so that there is more
storage memory.

Good luck.
 
ray,

It sounds like you may have a reference to one or more desktop dlls rather
than the compact framework ones that you intend.
 
Back
Top