AS400 access issue

[kfoss]

We rebuilt our development CF system (now based on Win2003) after a drive
crash, and we are using the JT400.jar JDBC driver to connect to as AS400. This
mirrors our production configuration (running Win2000), except I cannot get the
JDBC connection established. I get the following message:

Connection verification failed for data source: AS400CF
[]java.sql.SQLException: No suitable driver available for AS400CF, please
check the driver setting in resources file, error:
com.ibm.as400.access.AS400JDBCDriver
The root cause was that: java.sql.SQLException: No suitable driver available
for AS400CF, please check the driver setting in resources file, error:
com.ibm.as400.access.AS400JDBCDriver

I have verified the Java and JVM Class Path entry includes the JT400.jar file
location, and the JDBC configuration contains the exact same URL and Class
values.

The JT400.jar file is the exact same as on our production system, they both
point to the same AS400, there is no firewall between systems, both development
and production CF versions are the same (6,1,0,63958) and the same JRE info.
In short, I canot find anything different to cause the error.

Does anyone have any idea where I go for clues?

Thanks in advance,

Ken

[mxstu]

I'm not using AS400 so this is just a shot in the dark, but did you verify that
there is only one version of the class/jar in the jvm class path? I've received
that type of error for other databases when there were multiple versions of a
driver jar in the class path.

You might also want to check google groups to see if any of these posts
pertain to your problem:

[url]http://groups.google.com/groups?hl=en&lr=&q=No+suitable+driver+available+fo r+AS4[/url]
00&qt_s=Search

[kfoss]

I replaced the jt400.jar file directly from the production CF server, and
everything works fine now. Something must have been corrupt in the original
file (although it had the same last modified date/time and size).

[senthilarjun]

I am having the same problem in my cf server that is running on fedura linux.
i have the jt400.jar classpath in the linux's bash_profile

but still i get the error

Connection verification failed for data source: demo22
java.sql.SQLException: No suitable driver available for demo22, please check
the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available
for demo22, please check the driver setting in resources file, error: null

thanks in advence

senthil