Orion and MS Access 2000

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?

TIA,
Vamsee.

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:

<data-source

name="Test data-source"

location="jdbc/TestCoreDS"
xa-location="jdbc/xa/TestXADS"
ejb-location="jdbc/TestDS"

connection-driver="com.sybase.jdbc2.jdbc.SybDriver"
url="jdbc:sybase:Tds:localhost:4100"
username="me"
password="abcdef"

inactivity-timeout="30"
class="com.evermind.sql.DriverManagerDataSource"

/>
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 ]

Vamsee,
Have you tried the following Web sites:

http://www.orionserver.com

http://www.orionsupport.com

http://kb.atlassian.com

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,
Avi.
[ July 25, 2004: Message edited by: Avi Abrami ]

Thanks Marilyn & Avi! I set it up and it's running smootly now