Distinct clause

[deepak_r_patel]

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"

[wbeetge]

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