Pervasive SQL 11 Connection Problems on Servoy 7.4.1 Rel 202

Questions and answers regarding general SQL and backend databases

Pervasive SQL 11 Connection Problems on Servoy 7.4.1 Rel 202

Postby Chuck.Amata » Tue Aug 12, 2014 8:38 pm

When trying to establish and debug connections to a pervasive SQL 11 database using Servoy 7.4.1 Releease 2028 developer running on OSX Mavericks, the following error occurs:

An internal error occurred during: "Loading servers/tables needed by current solution".com/pervasive/pscs/Manager

The definition that gets saved in the server.properties file is as follows:

server.7.URL=jdbc\:pervasive\://cpt-app.internal.cptechnologies.local\:1583/CPTJAVA?transport-\=tcp
server.7.catalog=<none>
server.7.connectionValidationType=0
server.7.driver=com.pervasive.jdbc.v2.Driver
server.7.enabled=true
server.7.maxConnectionsActive=30
server.7.maxConnectionsIdle=10
server.7.maxPreparedStatementsIdle=100
server.7.password=encrypted\:M5X/mmP2pAxLAfPInt6rjw\=\=
server.7.schema=<none>
server.7.serverName=pervasive
server.7.skipSysTables=false
server.7.userName=CPTECHNOLOGIES\\Administrator

When this server is enabled, the error occurs and the postgres solution databases do not load. If the database is not enabled, the postegres databases load fine and are available to the developer. Please note that this database loads and opens fine on the application server using the same credentials and JDBC files in the application server drivers directory.
Chuck.Amata
 
Posts: 50
Joined: Sun Oct 04, 2009 8:02 pm
Location: USA

Re: Pervasive SQL 11 Connection Problems on Servoy 7.4.1 Rel

Postby jcompagner » Tue Aug 26, 2014 10:39 am

what is the full error that you see in the log
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 2 guests