if you are using jdbc-odbc bridge, please check that you have specified the correct connection URL.
I think the URL is correct. Both in MySQL and Access, my java program can query the database. But when I using BMP to query the database, then it says TABLE NOT FOUND.
Really don't know what's going on....
i have a similar problem,
regarding the quering a database table using a BMP.
select field1, datefield from table1
(select max(datefield) from table1 where field1 = 'value')
and field1 = 'value'
my query look like the one above,
except those fieldname and values and tables which
are same as i have named it.
when i substitute some values to the value
and query the database it gives me single value
and that is the desired output
but my BMP give me a undesirable error
Error: TABLE NOT FOUND table1
what is the actuall error??
can any one explain that??
i want is very soon.