Inserting values in a table with odbc

[Anon]

I am trying to insert values into a table using odbc, i have succesfully connected to the data base and when i send the SQL insert command everething seems to be allright, $result is a proper identifier, everything is just fine exept that the table remains without any change, nothing happens and i dont know why, i have tryed with '$col', $col and nothing happens. Here is the code:
$result = odbc_exec($db,"INSERT INTO TABLE (COL1, COL2, COL3) VALUES ('$col1', '$col2', '$col3')");
Pls Help me if you can.
Otto

[Anon]

What database are you using behind the ODBC interface? If it is a transactional database (i.e. Oracle) you may have to issue some form of COMMIT.

Brett

[Anon]

I am ussing ACCESS 2k but the commit thing could be the problem, would you tell me how to solve that?

[Anon]

Never used Acces... I'm afraind I can't help solve the problem completely. Any one out there have solution?

[Anon]

Ok i got the solution
i was using odbc_pconnect(.. blah, blah..);
i removed the 'p' to use odbc_connect and it worked... yeah!, that is great, but.. can someone tell me why this happened, what was wrong? odbc_pconnect is supose to do the same that odbc_connect but with just one call to the sql server, even more i am not using apache, i am using iis4, and the manual said that in any server but apache php works like a cgi wrapper, so in ii4 odbc_pconnect does the same that odbc_connect.
I would like to know more...
Otto

[Anon]

Interesting. It was my assumption that using PHP as a CGI on IIS meant odbc_pconnect was the same as odbc_connect (and likewise for other databases).

I've always used the non-p functions because of this and so have never had a similar problem

[Anon]

Because Access isn´t supporting P-Connects like Oracle or Access.

[Anon]

I meant like oracle or my-sql, sorry