On Thu, Jun 17, 2010 at 5:57 AM, Mario_METCA <[email protected]>wrote:
> I wonder if you can help me with an issue. A co-worker of mine is > attempting to move an application over to OpenBD and he is having > issues connecting Sybase. > The jTDS driver that's included with OpenBD will connect to Sybase, but you'll have to manually configure the datasource since Sybase isn't one of the databases for which the admin console can format the JDBC URL for you. You can either edit the XML and enter the info manually, or using the admin console you can create a datasource of the "Other JDBC Driver" type and use the info here to create your connection: http://jtds.sourceforge.net/faq.html#driverImplementation >From that it looks to me like you'd use these values: JDBC URL: jdbc:jtds:sybase://server:port/databasename DRIVER CLASS: net.sourceforge.jdbc.jtds.Driver I don't have sybase so I can't test, but based on the URL from the jTDS site I included above, that looks like a good starting point to me. Hope that helps. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward 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://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon online manual: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
