Here is may data-source.xml. I hope this can help you. <?xml version="1.0"?> <!DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd"> <data-sources> <!-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the "EJB" one - it provides transactional safety and connection pooling. --> <data-source name="MSSQLServer" location="jdbc/MSSQLCoreDS" xa-location="jdbc/xa/MSSQLXADS" ejb-location="jdbc/MSSQLDS" connection-driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:sqlatogo" username="" password="" inactivity-timeout="30" class="com.evermind.sql.DriverManagerDataSource" /> <data-source class="com.evermind.sql.DriverManagerDataSource" name="Hypersonic" location="jdbc/HypersonicCoreDS" xa-location="jdbc/xa/HypersonicXADS" ejb-location="jdbc/HypersonicDS" connection-driver="org.hsql.jdbcDriver" username="sa" password="" url="jdbc:HypersonicSQL:./database/defaultdb" inactivity-timeout="30" /> </data-sources> ----- Original Message ----- From: Michael S. Kelly <[EMAIL PROTECTED]> To: Orion-Interest <[EMAIL PROTECTED]> Sent: Thursday, December 21, 2000 10:21 PM Subject: Orion, JDBC-ODBC bridge, and SQL Server > Anyone out there that is using the the JDBC-ODBC bridge that would share > their data-sources.xml file with me? I plan on using SQL Server 2000. > Anything special I should know? > > -=michael=- > > ====================================================================== > Michael S. Kelly ____ _ > Axian, Inc. // |_ __(_) ___ _ __ > 4800 SW Griffith Dr., Ste. 202 file://| |\\/ /| |/ _ \| '_ \ > Beaverton, OR 97005 USA _____//_| | / / | | |_| | | | | > Voice: (503)644-6106 x122 (( // |_|/_/\\|_|\_/|_|_| |_| > Fax: (503)643-8425 ``-'' ``-'' > http://www2.axian.com Software Consulting and Training > mailto:[EMAIL PROTECTED] > ====================================================================== > >
<?xml version="1.0"?> <!DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd"> <data-sources> <!-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the "EJB" one - it provides transactional safety and connection pooling. --> <data-source name="MSSQLServer" location="jdbc/MSSQLCoreDS" xa-location="jdbc/xa/MSSQLXADS" ejb-location="jdbc/MSSQLDS" connection-driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:sqlatogo" username="" password="" inactivity-timeout="30" schema="d:\orion\config\database-schemas\ms-sql.xml" class="com.evermind.sql.DriverManagerDataSource" /> <data-source class="com.evermind.sql.DriverManagerDataSource" name="Hypersonic" location="jdbc/HypersonicCoreDS" xa-location="jdbc/xa/HypersonicXADS" ejb-location="jdbc/HypersonicDS" connection-driver="org.hsql.jdbcDriver" username="sa" password="" url="jdbc:HypersonicSQL:./database/defaultdb" inactivity-timeout="30" /> </data-sources>
