Mobile Device Database Develpment Problems

Hi, Guys

I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.

The following is my development enviroment

Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2

First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.

Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.

I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.

I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.

Can someone help me out?

Thanks.

That usually means SQL Server database is setup with collation not supported on your device. E.g. you have English device and database uses Chinese collation. There are two ways to fix it:

1. Change collation of the database to whatever device supports.

2. Get device which supports collation of the database.

Another possible reason for that issues might be what some dependencies are missing in the OS image. You should contact device OEM in that case.

|||

it is working, after Change collation of the database to Latin1.....

Thanks a lot

missing hd partition

hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
backup. on backup when i do EM backup and click on the "add" device i
could view the different hard disk partitions of my server (C:, D:, E:,
F. but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F. but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!

missing hd partition

hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
backup. on backup when i do EM backup and click on the "add" device i
could view the different hard disk partitions of my server (C:, D:, E:,
F:). but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F:). but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!