hi
im tryin to store my html form data in a db2 database thru a php script. i successfully connected the php script to db2 using the ibm odbc driver functions. when i compile the php in my zend environment its able to insert data in my database table, but wen i send data frm my html form to the php script to store data it says "500 internal error".. i m using apache2 server in windows xp environment... its a localhost server actually! pls help!


cheers

one more thing i wanted to mention was tat the error occured only wen i used odbc functions like odbc_connect, etc..
here is the php code:
<?php
// connect to the database
$conn = odbc_connect('vcs', 'db2admin', 'db2admin');
$username=$_POST["username"];
$password=$_POST["password"]
// define our SQL
$sql = "INSERT INTO login" .
"(USER_NAME, PASSWORD,)" .
"VALUES('$name', '$password')";


// issue our SQL statement directly
odbc_exec($conn, $sql);

// close the database connection
odbc_close($conn);
echo "Insertion into the database is complete!"
?>

Don't use the ODBC PHP driver, it is buggy. You may want to give the "ibm_db2" driver a try.

i hav been searchin for the ibm_db2 driver but i cant find it.. pls tel me where to get it and how to use it wit my zend studio.. pls pls! i cant find the headers or the library files for the ibm_db2 driver

cheers

http://www.php.net/ibm_db2

hey mate thanks for the link.. but cud u tel me wat to download at the link u gave me.. the db2 app development client, or jus the IBM Data
Server Driver for ODBC, CLI, and .NET available at ftp://ftp.software.ibm.com/ps/produc...es2/englsh-us/


And cud u tel me wat these PECL extensions are? Are they to do anytin with the db2 functions?

thanks

Sorry, I don't understand your question. You can install ibm_db2 with the regular PHP mechanisms like PECL.

i m jus gettin confused actually.. now to get my db2functions workin.. i need only db2 app development client and pecl extension rite?

I don't find that surprising. I guess you'll have to wait until somebody translates the manual into that "language" of yours...

the pecl extension i got for ibm_db2 doesnt work wit my zend studio.. wat gives?

hey i checked the server error log.. it says:
"PHP Fatal error: Call to undefined function odbc_connect() in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 5"

is it bcoz my server is not config properly or any other stuff?

You are using the ODBC functions. If you have a look at the link I provided, you will find that the functions in ibm_db2 all start with the prefix "db2_".

Also, regarding your installation question I point you again to that link. There is a section "Installing/Configuring". Do the usual RTFM first and then come back with specific questions and the accompanying information on what you tried, what is going wrong and also some details on your environment.

so yeah i got PECL extension for windows. They were dlls and i placed them in the extension directory as given in the manual and added the line of code in the php.ini file. even so i m gettin undefined functions wen i use db2_connect() or other similar funcs. like i said my php development environment is zend studio 5.5.1..

hey im able to use my odbc functions now.. but im gettin a error like this:


PHP Warning: odbc_connect() [<a href='function.odbc-connect'>function.odbc-connect</a>]: SQL error: Specified driver could not be loaded due to system error 127 (IBM DB2 ODBC DRIVER - DB2COPY1)., SQL state IM003 in SQLConnect in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 5
PHP Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 17
PHP Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 20
PHP Warning: odbc_connect() [<a href='function.odbc-connect'>function.odbc-connect</a>]: SQL error: Specified driver could not be loaded due to system error 127 (IBM DB2 ODBC DRIVER - DB2COPY1)., SQL state IM003 in SQLConnect in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 5
PHP Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 17
PHP Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 20
PHP Warning: odbc_connect() [<a href='function.odbc-connect'>function.odbc-connect</a>]: SQL error: Specified driver could not be loaded due to system error 127 (IBM DB2 ODBC DRIVER - DB2COPY1)., SQL state IM003 in SQLConnect in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 5
PHP Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 18
PHP Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 21
PHP Warning: odbc_connect() [<a href='function.odbc-connect'>function.odbc-connect</a>]: SQL error: Specified driver could not be loaded due to system error 127 (IBM DB2 ODBC DRIVER - DB2COPY1)., SQL state IM003 in SQLConnect in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 5
PHP Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 18
PHP Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\Program Files\Zend\Apache2\htdocs\db2_login.php on line 21




how to rectify to the link between the server and the db2
its a zend core apache server

You are still using the ODBC driver and not ibm_db2. Without any further details on the code and the exact error messages, it's impossible to help you with this.