(Sorry about sending the personal message. At the time I thought it was replying to the list.)
Thanks again. I am trying to connect to SQL Server and Oracle databases, but for now I need SQL Server connections. I did want to use JDBC but even that was not working. I downloaded the files (to try) because the connections were not being made. I am using the OpenBD console. What do I select to create the connection? "Microsoft SQL Server (jTDS)"? "Microsoft SQL Server 2005 (Microsoft)"? "Other JDBC Driver"? Running OpenBD/Tomcat on Ubuntu 9.04. D. From: Matthew Woodward <[email protected]> Date: Sun, 03 May 2009 07:43:45 -0700 Subject: Re: ODBC To: twigboy2 <[email protected]> twigboy2 wrote: > Thank you for providing the assistance. I also am having this > trouble, even after re-downloading the jar files. You shouldn't have to worry about downloading any jar files unless you're using a database for which we don't ship the drivers with OpenBD. What database type are you connecting to (SQL Server, Oracle, etc.)? How are you setting up your datasource--admin console or by editing bluedragon.xml directly? And you want to connect via JDBC, not ODBC right? ODBC will not work on Linux, not without adding ODBC support at the OS level anyway (at least that's my understanding, but I never use ODBC). You don't want to use ODBC anyway since the performance will be horrible compared with JDBC. > I am running OpenBD > (downloaded this week) using Tomcat on Ubuntu 9.04 (http:// > wiki.openbluedragon.org/wiki/index.php/Apache_Tomcat_on_Ubuntu). I > put the jar files in /opt/tomcat/webapps/openbd/WEB-INF/lib. Again, if you're using one of the databases we support out of the box, you don't need to do this. If you're using drivers we don't support, you can also try putting them in /opt/tomcat/lib as opposed to the lib directory of the specific webapp. And you DO have to restart Tomcat after adding JAR files to the lib directory. > OpenBD works but I can not get a datasource setup, regarding the error > message as above. I don't understand classpath (where? how?). Putting JAR files in the lib directory will add it to the classpath. That's all you have to do. -- Matt Woodward [email protected] http://www.mattwoodward.com/blog Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
