LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

How do I connect to a sybase DB using the DB Query Node?

Thank you,

Mike

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Mike, we support ODBC in the DB Query node, and we have a JDBC Query node as well. For either, the basic process is to get the appropriate drivers from the company, and set up the connection following their directions. Our interface should be pretty standard and the information required in it for the JDBC node should be documented in the JDBC driver you get; the docs have some examples to help guide you with the type of thing you are looking for. For the ODBC node, you will need to provide the service name and credentials given to you by the setup. I am not aware of anything specific that needs to be done for Sybase. Are you doing this on an enterprise or desktop server? I think for enterprise you will need to modify the odbc.ini file as well, which should be highlighted in their doc, I believe.

Also, here are a couple of posts that might give you a little more information:
http://community.lavastorm.com/showt...ODBC-w-Solaris
http://community.lavastorm.com/showt...reSQL-database

Cheers
Rich

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rabbott

We know of one customer that used JDBC to connect to Sybase successfully. Just copy the JDBC driver *.jar file to the $LAE_HOME/lib/java/ext directory and restart the server to install the driver. If the "ext" directory does not exist (it may not for the Lavastorm Desktop), just create it. You will of course then need to configure the DbDriver and DbURL parameters in the JDBC nodes according to the Sybase JDBC documentation in order to get the nodes working.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

One last thing, this is a bit from in our release notes:

As a guideline for customers selecting ODBC drivers:
- For RedHat Linux and Oracle Unbreakable Linux, the *odbc64 driver packages should be used.
- For Solaris, drivers should be built using the installed unixODBC headers. These are located in <install-root>/ platform/linux-x86-64/os/include.

Cheers
Rich