ODBC to AS/400

zaker

Anyone have ever tryed to connect to an IBM AS/400 ?
I'm trying with no-success from an NT4 Server with Apache 1.3.19- php4.0.4pl2

I've created a system dsn with a "Client Access ODBC Driver (32-bit)", and it's properly configured (MS Access is able to use it! [Argh!] ).

I'm stuck in the very first instruction :
$con = odbc_connect ( $dsn , $user , $pwd )

The error says something like:
[IBM][Client access driver...][SQL DB2 AS/400]Error connecting ....

It seems that the Client Access ODBC Driver isn't able to understand the PHP Unified ODBC Driver language.

Thanks a lot to anyone will say his opinion about this situation.

dstockto

I have been wanting to do this for awhile so I decided to try it. I was able to get it to work after a bit of research, so my guess is there is probably just a set up problem. My guess would be with ODBC.

The first thing I would check is that the ODBC DSN is set up under System DSN, not User DSN. It won't work under User since PHP is running under some user that isn't you.

Another thing to check is that the subsystem on the AS/400 that allows ODBC connections is running. A way to check if it is on is to go to OPSNAV, log into the 400, go to the database menu, and right click and do "Run SQL Scripts...". Try a SQL select here on your AS/400. If this works then the AS/400 setup is probably ok and the ODBC setup needs to be examined.

Also make sure you are using the correct ODBC PHP calls. I've been using mysql up until a few minutes ago when I decided to try this out and I was automatically using the mysql APIs.

Let me know if you get it to work, or what errors you get if it won't work and I can probably help a little more.

Anon

Other things to check:

Important!!!! Be extremely sure the AS400 has enabled TCP/IP for the user you connect as (TCP/IP is disabled by default and has to be enabled on a user by user basis).
If you use NT, log in as Administrator and make sure you can perform queries with one DB tool (ie MS Query).
To have the thing working with no one logged in, you have to create System DSNs, and make sure that Client Access + PHP work as a particular user (to be created for this task) and that particular user has Client Access working for him (don't remember well since there have been passed months, but it should not work with the standard system account).

zaker

You are served!
Here is the error:

Warning: SQL error: [IBM][Programma di controllo ODBC Client Access (32 bit)][SQL DB2/400]Il collegamento di comunicazione ha avuto esito negativo. COMM RC=0x5, SQL state 08S01 in SQLConnect in d:\apache\mysite\search.php on line 17

Need translation:

[IBM][ODBC Client Access Control Program (32 bit)][SQL DB2/400]Communication link failed. COMM RC=0x5...

I've tryed "Run SQL Script" and it works.
I've surfed ibm site, and i've found expalnation about RC=0x5 error. There is CWBCFG.EXE (search it in Client Access Help) and something about "configuring IIS with Client Access ODBC" (still reading). I'll post news when possible. Many thanks for your help.

zaker

Everything works fine! (connection, simple SELECT query, show results in browser)

Guess the problem?
Wndows NT!. Yes, it works perfectly from a win98 system with Apache 1.3.14, PHP 4.0.3pl1. Now "digging" on NT security and Apache configuration as a service on NT. I think the focus is on how services are running (something like "Log on As:..." in service properties).

Still busy...
Bye.

Anon

Hi. Could you solve your problem with Windows NT?. I'm having the same problem, and I don't know how can I solve it. Can you help me?...

Oliver Bejarano
Barquisimeto, Venezuela

dstockto

yes, but you probably need to change the user you are running ODBC with in the services area. I got it to work with Windows 2000 and it should be able to run with NT as well. The other option is to give the ODBC@localhost more permissions so the stuff will run correctly. Hope this helps.

Dave

nightduke

http://dns.celleweb.de/db2/db2howto.eng.html
AS400 DB2 Linux PHP Connection howto

lteo8

I have a similar problem. I can't connect to the ODBC. I have an error message saying:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length, SQL state S1090 in SQLConnect in d:\htdocs\exchange2\search.php on line 4

Could anyone please help me?

Sincerely,
Letitia.

zaker

I had no time to find a solution with WinNT.
As i said before i've found a solution with
another OS, i used Win98se.
With this OS i managed to connect through ODBC (now with PHP 4.0.6 and Apache1.3.22) to the AS/400 database and i did not have hany other problem of any kind.

If u want some help u should be more precise

...\search.php on line 4 (?)

lteo8

I've created a system dsn with a "Client Access ODBC Driver (32-bit)", and it's properly configured (MS Access is able to use it! [Argh!] ).

I'm stuck in the very first instruction :
$con = odbc_connect ( $dsn , $user , $pwd )

The error says something like:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length, SQL state S1090 in SQLConnect in d:\htdocs\exchange2\search.php on line 4

It seems that the Client Access ODBC Driver isn't able to understand the PHP Unified ODBC Driver language.

Thanks in advance.

lteo8

I've created a system dsn with a "Client Access ODBC Driver (32-bit)", and it's properly configured (MS Access is able to use it! [Argh!] ).

I'm stuck in the very first instruction :
$con = odbc_connect ( $dsn , $user , $pwd )

The error says something like:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length, SQL state S1090 in SQLConnect in d:\htdocs\exchange2\search.php on line 4

It seems that the Client Access ODBC Driver isn't able to understand the PHP Unified ODBC Driver language.

right now, I'm using a Win2000. Does anyone know if it can work? Please let me know.

Thank you in advance for any help given.

Sincerely,
Letitia.

zaker

First: i'm not a PHP, as400, database guru...

Only some suggestions:
1. Search your error code with google, i've found a lot of hits also here at phpbuilder but in other forums
2. Update anything your can. Client Access ODBC Drivers, PHP version (last is 4.1.0)
3. Check carefully your strings. The error says "invalid string length (or buffer)". Does your $dsn string has spaces, back-slashes, quotes inside, or other strange chars, you know what i mean. Or simply empty or NULL strings ?
4. stay away from winbug2000...it's always NT family. Use the older, more tested win98se platform (for me the better, in these days).
i've seen other messages with request about the same problem, and they was on win2k! Do u have installed the last w2kspk?

good luck.

lteo8

Thank you so much for your help. I'll try what you've suggested.

Sincerely,
Letitia.