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 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]