INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

Access local database on Windows Mobile 6

Access local database on Windows Mobile 6

(OP)
Hi,
I have installed a local database on my pda - Windows Mobile 6. The name of the database is "mobiledb". Using the "Mimer SQL Exlorer" on the PDA I can open the database and have look to the tables and views. Everything seems to be ok.

I have created a MIDLet with the following connection code:
MimerDataSource mds = new MimerDataSource();
mds.setUser("SYSADM");
mds.setPassword("******");    
Connection con = mds.getConnection();

The jad have the following content:
MIDlet-1: BrowserPhoneNumbers, BrowserPhoneNumbers.png, BrowserPhoneNumbers
MIDlet-Jar-Size: 96743
MIDlet-Jar-URL: BrowserPhoneNumbers.jar
MIDlet-Name: BrowserPhoneNumbers
MIDlet-Permissions: javax.microedition.io.Connector.socket
MIDlet-Vendor: Unknown
MIDlet-Version: 1.0
MicroEdition-Configuration: CLDC-1.1
MicroEdition-Profile: MIDP-2.1

Now, when I run the MIDLet on the PDA I receive the following message:
Could not establish connection to server db on host 127.0.0.1 using port 1360, java.microedition.io.connectionNotFoundException

Could anybody give me a hint to get the connection to the local mobile database?

Thanks for your help

RE: Access local database on Windows Mobile 6

I don't think it is the problem because if it is you should get an error like "unknown database" or somewthing like that. Anyway, you wrote that your database is called "mobiledb", but your connection request attempts to connect to "db". You may try to add mds.setDatabase("mobiledb") somewhere.

The error text you have quoted however indicates at least another error. I don't know the exact cause of this problem but it appears your Java application cannot even establish a connection to the database.

I currently don't have any good suggestions but Java applications (at least on Windows Mobile) communicates with the server using loopback TCP/IP. The Mimer server responds to all TCP/IP connection requests via a small TCP name server. This need to be alive, and on Windows Mobile it should have a TCP-icon visible on the screen when it is. When this TCP name server receives a request to use a database such as "mobiledb", it will check to see if it exists and sets up the connection.

You may start by ensuring that you have a TCP-icon which indicates that the Mimer server is ready to accept TCP connections. You may also check the process list for a tcpsrv.exe .

If you don't have the TCP-icon or a tcpsrv.exe running something is obviously not working properly since this should start automatically either when the device is started or when a Mimer database is started (I am not 100% which it is).
 

RE: Access local database on Windows Mobile 6

(OP)
Hi,
thanks for your answer ... I think you are right

on my PDA device I found five application files:
1. dbminsrv
with this application I can start the Mimer SQL server

2. dbserver
with this application I can start also the Mimer SQL server

3. minadmin
with this applicaton I can control the database

Here I found a control function to start the Mimer SQL Server, but it is not working. I receive the following message "Unable to create database server process. Command line: "dbminsrv".exe" CreateProcess - the requested file could not be found.

But ... when I have started 1. or 2. the database icon is green otherwise it is red. I seems that the process in now running

4. mimexpl
with this applicaton I can open the database; but only when the Mimer SQL Server is running

5.tcplcl
when I double-click on ths application nothing happened;
the name "tcplcl" sounds like tcp/ip.

Question: Does anybody know how to configure the Mimer SQL Server on Windows Mobile 6.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close