I've some questions regarding sql modile 5.
I used to built applications using Embedded visual basic 3 and sqlce v1 5 years ago. Now I want to move to sql mobile and built applications that run on Ipaq 6515 (windows mobile 2003) and Ipaq 2790 (Windows ce5).
I installed the new sql mobile server on my laptop. When running the
http://mycomputer/sqlce3/sqlcesa30.dll everything seems to work.
1. I'm testing with the Visual Studio 2005 with the Pocket PC 20003 emulator. I create a local database by using code. When running the emulator is this database created local in my laptop and where
2. When trying to pull data from the MSSQL 2000 I get the error : A request to send data to the computer running IIS has failed. For more information, see HRESULT. Why this happens
3. When I'm trying to pull the table when debugging with activesynch and my CE5 device I get the error : Failure to open SQL Server with given connect string. However all my parametes are correct e.g. datasource(I either use the IP address of my computer or the computer name, the initila catalog (database name), username nad password=. Any thoughts This also happens if I try to pull data from my application which is deployed in the device.
4. Can I pull data to the pocket pc by using the activesynch from another computer without having a network connection For example nw6515 doesn't have a WLan support. However when connecting with active synch with my computer which is connected to the internet I can connect to Internet from my device. I suppose this also happens when trying to pull data from a server which is connected with Lan with my laptop on which is connected with ativesynch my pocket pc. Is this true
Regards,
Manolis

sql mobile questions
CallMeLee
I ask and answer my self.
For the connection issue the Provider (Provider=SQLOLEDB.1) was missing from the connection String. The provider was not included in the Pull examples of Visual Studio 2005 and SQL Mobile Books Online.
Therefore I managed to pull data from the MSSQL 2000 and without having to connect to the network from my pocketpc only by using ActiveSynch.
Regards,
Manolis
Chiajen Wu
I ask and answer myself.
For the connection issue the Provider (Provider=SQLOLEDB.1) was missing from the connection String. The provider was not included in the Pull examples of Visual Studio 2005 and SQL Mobile Books Online.
Therefore I managed to pull data from the MSSQL 2000 and without having to connect to the network from my pocketpc only by using ActiveSynch.
Regards,
Manolis
BA
Me again
Regarding the pill problem I tried to odify firewall settings. I even disabled the firewall. I also tested the telnet serverIPAddress 1433 and I can connect correctly.
Any ideas I think this is the alst step for me to built my applications again.
And one comment. I expected some layout enhabcments regarding the built applications. They have the same look and feel like those built with embedded visual basic 6 years ago.
Reagrds,
Manolis P