OleDbDataAdapter.Fill() unspecified error

[Jon Prisbe]

I have the following code:

OleDbConnection conn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\FSL\xref.mdb");

String sql;

sql = "SELECT STYLENO, STYLEDESCR FROM Symbols WHERE ((VIRTUALCATALOG='TSA')
AND (.CATALOG='SCP') AND (.SYMBOLNAME='DKL24')) Symbols.ORDER BY STYLENO";


OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(sql,conn);

DataSet myDataSet = new DataSet("Symbols");

myDataAdapter.Fill(myDataSet,"Symbols");



Everytime I run the code I get and OleDbException - unspecified exception
E_FAIL.

If I modify the sql stmt to remove the where clause it works.

If I remove the last two AND clauses it works.

I am using C# and VuisualStudio.NET 2002.



Any ideas?

Thanks,

Jon

[Kevin Frey]

What happens if you remove the ORDER BY clause?

Kevin.