Forum Discussion

Stuart_Myers_88's avatar
Stuart_Myers_88
Icon for Nimbostratus rankNimbostratus
Mar 24, 2010

MSSQL JBDC Files?

Microsoft no longer offers the "Microsoft SQL Server 2000 Driver for JDBC" referenced in the Manual. instead they refer you to "Microsoft SQL Server JDBC Driver 2.0" Which appears to have a different file structure and different filenames for everything.

 

 

Anyone have any luck in getting this to install? So far i have extracted the .TAR, and Copied the .JAR's (2 availible) to the LTM. It is still giving me the "'Error loading driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver'"

 

 

 

Anybody work through this with the new drivers? or have th eold drivers availible? do the work with SQL 08?
management
monitoring
  • hwidjaja_37598's avatar
    hwidjaja_37598
    Icon for Altostratus rankAltostratus
    Mar 25, 2010
    Use echo $CLASSPATH command to check whether the driver is in the CLASSPATH. If it's not set correctly then you'll need to set using this command:

     

     

    export CLASSPATH=$CLASSPATH:

     

     

    Remember to change with the actual path to your JDBC driver.

     

     

    Btw, Where did you see that message? Can you tell us what steps you have done?

     

     

    I'm not familiar with Java and MSSQL so pardon me if my comments are not helping.
  • Stuart_Myers_88's avatar
    Stuart_Myers_88
    Icon for Nimbostratus rankNimbostratus
    Mar 25, 2010
    I did what you suggested and re-booted the box, It is still showing the right directory for the JAR files, but the SQL monitor is still not working. I am getting the error from the logfile generated from the "debug" mode on the mssql monitor.

     

     

    Total output of the debug log:

     

     

    ********** Debugging session beginning at: Thu Mar 25 15:07:40 2010

     

     

    Arguments 1-2:

     

    ::ffff:10.22.231.190

     

    1433

     

     

    Environment variables:

     

    COUNT=0

     

    DATABASE=***EDITED***

     

    DEBUG=yes

     

    MON_TMPL_NAME=DB_TEST

     

    NODE_IP=::ffff:10.22.231.190

     

    NODE_PORT=1433

     

    PASSWORD=***EDITED***

     

    RECVCOLUMN=1

     

    RECVROW=2

     

    RECV_I=Appling

     

    SEND=select County_Name from County where County_ID = 1

     

    USERNAME=coreadmin

     

    count='0' converts to '0'

     

    pidfile exists -- checking for correctness of pid...

     

    DBDaemon says its pid is 16226

     

    pid of 16226 is correct!

     

    Recvd: 'com.microsoft.jdbc.sqlserver.SQLServerDriver

     

    '

     

    Recvd: 'jdbc:microsoft:sqlserver://10.22.231.190:1433;databaseName=***EDITED***;

     

    '

     

    Recvd: '***EDITED***

     

    '

     

    Recvd: '***EDITED***

     

    '

     

    Recvd: '0

     

    '

     

    Recvd: 'select County_Name from County where County_ID = 1

     

    '

     

    Recvd: 'Appling

     

    '

     

    Recvd: '2

     

    '

     

    Recvd: '1

     

    '

     

    Recvd: 'debug

     

    '

     

    Recvd: 'Loading database driver com.microsoft.jdbc.sqlserver.SQLServerDriver

     

    '

     

    Recvd: 'Error loading driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver!Down!

     

    '

     

    Error receiving up/down message