I am developing on my local IIS server and everything works fine. Using Access
as the database.

I post the changes to my service providers server and it fails. Using Access
as the database.

The problem is, there is some sort of limit to the number of characters that
can be passed in the SQL string on their server.

Select blah blah blah
from blah
where blah blah blah

If I reduce the number of columns I call so the SQL string is under lets say
200 characters, then their server works fine.

Where is this limit set?
Is it the buffer value in the ODBC setting?
Is it a Cold Fusion Server configuration setting?

Thanks in advance.

Michael