HELP

Haloo everyone, i have big problem, I am instaling OW XE win2000 DB2/UDB 7.2 just now. Im in install plan definition process and i have problems with connect to DB2 database when validating plane. Simply I can't connect to DB. All ODBCs are created, everything is tet up by the Installation manual and not working. The error is:

1508/1500 Thu Aug 08 20:49:55 2002 JDBODBC717
ODB0000045 - SQLDriverConnect failed. DSN: System - B7333

1508/1500 Thu Aug 08 20:49:55 2002 JDBODBC718
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified - SQLSTATE: IM002

The can somebady help immediately? I have to be runscripts trough night.

Thank you.

Martin.

Martin :

Open GH9011, Database Data Sources and check that your System - B7333 is
defined as UDB/2.
Also check that you're on a newer Service Pack level. Xe SP13 doesn't
support UDB/2.

Sebastian Sajaroff (JDELIST)

----------------------------------------------------------------------------
Strictly Personal and Confidential.
This email may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.Thanks.
.
Este mensaje es confidencial.
Puede contener informacion amparada por el secreto profesional. Si usted ha
recibido este e-mail por error, por favor comuniquenoslo inmediatamente via
e-mail y tenga la amabilidad de eliminarlo de su sistema; no debera copiar
el mensaje ni divulgar su contenido a ninguna persona. Muchas gracias.
----------------------------------------------------------------------------

Hi Martin-

I have seen this error before. The issue for me was that a System ODBC was needed so that all workstations could see the connection.

Based on the log, no ODBC drive is defined for the System - B7333 data source. (Because you are AS/400 you may even need a System - B7333 - DNT data souce defined--for better performance too). You should check to see if System - B7333 is defined and/or in need of correction.

Also, If you add a user ODBC, only the specific user will be able to see the ODBC definition. Confirm that when you created the ODBC that you created them as a system ODBC.

Either way, this only takes a few minutes to add or change.