jQuery in Action, 3rd edition
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: 9059
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: 1141

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: http://aspose.com/file-tools
subject: Orion and MS Access 2000
It's not a secret anymore!