The error we're getting when trying to establish a connection:
Connection verification failed for data source: time_beta
[]java.sql.SQLException: No suitable driver available for time_beta, please check the driver setting in resources file, error: com.microsoft.jdbc.sqlserver.SQLServerDriver
The root cause was that: java.sql.SQLException: No suitable driver available for time_beta, please check the driver setting in resources file, error: com.microsoft.jdbc.sqlserver.SQLServerDriver
The datasource set up:
JDBC URL jdbc:microsoft:sqlserver://thecorrectIPaddress:1433;DatabaseName=thecorrectDBname
Driver Class com.microsoft.jdbc.sqlserver.SQLServerDriver
Here is the directory the jar files are downloaded to:
# pwd /opt/msSQLjdbc/lib
# ls -l
-rwxr-xr-x 1 nobody web 301290 Dec 20 2002 msbase.jar
-rwxr-xr-x 1 nobody web 69118 Dec 20 2002 mssqlserver.jar
-rwxr-xr-x 1 nobody web 64039 Dec 20 2002 msutil.jar
#
Here is the classpath:
/opt/msSQLjdbc/lib/mssqlserver.jar,/opt/msSQLjdbc/lib/msbase.jar,/opt/msSQ
Ljdbc/lib/msutil.jar
All permissions are set correctly.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
