Skip to Content

Hello,

I have some trouble concerning the following mini-example ( see attached txt-file ). I’m trying to establish a connection from my mobile device ( Windows Mobile 6.5 ) to a SQL server. The connectionstring works fine on my Notebook.

My mobile device returns a SAException “Database server not found”

Is there anything I should know about the connectionstring with regard to the mobile device OS?

Thanks for any help!

Best Regards

Timo

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Timo Hertel Post author

    Hello Mirco,

    thanks for your response. I not sure, if we talk about the same thing.

    There is a Windows Mobile device that has to receive some Data from a known Server.  On that server runs the SQL Anywhere DB.

    The question is: If you have to develop an application for the WM device, how would the connection to the SQL Anywhere server look like?

    If I use  my notebook as the receiving client, I define a SAConnection with the following Connectionstring:  “Host=123.123.123.123;Server=Text;dbn=dbTest;uid=dba;pwd=sql”

    … and it works well.

    Is there a similar command for a Wm 6.5 smart device application?

    Thanks for any help!

    Best regards

    Timo

    (0) 
    1. Mirco Simoni

      http://dcx.sap.com/index.html#sqla170/en/html/826b0c206ce21014909bbea79c53190c.html

      Hi Timo,

      You can access data that are stored on the remote server in two ways: online or offline.

      If online, you can use web services and retrieve data, for example, using a web browser running on Window Mobile and leveraging the SQL Anywhere HTTP web server.

      If offline, you can have another SQL Anywhere database on windows mobile and use Mobilink to synchronize data. Then you could develop an user interface, for example using .NET, to access your data on Windows Mobile. Another option would be to use UltraLite database and Mobilink on Windows Mobile (link above).

      If you install SQL Anywhere 16 or 12, you can find sample applications for Windows CE  in Documents\SQL Anywhere 16\ Samples\SQL Anywhere\CE

      You could connect to the database on Windows Mobile, using a data source file, or a connection string similar to what you have specified in your post. But the database server and database file would be on your Windows Mobile device.

      (0) 
      1. Chris Keating

        Assuming that the mobile device is able to access the IP pf the server hosting the SQL Anywhere network server engine (dbsrvX.exe where X is the major version of SQL Anywhere), you should be able to connect. How are you verifying that the WM6.5 can access the IP cited in the connection string? Does this connection code work from a different desktop or laptop environment – this will ensure that the database server  is accessible from a remote location?

        You can add LOG=<filespec> to the connection string on the devince and -z -o <filespec> on the database server start line to help troubleshoot this issue further.

        (0) 
  2. Timo Hertel Post author

    Thanks for all response. I found out that there is a service which has to run to establish the connection.

    After startig the service “C:\Program Files\SQL Anywhere 16\bin32\dbsrv16.exe” and filled the start options the connection between mobile device and server works instantly.

    Thanks for your help Mirco & Chris

    Best regards and bye bye

    Timo 

    (0) 

Leave a Reply