I am writing a program to convert a dBase III system to MS SQL-Server. I am using VB6 and ODBC DSNs to connect to the two systems. The following command works with the SQL-Server system, but not with the DBase III system:

Select count(Distinct VENDOR) from Vendors
I get the dreaded "Syntax Error (missing operator) in query expression 'count(Distinct VENDOR)'. Number 3075" error when running this command against the dBase III table.

If I change the command to "Select Distinct VENDOR from Vendors" it works, but the recordset shows "-1" for the recordcount value, and I want to include a percentage bar to show progress (hence, the need for a record count).

Any ideas?