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
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