Hello
I am getting the following message, I have obviliously done something wrong...please help!

"CGI Error
The Specified CGI application misbehaved by not returning a complete set of HTTP headers.  The header it did return are:"

I am running win2K sp3 and IIS 5

TIA

hi
i faced the same problem then i found out that the .exe file in the php folder has an error when i execute the file so all what you have to do is just bring another .exe file that execute the php code and replace and make sure that the file is not corapted.

I am running IIS on WinXP Pro and account used for anonymous access is IUSR_APPLE

1.
One issue I found was IUSR_APPLE not having write access to Forum.mdb
So I changed to have read, write, modify access


2.
Next issue was form variables are not automatically converted to php var.
I think this is a setting issue.
But I used a temp solution.
Added following statement in beginning of node.php


if(isset($node)) $node=0;
if(isset($_GET[node])) $node=$_GET[node];
if(isset($_POST[node])) $node=$_POST[node];


and changed sql insert statement to

  $sql = "insert into forum  (parentcode,title,description,uname,email) "
       . " VALUES   ($node,'$_POST[title]', '$_POST[description]',"
       . "'$_POST[postname]','$_POST[email]')";

  $resultupdate=odbc_exec($connect, $sql );



3.
Last issue, if email field is blank it created problem
so I changed setting in Access to allow zero length value
for all text fields and defaulted to ''
(I did not mind blank fields)

Get documentation at
http://www.mysql.com/doc/en/CREATE_TABLE.html

install ODBC for MySQL
then create a ODBC connection to mysql with name "forum"

then create a table with

CREATE TABLE  forum
(
code  INTEGER AUTO_INCREMENT,
parentcode INTEGER NOT NULL DEFAULT 0,
title  VARCHAR(50) NOT NULL DEFAULT '',
uname  VARCHAR(50) NOT NULL DEFAULT '',
email  VARCHAR(50) NOT NULL DEFAULT '',
description TEXT DEFAULT ''
)

then you should use the right user name / password while connnecting
thats it

It works fine for me in MS-SQL

i got the following error when i was trying to run the "forum.php"

Warning: odbc_connect(): SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\forum.php on line 3
Discussion Forum using PHP/Access under IIS


advice needed urgently!!!

thanks

i'm getting this error messagewen i go to node.php Notice: Undefined variable: node in C:\IS_Intranet\node.php on line 15

To Solve this Simply Remove the Exclamation mark So it looks like this ($node=0)

Remove the exclamation mark (!) so it looks like ($node= 0)

this is the error i got from my forum page

Discussion Forum using PHP/Access under IIS

Post New Message
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'forum'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in c:\Inetpub\wwwroot\Forum.php on line 20


Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\Inetpub\wwwroot\Forum.php on line 22


this is the error i got from the node page

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'forum'., SQL state S0002 in SQLExecDirect in c:\Inetpub\wwwroot\node.php on line 8

Warning: Cannot modify header information - headers already sent by (output started at c:\Inetpub\wwwroot\node.php:8) in c:\Inetpub\wwwroot\node.php on line 9



can someone help me

hello,

Friends please help me Can I compile php with mysql without having mysql sources?

Thanks
Laxy
www.funspot.com

I had the same problem I have removed the ! and the error has gone but I still cannot create any new posts


any ideas?

ok removing the ! fixed the error message but I was having another problem as well as this that is still there......I cannot make any posts BIG PROBLEM lol


any ideas?

i've tried your forum tutotial but i get this error read when i try and access the page:

Warning: odbc_connect() [function.odbc-connect]: SQL error: , SQL state 00000 in SQLConnect in c:\Inetpub\wwwroot\worstmetteamever\forum\index.php on line 3
Discussion Forum using PHP/Access under IIS

Post New Message
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\Inetpub\wwwroot\worstmetteamever\forum\index.php on line 20


Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\Inetpub\wwwroot\worstmetteamever\forum\index.php on line 22

i had previously installed php w/ iis and i think i need to wipe php off my system and start over again.  what files did i need to erase  besides going to add/remove programs?

thanks for any help!

Hi,

   This is Ravi from India.  I am new to PHP. My issue is " I am unable to insert information into Access, which has been passed from another php file form.  I used many options like "$empno" , ' ".$empno." '  ,    '$empno'  and    $empno  in Insert statement  where empno is a textfield name.  Please specify how to gather 'string'and number variables.

   I tried the example of node.php and forum.php   but i have the same problem.    Any help is greatly appreciated.


Thank you.