Hi,
When I parse this code:
Select name frome employees where name="smith"; in MS-access, the result is, obviously, a field with the name smith (if it exists)
However, when I use former mentioned query in the following line
ResultSet rs = stmt.executeQuery(query);
I get a 'too few parameters, expected 1" error. DSN and other stuff is good because query 'select name from employees;' works fine.
I try'd PreparedStatement as was told somewhere else in this group, but then I'll get 'Driver does not support this function'.
Using Visual Age for Java 3.5 on W2K and trying to access MS-access2k, standard sun's jdbc-odbc driver.
any help is welcome,
grtz,
Lex
When I parse this code:
Select name frome employees where name="smith"; in MS-access, the result is, obviously, a field with the name smith (if it exists)
However, when I use former mentioned query in the following line
ResultSet rs = stmt.executeQuery(query);
I get a 'too few parameters, expected 1" error. DSN and other stuff is good because query 'select name from employees;' works fine.
I try'd PreparedStatement as was told somewhere else in this group, but then I'll get 'Driver does not support this function'.
Using Visual Age for Java 3.5 on W2K and trying to access MS-access2k, standard sun's jdbc-odbc driver.
any help is welcome,
grtz,
Lex