ODBC Connection

[Guest]

Hello,

I have an Access database that connects with an AS400 application via ODBC.
A lot of times, I get a connection failure error message when I try to obtain
the information from AS400 application via ODBC in my Access database. Does
anyone know what I should do in my Access database to prevent the connection
failure?

Thanks.

 

[Mike Labosh]

I have an Access database that connects with an AS400 application via
ODBC.

A lot of times, I get a connection failure error message when I try to obtain
the information from AS400 application via ODBC in my Access database. Does
anyone know what I should do in my Access database to prevent the connection
failure?

What is the text of the error message?
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

 

[Guest]

The error message was "ODBC--connection to 'EAG1S2' failed". EAG1S2 is an
AS400 application. Thanks.

 

[Mike Labosh]

The error message was "ODBC--connection to 'EAG1S2' failed". EAG1S2 is an

AS400 application. Thanks.

1. I'll assume that EAG1S2 has already been configured correctly to listen
for incoming ODBC connections.

2. Double-check your ODBC DSN or Connect String to make sure that it is
correctly specified, and that any login credentials are correctly spelled.
For example, if I login to my computer as MLabosh (Local account), that's
not neccesarily the same as loging into CORPORATE_NETWORK\MLabosh (Active
Directory Account)

3. Experiment with higher connection timeout values. In our crappy clogged
up network, everyone hates SQL Server Enterprise Manager because it keeps
timing out talking to the server.

4. It might also be worth sending an email to whoever is in charge of EAG1S2
or whoever is in charge of the AS/400. They might have some specific
advice, or be able to check event logs on it that might contain some hints.
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~