I've a problem with upload tool from local database. It not found de SQL instance of Database and take me this error.
2013/12/19 08:26:21 COT: OS : Windows 7 6.1 x86
2013/12/19 08:26:21 COT: JVM Version : 1.6.0_16
2013/12/19 08:26:21 COT:TESTRUN :: false
2013/12/19 08:26:21 COT:2013-12-19 08:26:21.188 :: Connection Props are :
2013/12/19 08:26:21 COT:DBTYPE :: sqlserver
2013/12/19 08:26:21 COT:HOSTNAME :: 192.168.0.11
2013/12/19 08:26:21 COT:USERNAME :: icummings
2013/12/19 08:26:21 COT:PORT :: 1433
2013/12/19 08:26:21 COT:DBNAME :: FootPrint
2013/12/19 08:26:21 COT:MDBFILENAME ::
2013/12/19 08:26:21 COT:SQLITEFILENAME ::
2013/12/19 08:26:21 COT:FIREBIRDFILENAME ::
2013/12/19 08:26:21 COT:CONNECTION URL :: jdbc:jtds:sqlserver://192.168.0.11:1433/FootPrint
2013/12/19 08:26:21 COT:TOTAL NUMBER OF QUERIES :: 1
2013/12/19 08:26:21 COT:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2013/12/19 08:26:21 COT:Logging in...
2013/12/19 08:26:21 COT:Logged in successfully...
2013/12/19 08:26:22 COT:Exception occured while establishing connection to the database server
2013/12/19 08:26:22 COT:java.lang.RuntimeException: Exception occured while establishing connection to the database server
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:522)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:110)
Caused by: java.sql.SQLException: No se puede abrir la base de datos "FootPrint" solicitada por el inicio de sesión. Error de inicio de sesión.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:499)
... 1 more
I think that this error is provocated for java jtds library, because the url conection good should be
COT:CONNECTION URL :: jdbc:jtds:sqlserver://192.168.0.11/FCIWAREHOUSE:1433/FootPrint.