Hello,
I'm trying to connect to Sql Server 2008 in Zoho Reports using the upload tool but this is showing the error below. I already checked the information and it is correct. How can I solve this problem?
database_connection_params.conf
DBTYPE=sqlserver
HOSTNAME=VIX-DB-001
PORT=1433
USERNAME=sa
PASSWORD=samaster
DBNAME=MMDB
#MDBFILENAME=
#SQLITEFILENAME=
#FIREBIRDFILENAME=
Follow the logs.
2017/11/08 18:02:36 BRST: OS : Windows NT (unknown) 6.2 x86
2017/11/08 18:02:36 BRST: JVM Version : 1.6.0_16
2017/11/08 18:02:36 BRST:System Properties
os.arch :: x86
java.version :: 1.6.0_16
TESTRUN :: false
CONN_PARAMS_FILE :: conf\database_connection_params.conf
user.dir :: C:\ZohoReports\UploadTool
os.name :: Windows NT (unknown)
os.version :: 6.2
CONFFILE :: conf\common_params.conf
TEMP_DIR :: C:\ZohoReports\UploadTool\temp
IMPORT_OPTIONS_FILE :: conf\database_sql_queries.xml
2017/11/08 18:02:36 BRST:Common Properties
ZOHO_CANOVERRIDE :: false
ZOHO_CREATE_TABLE :: true
ZOHO_ON_IMPORT_ERROR :: SETCOLUMNEMPTY
PROXYPORT ::
ZOHO_AUTO_IDENTIFY :: true
USEPROXY :: false
PROXYHOST ::
LINES_TO_SEND :: 10000
ZOHO_TRUNCATE_COLNAMES :: false
ZOHO_FILE_ENCODING :: UTF-8
2017/11/08 18:02:36 BRST:Database Properties
HOSTNAME :: VIX-DB-001
DBNAME :: MMDB
PORT :: 1433
USERNAME :: sa
DBTYPE :: sqlserver
2017/11/08 18:02:41 BRST:
Server Exception :: Banco de dados não encontrado! Verifique se o banco de dados existe.
2017/11/08 18:02:41 BRST:Troubleshooting Tips:
If you are a shared user and trying to upload into database owner's table, then please specify the DBOWNER_EMAIL_ADDRESS property in the file 'conf\common_params.conf' (or) pass the database owner email address from the command line arguments
If you require assistance to resolve the problem, please send a mail to '
support@zohoreports.com' by attaching the files 'conf/common_params.conf', and the logs folder as zip.
2017/11/08 18:02:41 BRST:
ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/
andre@milanezmilaneze.com.br/DBFinance2, Action: GETRELATEDTABLES, Message: Banco de dados não encontrado! Verifique se o banco de dados existe.)
at com.adventnet.zoho.client.report.BaseClient.sendRequest(BaseClient.java:144)
at com.adventnet.zoho.client.report.ReportClient.sendRequest(ReportClient.java:1869)
at com.adventnet.zoho.client.report.ReportClient.getRelatedTablesList(ReportClient.java:1121)
at com.adventnet.zoho.client.report.advancedtool.AdvancedUploader.generateRelatedTablesList(AdvancedUploader.java:829)
at com.adventnet.zoho.client.report.advancedtool.AdvancedUploader.startUpload(AdvancedUploader.java:360)
at com.adventnet.zoho.client.report.advancedtool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:49)