MATLAB: Do I get an error “Too few Parameters. Expected 2” when I run a query in the Database Toolbox 3.5.1 (R2009a)

characterscolumndatabaseDatabase Toolboxerrorfewparametersqueryselectspecialtoo

When I execute the following query

SELECT ALL column-name FROM tablename

I obtain the following error:

 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

However, I am able to run the same query on other columns of the same table in the database.

Best Answer

This error is obtained because the column names being selected have special characters. If there are special characters in the column names of the database, the name should be surrounded with brackets in the SQL query. The query should be executed as shown below:

SELECT ALL [column-name] FROM tablename

Related Solutions

MATLAB: Do I receive an error regarding “Too Few Parameters” when using the Database Toolbox 3.5.1 (R2009a) to work with an MS Access database

This error message is returned by the ODBC driver for the MS Access database. It indicates that the column you are trying to access in the table does not exist. Additional information regarding this error message may be found at the following location:

https://support.microsoft.com/en-us/help/867225/-microsoft-odbc-text-driver-too-few-parameters--expected-1

You may also receive this error message when using double quotes instead of single quotes in a WHERE clause. For example:

Incorrect SQL statement:

SELECT * FROM myTable WHERE myField="Hello World"

Correct SQL statement:

SELECT * FROM myTable WHERE myField='Hello World'

MATLAB: How to work with an Oracle SQL function which returns a REF CURSOR in Database Toolbox 3.5.1 (R2009a)

To execute the stored procedure use the EXEC function:

result = exec(conn,'SELECT my_package.my_function FROM myTable');

Then you may parse the value manually by working with the Java objects:

%%Get the java object
res = result.ResultSet;
res.next;
res = res.getObject(1);
%%Get the data from the Java object
i=1;
while res.next == 1 % For all rows
      x{i,1}=res.getObject(1); % Get data from 1st column
      x{i,2}=res.getObject(2); % Get data from 2nd column
     % etc
      i = i + 1;
end

Best Answer

Related Solutions

MATLAB: Do I receive an error regarding “Too Few Parameters” when using the Database Toolbox 3.5.1 (R2009a) to work with an MS Access database

MATLAB: How to work with an Oracle SQL function which returns a REF CURSOR in Database Toolbox 3.5.1 (R2009a)

Related Question