Kbase P4285: Can a specific version of SQL-92 client connects to a Database with minor version difference ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/01/2011 |
|
Status: Verified
GOAL:
Can a specific version of SQL-92 client connects to a Database with minor version difference ?
GOAL:
What are the SQL-92 client and server compatibility rules?
GOAL:
Can a SQL-92 client connect to SQL-92 server of a different version?
GOAL:
Can an ODBC client with newer driver version connect to older version Database?
GOAL:
Can a JDBC client connect to a SQL-92 server that is of different version?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
SQL-92 clients include ODBC, JDBC and ESQL/C, the connectivity rules described here apply to all three types of clients.
Because SQL-92 connections are established as client-server connections, Progress client-server version connectivity rules apply: if both the client and the server are of the same major releases, client can connect. Client can also connect to a Database server with 1 Major release prior
Note :
SQL-92 Client cannot connect to V8 Database because there is no SQL-92 engine in Version 8