The parameter is not correct from SqlDataAdapter control

20 Sep 2006 5:53 AM

Tony Girgenti

Hello.

I'm developing and testing a web application using VS.NET 2003, VB, .NET
Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. I'm using a web form.

During testing, i guess i installed and deleted an SqlDataAdapter control on
my web form one too many times. When i try to add one now, it gives me "The
parameter is not correct" and just does nothing.

I deleted the SqlConnection, stopped and restarted IIS, Sql servers, my
computer. Searched the internet and still cannot figure out what the
problem is.

Does anybody know what that error is ?

Thanks,
Tony

20 Sep 2006 10:29 PM

Dick Cheney

Hi,

I got a smilar error once. In my instance, the problem was with the
odbcDataAdapter. My problem was when I dropped the adapter into the form and
tried going trough the wizard. In my case I had configured the Dataadapter
to use a specific Access DSN. Everything worked fine until I deleted the
Access File and then every time I wanted to use a DataAdapter it gave me an
error and quit the wizard. I think this happens, because the DataAdapter
tries to connect to the last connection setting you used previously and if
there is an error with it, it quits the wizard. Is this was happening to
you? Is the previous connection you were using still working? I am still
able to recreate the bug I mention it every time, to the point that it
crashes Visual Studio.

Do you get the component in your form or do you not even get to be able to
drop it in the form?

Let me know and good luck,

D. Cheney.

Show quoteHide quote

"Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
news:%23PxYRkH3GHA.5024@TK2MSFTNGP02.phx.gbl...
> Hello.
>
> I'm developing and testing a web application using VS.NET 2003, VB, .NET
> Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. I'm using a web form.
>
> During testing, i guess i installed and deleted an SqlDataAdapter control
> on my web form one too many times. When i try to add one now, it gives me
> "The parameter is not correct" and just does nothing.
>
> I deleted the SqlConnection, stopped and restarted IIS, Sql servers, my
> computer. Searched the internet and still cannot figure out what the
> problem is.
>
> Does anybody know what that error is ?
>
> Thanks,
> Tony
>

21 Sep 2006 12:01 AM

Tony Girgenti

Hello Dick.

When it happens to me, it doesn't do anything. I just click OK and nothing
happens. I deleted the previous connection before i tested it so i'm not
sure if it worked.

My problem does not crash or terminate VS, it just does nothing.

Thanks,
Tony

Show quoteHide quote

"Dick Cheney" <IEmbed***@gmail.com> wrote in message
news:OCZwCRQ3GHA.5092@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I got a smilar error once. In my instance, the problem was with the
> odbcDataAdapter. My problem was when I dropped the adapter into the form
> and tried going trough the wizard. In my case I had configured the
> Dataadapter to use a specific Access DSN. Everything worked fine until I
> deleted the Access File and then every time I wanted to use a DataAdapter
> it gave me an error and quit the wizard. I think this happens, because the
> DataAdapter tries to connect to the last connection setting you used
> previously and if there is an error with it, it quits the wizard. Is this
> was happening to you? Is the previous connection you were using still
> working? I am still able to recreate the bug I mention it every time, to
> the point that it crashes Visual Studio.
>
> Do you get the component in your form or do you not even get to be able to
> drop it in the form?
>
> Let me know and good luck,
>
> D. Cheney.
>
> "Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
> news:%23PxYRkH3GHA.5024@TK2MSFTNGP02.phx.gbl...
>> Hello.
>>
>> I'm developing and testing a web application using VS.NET 2003, VB, .NET
>> Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. I'm using a web form.
>>
>> During testing, i guess i installed and deleted an SqlDataAdapter control
>> on my web form one too many times. When i try to add one now, it gives
>> me "The parameter is not correct" and just does nothing.
>>
>> I deleted the SqlConnection, stopped and restarted IIS, Sql servers, my
>> computer. Searched the internet and still cannot figure out what the
>> problem is.
>>
>> Does anybody know what that error is ?
>>
>> Thanks,
>> Tony
>>
>
>