unable to select as no database found, Got error when select from database Options

[astroboy]

Hi all. I have got problems.
I am not sure what the error means.

I am querying for a long list of serial numbers(distinct) based on the limit and date by dsecending order.

CODE

select t1.SN, t1.Batch, t1.Date from tester as t1
join (
select SN, max(Date) as maxdate from tester where Batch = "UPS BC-6NX0-30A-1" group by SN
) as t2 on t1.SN = t2.SN and
t1.Date = t2.maxdate order by t2.maxdate desc limit 25;

I got the error as below "

CODE

Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]No database selected.  in ADOTool_ADO API.vi->ADOTool_Select Data.vi->test_usingSQL_ADO.vi

"

Any idea about this error?

When I tried using the same syntax in mySQL command line client and it works correctly

How?

regards
Clement

Attached File(s)

 test_usingSQL_ADO.vi ( 32.35K ) Number of downloads: 406

 

[CB]

I do not have much experience with the ADO-Tool and mySQL, but can it be, that you have not selected a database in the System- / File-DSN you are using? Maybe you have to add a statement like "use myDatabaseName" onec before sendig select statements?