API and JDBC

Greg,

curious, Ive never heard of either of these products. what is API and Laborworx?

API Healthcare is the vendor that supplies us with our Time and Attendance software. (We absolutely love it)... Laborworx is just their semi-new version of the software. http://www.apihealthcare.com/time-attendance
I believe that it uses an encrypted database, and that's the reason that we are struggling to create a JDBC connection to it...
(Perhaps I should post to IPA forum as well, because as I understand it, IPA requires a JDBC connection.)

JDBC is something that is set up in a servlet container (WebSphere, Tomcat, etc). But you posted to Crystal. Are you trying to connect to these via Crystal? If so, what is the database platform?

API is running on a sql server platform...

I know that the SmartNotes are connecting to a JDBC connection that someone set up in WebSphere via JNDI... but being totally new to the Java-based , I'm unfamiliar with how to connect to this new database outside of SN.

Ok, so if you are trying to write a Crystal Report just use native SQL Server drivers. When connceting to a new data source in Crystal it should be one of the last options. Otherwise you can use OLE DB for SQL Server or an ODBC driver (my least favorite). Whether its encrypted or not wont matter as long as you have the correct connection parameters.

if there is a JDBC set up for SmartNotes via the WebSphere JNDI, login to the WebSphere Admin Console, edit the JNDI and get the connection parameters from there there. You should only need the server name and perhaps port (if its non-standard 1521 for SQL Server).