ODBC to AS400 test connection failed

285 pts.
Tags:
AS/400
AS/400 testing
ODBC
OLE DB
Hi,
Im trying to connect to as400 by simply using [B style="font-style: italic;">Microsoft OLE DB provider for ODBC drivers. In the specify source data i placed the IP address or my as400 then the user ID and password, but when i tried Test Connection the error is general security error. 


Software/Hardware used:
as400, odbc

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Craig Hatmaker
    Here is a link to Microsoft OLDEDB provider for DB2 connection strings Perhaps that has what you are looking for. I don't use that method so I'm not posting this in the "Answer" section. But this might be of use to you. Here is the connection string that has always worked for me: DRIVER={Client Access ODBC Driver (32-bit)};SYSTEM=###.###.###.###;DBQ=*USRLIBL;NAM=1;CONNTYPE=0; TRANSLATE =1; Where ###.###.###.### = the IP address of your iSeries This connection string uses the iSeries naming convention of lib/file NOT SQL's convention of lib.file This connection string requires the user to login under their own User ID the first time they try to establish a connection to the iSeries (in general, I don't like putting User IDs and Passwords in connection strings since it exposes that information. So for general inquiry only use, I require the user login with their own ID and let the iSeries user security determine what they have access to). Here is a VBA (in Excel) example: Using ADO to Read a Database. If you set "sConnect" to the above connection string and "sSQL" to a valid DB2 SQL statement, this routine will return the results in a string. Here is an example of calling that link's SQLRead function from VBA's immediate window:
    debug.print SQLRead("Select * From QGPL/myTable", "DRIVER={Client Access ODBC Driver (32-bit)};SYSTEM=10.0.0.3;DBQ=*USRLIBL;NAM=1;CONNTYPE=0; TRANSLATE =1;")
    1,775 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following