Kbase P104525: Progress SQL-92 functions don't work with OpenLink ODBC driver.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2009 |
|
Status: Verified
SYMPTOM(s):
Progress SQL-92 functions don't work with OpenLink ODBC driver.
Functions like TO-DATE and TO-TIME don't work.
FACT(s) (Environment):
OpenLink 5.2 ODBC driver
Progress 9.x
All Supported Operating Systems
CAUSE:
With OpenLink, there are two Server Side components and a Client Side component. The two server side components are:
Request Broker
Database Agent
The Database Agent is where the problem is. When configuring OpenLink, you need to select the appropriate Database Agent for your database. With the Progress database there is the option of selecting either an SQL-89 Agent or a SQL-92 Agent. These are shown in the list as:
generic_pro91d Default settings for Progress 9.1D agent
generic_pro91sql Default settings for Progress 9.1x (SQL-92) agent
The first one is a SQL-89 agent and the second is a SQL-92 agent. If you have accidentally selected the SQL-89 agent then you will not have access to many of the functions that are available in SQL-92.
FIX:
Use the OpenLink Admin Assistant to select and configure the correct Database Agent.
Note that SQL-92 requires security to be defined within the Progress database whereas SQL-89 does not require security. Knowledge Center solution 20143 can assist with understanding how to define basic SQL-92 security.