oleDbDataAdapter1 limited to 99 variables in SQL-statements??

  • Thread starter Thread starter flaavia
  • Start date Start date
F

flaavia

Hello

My oleDbDataAdapter1 seems to be limited to 99 variables
in SQL-statements. At least it does give an error when
tying to address more than 99

Does anyboda know if that is a fixed limit or can it be
increased??

Thanks for all answers in advance
 
flaavia,

What is the error when you try and use more than 99 statements? I have
created a small test program, and was able to add 1000 parameters.
 
Hello

Txs for your answers

My Access DB contains about 350 variables. When using the
Query Builder of the Data Adapter configuration wizzard
(oleDbDataAdapter->properties->SelectCommand->
CommandText ...; oleDbDataAdapter connected to
oleDbConnection) and selecting DB.* (all) then the Error
message appears:

The wizzard detected the following problems when
configuring the data adapter "oleDbDataAdapter1".
Details: Generated select statement. There were errors
configuring the data adapter.

That is all the message that appeared.

I tried to find out which variable is causing this. It
turned out that whenever more than 99 variables were
selected for the SQL statement that this error appeared -
regardless which of the 350 variables were selected.

Do you have any idea why that is ??
-----Original Message-----
flaavia,

What is the error when you try and use more than 99 statements? I have
created a small test program, and was able to add 1000 parameters.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hello

My oleDbDataAdapter1 seems to be limited to 99 variables
in SQL-statements. At least it does give an error when
tying to address more than 99

Does anyboda know if that is a fixed limit or can it be
increased??

Thanks for all answers in advance
Click to expand...


.
Click to expand...
 
Hello

Txs for your answers

My Access DB contains about 350 variables. When using the
Query Builder of the Data Adapter configuration wizzard
(oleDbDataAdapter->properties->SelectCommand->
CommandText ...; oleDbDataAdapter connected to
oleDbConnection) and selecting DB.* (all) then the Error
message appears:

The wizzard detected the following problems when
configuring the data adapter "oleDbDataAdapter1".
Details: Generated select statement. There were errors
configuring the data adapter.

That is all the message that appeared.

I tried to find out which variable is causing this. It
turned out that whenever more than 99 variables were
selected for the SQL statement that this error appeared -
regardless which of the 350 variables were selected.

Do you have any idea why that is ??
 
Hi,

flaavia said:
Hello

Txs for your answers

My Access DB contains about 350 variables. When using the
Query Builder of the Data Adapter configuration wizzard
(oleDbDataAdapter->properties->SelectCommand->
CommandText ...; oleDbDataAdapter connected to
oleDbConnection) and selecting DB.* (all) then the Error
message appears:
Click to expand...

If I remember properly this is a known problem with query builder (not
supporting tables with more than around 100 columns - i guess it is the same
for parameters).
Try accessing the statament by code instead.
 
Hi

Thank you very much for your answer.

Is that known by Microsoft and are they trying to fix
that ??
 
Back
Top