Consultor Eletrônico



Kbase P125496: ODBC driver is not available after installing SQL Client Access
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/08/2007
Status: Unverified

FACT(s) (Environment):

OpenEdge 10.x
Windows

SYMPTOM(s):

Progress OpenEdge 10.x ODBC driver is not listed in ODBC Data Source Administrator Driver tab

ODBC .DLLs (pgoe1022.dll, pgoe1022r.dll, etc.) are not present in DLC\Bin

SQL Client Access product has been installed

Custom installation option was selected

ProCfg101x.log from ProInventory utility contains:

[Installed Products]
ProductCount=1
Product 129=OE SQL Client Access (1 USERS)

[Product 129]
_Component_Common Files (m)=1
__SubComponent_Common Files (m)=1
__SubComponent_WebSpeed Common (m)=1
_Component_Name Server (m)=1
_Component_OpenEdge SQL ODBC Clients=0
__SubComponent_SQL Common (m)=0
__SubComponent_SQL ODBC Client (m)=0
__SubComponent_SQL Server (m)=0
__SubComponent_Database Tools (m)=0
__SubComponent_ICU PSC (m)=0
_Component_OpenEdge SQL JDBC Clients=0
__SubComponent_SQL JDBC Client (m)=0
_Component_OpenEdge ESQL/C Clients=0
__SubComponent_ESQL Client (m)=0
_Component_Secure Clients (m)=1
__SubComponent_Client-Side Security (r)=1
__SubComponent_Perl (m)=1
__SubComponent_Security Common (m)=1

CAUSE:

Custom installation was selected but the Component dialog was not. The product Components are not selected by default so when the installation continued only the Common Files and Secure Clients components were installed.
The 3 optional client components were excluded:

_Component_OpenEdge SQL ODBC Clients=0
_Component_OpenEdge SQL JDBC Clients=0
_Component_OpenEdge ESQL/C Clients=0

FIX:

Option #1
Reinstall SQL Client Access, select Custom installation and access the Component... dialog, available via a button on the Product List screen. Select the desired components from the list and complete the installation.

Option #2
Reinstall SQL Client Access, select Complete installation. All components will be installed.

Option #3
Use the Add Component option available from the OpenEdge folder in the start menu and select the desired components from the list.