Therefore, ff the client wants to use the Excel Add-In, Progress OpenEdge ODBC drivers must be additionally installed. The Excel Add-In uses Progress OpenEdge ODBC drivers to connect to the Exact Financials database.
You need to click “Show advanced properties” to find the connection’s Validation Query, not the driver’s validation query! The problem (in our case) was that I still kept getting the same “Syntax error in SQL statement at or about " 1” (10713)" error even though I changed the Driver Validation Query, I needed to also change the Connection Validation Query (in the Ignition Gateway).When using the WebClient, Progress OpenEdge ODBC drivers are not installed on the client pc. This setting is hidden in the Databases -> Connections window on the Ignition gateway. The solution for me ended up being the validation script that is associated with the connection, not the driver. When you create the Progress driver in the Ignition Gateway initially and have “SELECT 1” as the validation query, it will carry over into any database connection you create with that driver.Īs far as I know, “SELECT 1” throws an error, so the validation test fails (I ran it in Postman and got an error from Progress).
: Syntax error in SQL statement at or about " 1" (10713)Ĭom.OpenEdgeClientRequest.prepareProcessReply(Unknown Source).(Unknown Source).OpenEdgeImplStatement.prepare(Unknown Source).OpenEdgeImplStatement.execute(Unknown Source).monExecute(Unknown Source).BaseStatement.executeQueryInternal(Unknown Source).BaseStatement.executeQuery(Unknown Source).DelegatingStatement.executeQuery(DelegatingStatement.java:208).PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:332).BasicDataSource.validateConnectionFactory(BasicDataSource.java:1249).BasicDataSource.createDataSource(BasicDataSource.java:1221).BasicDataSource.getConnection(BasicDataSource.java:880).(DatasourceImpl.java:189).(DatasourceImpl.java:145).datasource.DatasourceManagerImpl$n(DatasourceManagerImpl.java:1117)(Unknown Source)ĭoes anyone have any suggestions on where I am going wrong? Thanks in advance for all your help.įor anyone else facing this issue, there is an alternate solution (without adding a new Progress driver). BasicDataSource.createDataSource(BasicDataSource.java:1225).BasicDataSource.getConnection(BasicDataSource.java:880).(DatasourceImpl.java:189).(DatasourceImpl.java:145).datasource.DatasourceManagerImpl$n(DatasourceManagerImpl.java:1117)(Unknown Source) SQLNestedException: Cannot create PoolableConnectionFactory ( Syntax error in SQL statement at or about " 1" (10713)) However I am unable to connect to the progress database when I use this driver. I have just added a new Progress Database driver (JDBC driver Progress 10.1.C) in Ignition.
0 kommentar(er)
