File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Java Products and Servers and the fly likes Orion and MS Access 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Orion and MS Access 2000" Watch "Orion and MS Access 2000" New topic

Orion and MS Access 2000

Vamsee Kanakala

Joined: Jul 14, 2004
Posts: 5
Hello everybody,

I'm trying to set up a global datasource in orion for ms access 2000. I can't find anything by googling. How do I configure /conf/data-sources.xml for this? Did anybody work on this problem before? Any ideas?


Because joy is one's fuel - Ayn Rand
Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9056
Have your JDBC connection details at hand, including the class name of your JDBC driver, url, username and password.

I'm no expert in Microsoft Access... try using the following: "sun.jdbc.odbc.JdbcOdbcDriver" or ask further questions in the JDBC forum.

Then you probably want something like this (only with MS Access-specific stuff instead of Sybase-specific stuff).

Driver : com.sybase.jdbc2.jdbc.SybDriver
URL : jdbc:sybase:Tds:localhost:4100
Username : me
Password : abcdef

To add a data-source with these JDBC settings, add something similar to the following to data-sources.xml:


name="Test data-source"




Notice the final attribute: class="...". This is not the class name of your JDBC driver but that used by Orion to manage connections. Leave it as is.
[ July 25, 2004: Message edited by: Marilyn de Queiroz ]

"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

Have you tried the following Web sites:

OrionServer expects a JDBC driver (in the form of a JAR file) to be placed in the "lib" directory -- that's why you need to tell it the name of the JAR file in the config/data-sources.xml file. However, for Microsoft Access, there is no JDBC driver (as far as I am aware) -- you use the JDBC-ODBC driver that comes with the J2SE SDK. Hence I don't know what you would put in the appropriate entry in the "data-sources.xml" file. You may try searching for a different JDBC driver for Microsoft Access -- a JAR file that you can place in the "lib" directory.

Good Luck,
[ July 25, 2004: Message edited by: Avi Abrami ]
Vamsee Kanakala

Joined: Jul 14, 2004
Posts: 5
Thanks Marilyn & Avi! I set it up and it's running smootly now
I agree. Here's the link:
subject: Orion and MS Access 2000