RangerMSP Business Automation for successful ITs


Go Back   RangerMSP Forums > RangerMSP Software Discussion Forum (CCRM)

Thread Tools Search this Thread
 
November 7th, 2018, 12:15 PM
Lampson_sec
 
Posts: 39
I am trying to connect to the CommitCRM DB using a JDBC connection.

The Advantage JDBC driver is loading properly, because in the error message I'm getting a login failure.

When connecting via ODBC (from SQL Server for example) There is no username, as we use file share/permissions and not a username. Any idea on how to make this work?

I'm using Neo4J to connect, here's my query example:
CALL apoc.load.driver("com.extendedsystems.jdbc.advanta ge.ADSDriver")
call apoc.load.jdbc('jdbc:extendedsystems:advantage://commitcrm:6262;catalog=//CommitCRM/Db;','select * from BContracts') YIELD row
return row

And here's the error message being returned:
Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.load.jdbc`: Caused by: com.extendedsystems.jdbc.advantage.ADSException: [iAnywhere Solutions][Advantage JDBC]Login failed.

Any help would be appreciated!
 
November 7th, 2018, 01:38 PM
Support Team
 
Posts: 7,514
Thank you for posting this.
Nope, no idea here and JDBC is not something that we are familiar with, unlike ODBC.
In any case, if you can share more about the different connections settings you have maybe we will be able to detect something that isn't configured correctly. Hope this helps.
Reply





All times are GMT -6. The time now is 11:20 PM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.