PHP+MS Access 2000

[Anon]

• I got problems when I try insert data to MS Access 2000 -database. SQL string was:
  INSERT INTO TBL_L3 (HOST, NID, NAME) VALUES (2,'2TESTNAME','TESTNAME');

• I got error with that. Then I tried this SQL string:
  INSERT INTO TBL_L3 (HOST, NID, NAME) VALUES (2, "2TESTNAME", "TESTNAME");

• PHP writes this error:
  Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecute in odbc_lib.inc on line 85

• Code that caused error:
  $stmt = odbc_prepare($this->con_nek,$this->sqlstatement);
  $apu = odbc_execute($stmt); / line 85 /

• I guess that PHP or Access needs some parameters. What are these parameters? Can somebody help me?

[Anon]

whenever you are using sql query in php,
do not add the semicolon ';' at the end of
the string.

try the query without any semicolons tailing.

Toni Tunkkari wrote:

• I got problems when I try insert data to MS Access 2000 -database. SQL string was:

  INSERT INTO TBL_L3 (HOST, NID, NAME) VALUES (2,'2TESTNAME','TESTNAME');

• I got error with that. Then I tried this SQL string:
  INSERT INTO TBL_L3 (HOST, NID, NAME) VALUES (2, "2TESTNAME", "TESTNAME");

• PHP writes this error:
  Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecute in odbc_lib.inc on line 85

• Code that caused error:
  $stmt = odbc_prepare($this->con_nek,$this->sqlstatement);
  $apu = odbc_execute($stmt); / line 85 /

• I guess that PHP or Access needs some parameters. What are these parameters? Can somebody help me?

[Anon]

I got same error when I use sql query without this semicolon:

SQL Query:
INSERT INTO TBL_L2 (HOST, NID, NAME) VALUES (1, "1Testname", "Testname")

Error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecute in odbc_lib.inc on line 85

[Anon]

This usually means that a database fieldname isn't recognized. Double check your sql statement and make sure everything is spelled correctly.

[Anon]

Isthe field HOST uppercase AND an integer in the database?

[Anon]

Toni Tunkkari wrote:

I got same error when I use sql query without this semicolon:

SQL Query:
INSERT INTO TBL_L2 (HOST, NID, NAME) VALUES (1, "1Testname", "Testname")

if too few parameters are met, try
string values 1Testname, Testname surrounded
with single quotation marks as:

(1, '1Testname','Testname')

also, check whether HOST column accepts
integer types

Error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecute in odbc_lib.inc on line 85

[Anon]

Here is table definition:

HOST Long Integer, indexed, duplicate values.
NID Text, indexed, unique values.
NAME Text.

[Anon]

Hello,
I've similar problem as I used PHP variable in the odbc_exec statement as below:

odbc_exec( $cnx, "SELECT DISTINCT Catagory_L2.Level2_Name
FROM Catagory_L1 RIGHT JOIN Catagory_L2 ON Catagory_L1.Level1_No = Catagory_L2.Level1_No
WHERE (Catagory_L1.Level1_Name=$select_lv1);");

and had an error msg like this:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in c:\php40\test\

Can anyone give me some hints about this error msg?!
THX!!!

[Anon]

Hello,

What version of PHP U are using?
Might be the problems caused by PHP 4.0 Beta version?