odbc - excel - issue

D

Deepak Ramaswamy

I have a C++ program that connets to an Excel DB via ODBC.
There are 5 excel sheets, within each of which there are 8
columns and 300 rows filled with either Integers or Strings
(Char).

I query the DB to do a simple search ( no complex
joins..etctec), which is of the form->

SELECT Code, StreetID, StreetName FROM *** WHERE Code = %
lu " OR Code = %lu......etc..." ORDER BY Code, StreetID;

Normally, I query about 250 values. ie there are 250
different Integers in the SELECT stmt. The prgram wokrs
fine.

If I increase my query to say 300, the program fails. The
error says: Query too Complex;

Can you please tell me the reason behind this? Also
possibly a hot fix. I am not a Database person.
My system config-> Win2k Pro;300MB Ram;1Ghz Processor;
Ms Office 2K with MS excel version 9.0.3821 SR-1

Thanks,

Deepak
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top