Code: Select all
"DRIVER={Devart ODBC Driver for xBase};Database=C:\\Data\\;DBFFormat=VisualFoxPro"
Code: Select all
SELECT A.VendorId, A.Code, A.Name
FROM Vendors as A
ORDER BY A.VendorId asc
Code: Select all
SELECT TOP 5 A.VendorId, A.Code, A.Name
FROM Vendors as A
ORDER BY A.VendorId asc
If I use a VFPOLEDB connection the query works fine.
I have also created a system DSN pointing to the same database (using the same driver) and added a linked server in SSMS. The Query works as expected there as well.
If it's directly related to the driver, why does it work in SSMS but not in the API? I know there are limitations, such as not being able to access the long column names (stored in the dbc), which are available in VFPOLEDB. But TOP does work for SSMS. Maybe SSMS is applying the TOP after it has received the query results from the linked server? I'm not sure.
I was wanting to know if anyone has encountered this or similar limitations, and if they have found a solution?