Source Configuration (AS/400 database)

by **rdejesus** on Mon Jun 05, 2006 11:20 am

Support Team:

I'm trying to connect to a AS/400 database using the iSeries Access ODBC Driver. How would I go about setting my connection parameters and/or my manual connection string. Or do I need to use a different driver to connect?

Thank you in advance,

-Rafael

by **Henrik Nordberg** on Mon Jun 05, 2006 12:12 pm

Hi,

Have you tried selecting your driver and entering the user, password, etc.?
If that does not work, what is the error message?

Only then should you look at using custom connection strings.
If you need to use a custom connection string, you should use the format that is in your documentation for the driver that you wish to use. If you cannot find it there, then you can have a look here: http://www.connectionstrings.com/
But please try connecting without using a custom connection string first.

Thanks
- Henrik

by **rdejesus** on Mon Jun 05, 2006 12:22 pm

Henrik

here is the error I get:

Remote exception: [IBM][iSeries Access ODBC Driver]Missing system name needed for connection.

Details:
Unable to connect to database using DSN SERVER=Ned;DRIVER=iSeries Access ODBC Driver;DATABASE=PKSTAGESPD;UID=DCOPUSER;PWD=<REMOVED>;!

SQL Errors:
(0) SQL Error! SQLSTATE = HY000 Native err = 30188 msg = [IBM][iSeries Access ODBC Driver]Missing system name needed for connection.

(1) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(2) SQL Error! SQLSTATE = IM006 Native err = 0 msg = [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

(3) SQL Error! SQLSTATE = HY000 Native err = 30188 msg = [IBM][iSeries Access ODBC Driver]Missing system name needed for connection.

Thanks,

-Rafael

by **Henrik Nordberg** on Mon Jun 05, 2006 12:53 pm

Ok, then you can test a custom connection string:
(From http://www.connectionstrings.com/)

* IBM Client Access ODBC driver:
"Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUserName;Pwd=myPwd"

Cheers
- Henrik

ps. Here is another site with connection strings: http://www.codeproject.com/database/con ... trings.asp

by **Henrik Nordberg** on Fri Jun 09, 2006 9:42 pm

Did you get it to work? If a specific connection string worked for you, please post it here so that others may benefit. (without the password, of course)

Thanks!
- Henrik

by **headjoog** on Fri Jul 07, 2006 5:01 pm

Although this thread is a bit dated, I did get my AS/400 connection working. I had to use the "DSN" option and manually build the connection string. I do seem to have some problems in the SELECT query though - it seems to want the fully qualified name in front of the table. That may be a result of my specific installation though...it's a bit cryptic setting it up, because a lot depends on the environment.

Regards,
Headjoog