[PHP] Re: [PHP-DB] Connect to IBM DB2

[Frank M. Kromann]

Hi,

IBM DB/2 uses Call Level Interface (CLI) for communication between clients and server. 
The ODBC driver from IBM is a simple one to one wrapper arround CLI, as CLI and ODBC 
share the same specifications.

Using ODBC will give you an extra layer though. On *nix platforms you can compile usen 
--with-ibm-db2 and get the ODBC functions linked directly with CLI. This is not 
currently available on Windows.

- Frank

> To connect to Microsoft SQL 7 I'm using the following script which works
> fine:
> 
>  $query="SELECT * FROM DB1";
> $queryupd="UPDATE DB1 SET dateval='20010101' where dateval='2101'";
> $hostname = "dbserver";
> $username = "username";
> $password = "pwd";
> $dbName = "DB";
> mssql_connect($hostname,$username,$password) or die("DATABASE FAILED TO
> RESPOND.");
> mssql_select_db($dbName) or DIE("Table unavailable");
> $result2 = MSSQL_QUERY($queryupd); // Execute Update Statment
> $result = MSSQL_QUERY($query);  // Execute Select Statment
> $number = MSSQL_NUM_ROWS($result);
> $i=0;
>  if($number == 0) print "No data?";
>  elseif($number > 0){
>  print "Number of rows: $number";
> while($i < $number){
>  $dateval = mssql_result($result,$i,"dateval");
> echo "$dateval";
>  $i++;}
> }
> ?>
> 
> Now, how to connect to a DB2 database server without ODBC ?
> 
> My config is:
> Web Server: IIS on windows 2000 Server
> Database Server: IBM DB2 V7.1 on windows 2000 Server
> PHP4 for windows
> 
> Thanks.
> 
> Jerry
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] db connect

[Ian]

Hello,

Wonder if anyone can help me out.

I am trying to run an example out of a book Beginning Php by wrox.

One of the examples is supposed to allow me to connect to a database by
using a function that takes a database as an argument. It has an include
file that contains the function.

Problem I get is that the argument never seems to get passed and the
function always uses the default value.

I would greatly appreciate if someone could tell me why this happens. I
would also appreciate if no one rewrites a completely different script, as I
am after debugging this one. ;-)

Here is the include file:



And here is the php script that uses this include file:



 ";
}
?>


I hope someone can help me out please.

Thankyou.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]