JDBC driver for Win CE "Access" tables

It is an older question already, but still relevant; Is there any JDBC driver available for getting access to MS Access databases on the Win CE devices?Workarounds?DLLs which support SQL?

[215 byte] By [joachimkroeger2] at [2007-9-26 2:01:14]

«« Circular JButton
»» Display Options?

# 1

When I read that topic, I hoped that someone got an answer to that.I even havent seen how to access the database in any way.So an additional question is where to get the specs for the databases so a driver can be written ?Oliver

ofels at 2007-6-29 8:41:19 >

top of Java-index,Java Mobility Forums,Java ME Technologies...

# 2

I have been investigating any further and the results are somehow confusing.

First, a JDBC driver does definitely not exist.

There is a Microsoft API called ADOCE (ActiveX Data Objects for CE) which seems to handle all access to the database.

Though I have not seen any indication, I believe there is a small chance to access Object Store and Pocket Access via ODBC and with the JDBC-ODBC bridge from the JAVA side.

Oliver

ofels at 2007-6-29 8:41:19 >

# 3

Do you know more about this bridge?

joachimkroeger2 at 2007-6-29 8:41:19 >

# 4

It should be included in the jdbc package and thus inside the normal j2sdk.I am not sure about PersonalJava.Look here: http://java.sun.com/products/jdk/1.1/docs/guide/jdbc/getstart/bridge.doc.htmlOliver

ofels at 2007-6-29 8:41:19 >

# 5

Hi Oliver, thanks for sharing this.

ADOCE is the right thing in the MS development domain.

In the meantime I did some DLL and JNI work against a different problem. So maybe I will try to go along this path - writing a JNI wrapper for a minimum. But I still don't like to take this route...

ADO has at least the advantage of delivering access to more than just access tables (PIM data..)

joachimkroeger2 at 2007-6-29 8:41:19 >

# 6

I'm trying to connect to a pocket access db on windows ce and was wondering if you ever found out how?

dholloway12 at 2007-6-29 8:41:19 >

# 7

Include me in that - I can't find any information yet.Thank youTom Berry

BerryT at 2007-6-29 8:41:19 >

# 8

Just to update those interested: I did drop this attempt and used a native Java store, no SQL. But I still see a need for that. Sorry.

kroegerJoachim at 2007-6-29 8:41:19 >

# 9

I am so wondering. Though many developers are trying to find that solution.

It hasn't been found.

It is already old question for 2 years.

I am also seeking the way how to control Access db file on PJAE environment.

I guess ADOCE on VB is quite smart....

Is there anybody who knows it?

figaro98 at 2007-6-29 8:41:19 >

# 10

Me too.Hello,knights-errant,who knows/find it~``Help.

biniyi at 2007-6-29 8:41:19 >

Java Mobility Forums

Java ME Technologies

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

JDBC driver for Win CE "Access" tables

Java Mobility Forums New Topic

Java Mobility Forums Hot Topic

Java Mobility Forums

All Classified