I guess that’s a behavior of the OLEDB provider that you are using. You can try a different provider, or an ODBC driver (in which case you’ll have to use the OdbcClient namespace).
If the above is not an option, execute:
SELECT * FROM <your_table>
And see if there is a column on which you can add a WHERE condition.
Zlatko
|