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?
/> 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 ]
JavaBeginnersFaq "Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
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 ]
Joined: Jul 14, 2004
Thanks Marilyn & Avi! I set it up and it's running smootly now