simple mdac test [ 795 views ]
Goal: to show a simple way to test a data provider
The base problem is to check quickly the data provider we need. In this case this is an old odbc driver for a dbf database. Seemingly the simpliest way is this following:
First of all we need an installed excel, because we will use the excel database query feature.
Let’s create a simple text file named: test.dqy with the following:
XLODBC 1 Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\gykeres; SELECT * FROM gyardev
In this sample there is an old dbf database reader with the Microsoft dBASE Driver.
Doubleklick on the file and the excel will try to open the datasource as we specified.
If everything is ok, than we will see the data in the excel sheet, if not we will see the error message and we can react.