PDA

Click to See Complete Forum and Search --> : Connecting to CA-IDMS via JDBC drivers

jpmad4it
July 23rd, 2008, 07:44 AM
Hi there

I know that I can connect to an IDMS DB using JDBC type 4 drivers, but I have a few questions:

Is this the process:
- Set up the IDMS system to allow JDBC connections - defining TCP/IP lines etc.
- Install CA-IDMS Server on client PC
- Try to establish connection.
- Use JDBC driver in web page programming to connect to DB (similar to mySQL and ODBC?) and retrieve data from the IDMS-> display it on the webpage.

Is that overview correct, or have I got it totally wrong?

Here is the diagram of how it works:

http://i5.photobucket.com/albums/y164/jpmad4it/1.jpg

It shows that connecting the IDMS via TCP/IP to the JDBC Type 4 driver requires either a Java Platform (does this mean Windows, linux etc) or a Java Client.....what do those mean? How does it work?

If anyone could help clear this up I would be very grateful.

Kind regards
Jonathan
olivthill
July 24th, 2008, 08:17 AM
JDBC is a kind of ODBC for Java. Therefore the Java runtime (JVM) is required.

You say "Install CA-IDMS Server on client PC". Maybe, it is rather to be installed on a server. The client has JVM and that should be enough for the client.
jpmad4it
July 24th, 2008, 09:18 AM
JDBC is a kind of ODBC for Java. Therefore the Java runtime (JVM) is required.

You say "Install CA-IDMS Server on client PC". Maybe, it is rather to be installed on a server. The client has JVM and that should be enough for the client.

Hi. I'm pretty sure that its to be installed on the client, its in CD format. Plus it installs programs on the PC.

This gets even more confusing.

We may need to use PHP for our website anyway, and so I don't think JDBC will support this?? I have read a few articles about bridging java and php but its confusing.