Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 457
	Members: 0
	Total: 457

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

API and JDBC

6 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Greg Moeller

Veteran Member

Posts: 1498

3/9/2015 2:12 PM

Is anyone out there using API and have upgraded to the Laborworx version (API .NET)?

We are trying to create a JDBC connection to the database, and cannot any longer.
It used to work before we upgraded, but has something changed in the database config that
is now preventing us from using a JDBC connection?

Thanks in advance,
-Greg

Matthew Nye

Veteran Member

Posts: 514

3/9/2015 2:59 PM

Greg,

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

Greg Moeller

Veteran Member

Posts: 1498

3/9/2015 3:06 PM

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.)

Matthew Nye

Veteran Member

Posts: 514

3/9/2015 3:22 PM

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?

Greg Moeller

Veteran Member

Posts: 1498

3/9/2015 3:37 PM

API is running on a sql server platform...

Greg Moeller

Veteran Member

Posts: 1498

3/9/2015 3:39 PM

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.

Matthew Nye

Veteran Member

Posts: 514

3/9/2015 3:45 PM

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).