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
No comments:
Post a Comment