Visual FoxPro Single-Tier JDBC-ODBC Bridge 32-BIT v.7

Data Access Drivers & Connectors OLE DB Connectivity
3

Thanks and Kudos to you that finally I’m able to make the connection and successfully ran an insert sql statement.
Next, I’m trying to ran a VFP9 stored procedure called ‘getregions()’ . It has no input parameter, and should return the word ‘Success’. Using CallableStatement I tried various syntax, like :

calledStmnt = connection.prepareCall(“{call getregions()}”); or
calledStmnt = connection.prepareCall(“{? = call getregions()}”);

However I get error:
java.sql.SQLException: [OpenLink][OPLJDBC4][ODBC Server][Microsoft][ODBC Visual FoxPro Driver]Syntax error or access violation
at openlink.jdbc4.OPLMessage.makeException(Unknown Source)
at openlink.jdbc4.OPLPreparedStatement.(Unknown Source)
at openlink.jdbc4.OPLCallableStatement.(Unknown Source)
at openlink.jdbc4.OPLConnection.prepareCall(Unknown Source)