Connecting to a SQL Server database issue
Hi all,
I am trying to connect to my SQL server database to upload a file to the new user interface. I believe that I have everything set up but I keep getting the same error which is too generic for me to do anything with. the error I am getting from my log is this:
2015/02/05 15:08:55 GMT:
============================================================================================================================================
2015/02/05 15:16:41 GMT:#################### ERROR OCCURRED WHILE USING UpladFromDB Tool ####################
2015/02/05 15:16:41 GMT:Error !!!
Please provide necessary connection parameters in C:\UploadTool\conf\database_connection_params.conf.
2015/02/05 15:16:41 GMT:More Information ::
java.lang.RuntimeException: Please provide necessary connection parameters in C:\UploadTool\conf\database_connection_params.conf.
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.getConnectionURL(ZohoReportUploadDataFromDB.java:361)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:151)
==============================================================================================================================================
So I go to my database_connection_parm.conf but as far as I can tell all the settings are correct. Obviously I wont put my real settings in here but it looks something like this:
==================================================
# $Id$
DBTYPE=SQLServer
HOSTNAME=[ServerName]
PORT=1433
USERNAME=[SQLAuthUsername]
PASSWORD=[password]
DBNAME= [DBName]
MDBFILENAME=
SQLITEFILENAME=
FIREBIRDFILENAME=
# Generic JDBC connection properties: To upload from a unsupported local database which has a JDBC connector / driver:
# Below properties should be used in this case. It is enough to provide the value for DBTYPE, DRIVERCLASSNAME and CONNECTIONURL
# to connect a unsupported local database from upload tool. If username and password is not specified as part of the CONNECTIONURL
# then please specify it in the properties USERNAME and PASSWORD. DBTYPE can be the name of your local database say Progress( OpenEdge ) DB
#DRIVERCLASSNAME=
#CONNECTIONURL=
===================================================================
is something out of place? Any help would be appreciated.
Regards