When I use 'Distinct' clause in Oracle it works fine. But the same query doesn't work from VB. It displays all the record in the result.
eg.
Sql = "Select distinct name from emp"
Printable View
When I use 'Distinct' clause in Oracle it works fine. But the same query doesn't work from VB. It displays all the record in the result.
eg.
Sql = "Select distinct name from emp"
Using SQL Server, this works fine for me.
Perhaps you should check out the ODBC or OLE DB Provider driver installed on your machine.
Test this with a connection to SQL or Access using ADO. If it works this way around, you may want to re-install or upgrade MDAC on your machine