data adapter to SQL 2005

[M]

I have the some troubles.

I have a VBNET Project version 7.0.9466. Microsoft Visual Basic .NET
55524-640-2187145-18548

I have SQL 2005 and SQL 2000 in different remote computers.

When I confirurate the data adapter.

If connecting to SQL 2000, All SELECT, INSERT, UPDATE, and DELETE
statements were create successfully.

but change connection to SQL 2005 server and the SELECT statement was
created successfully but the INSERT, UPDATE, and DELETE statements, "There
were errors configuring the data adapter".

The Select statement is very simple, only select ONE table and also select
the primary key from the table.

[Christiano Donke]

Re: data adapter to SQL 2005

not sure if i really understood it...

can u post your connection configuration?? ?

in sql server 2005 you must set it up allow remote connections... is it
done??

in sql 2k you may have a blank pwd, but in 2k5 you can't.. is it correct??

what are your connection strings???

perhaps it can even be some networking fault...


"M" <mxchen@hotvoic e.comescreveu na mensagem
news:u4EiYELJJH A.4380@TK2MSFTN GP03.phx.gbl...

>I have the some troubles.
>
I have a VBNET Project version 7.0.9466. Microsoft Visual Basic .NET
55524-640-2187145-18548
>
I have SQL 2005 and SQL 2000 in different remote computers.
>
When I confirurate the data adapter.
>
If connecting to SQL 2000, All SELECT, INSERT, UPDATE, and DELETE
statements were create successfully.
>
but change connection to SQL 2005 server and the SELECT statement was
created successfully but the INSERT, UPDATE, and DELETE statements, "There
were errors configuring the data adapter".
>
The Select statement is very simple, only select ONE table and also select
the primary key from the table.
>
>