Question
No suitable driver - CF8 - JDBC sqljdbc.jar
I have a new 64-bit server with Windows Server Standard 2007,
SP1 and CF8 and am trying to get the Microsoft SQL Server 2005 JDBC
Driver 1.2 set up for my data sources. We are using this driver
today in our CF7 server just fine.
First, I was not the one who installed CF8 on this server, so I'm not sure if the issue is with that or not. But I have it configured for multi-instance and configured two additional instances, but for now I am just trying to create a data source in the default installation. I am able to use the built-in SQL Server driver with no issues, but we currently use the JDBC and don't want to switch now in case there are unanticipated variances.
I have followed the instructions in this configuration article, but I don't have a Java and JVM screen in my administrator, so I have added the driver path directly to my jvm.config file, stopped and restarted CF. Still I get the error. Here are the settings for my JVM classpath...
# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/servers/lib,{application.home}/lib
,C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar
I tried it in quotes, I tried it with forward slashes instead of backslashes. None of that worked. Here is the error I receive...
Connection verification failed for data source: Testing3
java.sql.SQLException: No suitable driver available for Testing3, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver
The root cause was that: java.sql.SQLException: No suitable driver available for Testing3, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver
Here are the data source settings (the same that work for us in CF7):
JDBC URL: jdbc:sqlserver://204.73.44.103:1433;DatabaseName=Testing3
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: JDBC
I don't know if my issue is that I have a J2EE installation (maybe why I don't see the Java and JVM settings page in Administrator). If that is my issue, how should I configure the driver? I've found nothing else online to address this.
Anyone who can help I'd much appreciate it! Thank you.
First, I was not the one who installed CF8 on this server, so I'm not sure if the issue is with that or not. But I have it configured for multi-instance and configured two additional instances, but for now I am just trying to create a data source in the default installation. I am able to use the built-in SQL Server driver with no issues, but we currently use the JDBC and don't want to switch now in case there are unanticipated variances.
I have followed the instructions in this configuration article, but I don't have a Java and JVM screen in my administrator, so I have added the driver path directly to my jvm.config file, stopped and restarted CF. Still I get the error. Here are the settings for my JVM classpath...
# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/servers/lib,{application.home}/lib
,C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar
I tried it in quotes, I tried it with forward slashes instead of backslashes. None of that worked. Here is the error I receive...
Connection verification failed for data source: Testing3
java.sql.SQLException: No suitable driver available for Testing3, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver
The root cause was that: java.sql.SQLException: No suitable driver available for Testing3, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDriver
Here are the data source settings (the same that work for us in CF7):
JDBC URL: jdbc:sqlserver://204.73.44.103:1433;DatabaseName=Testing3
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: JDBC
I don't know if my issue is that I have a J2EE installation (maybe why I don't see the Java and JVM settings page in Administrator). If that is my issue, how should I configure the driver? I've found nothing else online to address this.
Anyone who can help I'd much appreciate it! Thank you.
AdChoices