oleDbDataAdapter1 limited to 99 variables in SQL-statements??

[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

[Miha Markic]

Hi flaavia,

How do you know that is limited?

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"flaavia" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

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

[Nicholas Paldino [.NET/C# MVP]]

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]
- mv*@spam.guard.caspershouse.com

"flaavia" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

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]

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 havecreated a small test program, and was able to add 1000 parameters.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"flaavia" <an*******@discussions.microsoft.com> wrote in messagenews:08****************************@phx.gbl...

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]

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-----
Hi flaavia,

How do you know that is limited?

--
Miha Markic - RightHand .NET consulting & software developmentmiha at rthand com
www.rthand.com

"flaavia" <an*******@discussions.microsoft.com> wrote in messagenews:08****************************@phx.gbl...

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

.

[Miha Markic]

Hi,

"flaavia" <an*******@discussions.microsoft.com> wrote in message
news:0b****************************@phx.gbl...

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:

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.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Hi

Thank you very much for your answer.

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

-----Original Message-----
Hi,

"flaavia" <an*******@discussions.microsoft.com> wrote in messagenews:0b****************************@phx.gbl...

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:
If I remember properly this is a known problem with

query builder (notsupporting tables with more than around 100 columns - i guess it is the samefor parameters).
Try accessing the statament by code instead.

--
Miha Markic - RightHand .NET consulting & software developmentmiha at rthand com
www.rthand.com
.