Re: Still trying to access iSeries database with PHP

On Mon, 2004-08-23 at 16:37, Kelly Cookson wrote:
> <?php
>   //Define the connection to the database.
>   $odbc =
> odbc_connect("mysystem","myusername","mypassword") or
> die("Couldn't define connection");
>   //Define the library and file name.
>   $libname = "MYLIB";
>   $filename = "MYFILE";
>   //Get the info.
>   $res400 = odbc_columns($conn_ODBC, "mysystem",
> $libname, $filename, "%") or die(odbc_errormsg());
>   //Display results.
>   echo odbc_result_all($res400);
> ?> 
> 
> The script fails on the attempt to assign $res400. 
> The message from odbc_errormsg() reads as follows: 
> 
> Warning: odbc_columns(): supplied argument is not a
> valid ODBC-Link resource in
> c:\apacheserver\Apache\htdocs\php\iseries1.php on line
> 14

"$odbc" is the variable name for your connection, but you are sending
"$conn_ODBC".  It is sometimes hard to see this stuff in a loosely typed
language like PHP.

Joel
http://www.rpgnext.com