Kbase P5301: How to have version 8 and version 9 working on the same server using ODBC to connect to both Databas
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to have version 8 and version 9 working on the same server using ODBC to connect to both Databases.
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
CAUSE:
The problem is that in order to run ODBC for version 8 it is necessary to have some environmental variables set pointing to version 8.
If all the Progress environment variables are set pointing to version 8, then when trying to start a version 9 DB an error will appear because the variables are pointing to the wrong version.
FIX:
Only set 4 environmental variables and leave that Progress takes the other variables from the registry.
This four variables are PROOIDRV PROOIBRK IDLC and IPROMSGS.
This variables are the ones needed for SQL-89 (version 8), but as version 9 uses SQL-92 then they are not going to interfere with version 9.