We support a Powerbuilder 6.5.1 application that is connected to an Oracle database. We have been tasked to make a minor change to a datawindow data source and are having some problems.
When establishing a connection to the db in powerbuilder the following message appears:
"Catalog tables could not be created and are not available for use"
When viewing the data source for the window the following appears:
"Could not reconstruct the statement graphically. Do you want to continue in graphic mode? yes no"
Yes keeps you in graphic mode with not query definitions. No moves you to the SQL statement. Upon exiting the SQL statement with or without making changes the following error is shown.
"SQLSTATE=37000 [oracle][odbc] Syntax error or access violation. Do you want to correct errors?"
The executable uses this query in production with no problem. With the errors I am sure it is some ODBC problem has anybody seen this problem?
When establishing a connection to the db in powerbuilder the following message appears:
"Catalog tables could not be created and are not available for use"
When viewing the data source for the window the following appears:
"Could not reconstruct the statement graphically. Do you want to continue in graphic mode? yes no"
Yes keeps you in graphic mode with not query definitions. No moves you to the SQL statement. Upon exiting the SQL statement with or without making changes the following error is shown.
"SQLSTATE=37000 [oracle][odbc] Syntax error or access violation. Do you want to correct errors?"
The executable uses this query in production with no problem. With the errors I am sure it is some ODBC problem has anybody seen this problem?