Client side insert update

[sgulciny@yahoo.com]

hi friends;
I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

[Dan Guzman]

Re: Client side insert update

Can you post the SQL and relevant C# code snippet?

--
Hope this helps.

Dan Guzman
SQL Server MVP

http://weblogs.sqlteam.com/dang/

<sgulciny@yahoo .comwrote in message
news:f3ae6c4c-472e-49ee-933f-7c1df5027e23@1g 2000prf.googleg roups.com...

hi friends;
I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

[Erland Sommarskog]

Re: Client side insert update

(sgulciny@yahoo .com) writes:

hi friends;
I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

In addition to Dan suggestion that you post the relevant code, please also
specify what "not insert, not update" means. Do you get an error? Or
just nothing happening?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Ed Murphy]

Re: Client side insert update

sgulciny@yahoo. com wrote:

I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

When the application runs on the server, are you connecting to the
database using SQL or Windows authentication, and in either case
which user are you connecting as? Same questions when the application
runs on the client.

[sgulciny@yahoo.com]

Re: Client side insert update

On 7 Nisan, 02:32, Ed Murphy <emurph...@soca l.rr.comwrote:

sgulc...@yahoo. com wrote:

I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

>
When the application runs on the server, are you connecting to the
database using SQL or Windows authentication, and in either case
which user are you connecting as?  Same questions when the application
runs on the client.

I am connecting with Windows Authentication. In server I am connect
with Admin but other computers I connect with their users.It problem??
If can I use Sql authentication it solve?????
When Insert or update record I saw an error like "values not
compatible for insert values ....." but insert into test (x,y,z)
values (x,y,z) its ok.I count them,colums and their values same
number....

[sgulciny@yahoo.com]

Re: Client side insert update

On 7 Nisan, 07:50, sgulc...@yahoo. com wrote:

On 7 Nisan, 02:32, Ed Murphy <emurph...@soca l.rr.comwrote:
>

sgulc...@yahoo. com wrote:

I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

>

When the application runs on the server, are you connecting to the
database using SQL or Windows authentication, and in either case
which user are you connecting as?  Same questions when the application
runs on the client.

>
I am connecting with Windows Authentication. In server I am connect
with Admin but other computers I connect with their users.It problem??
If can I use Sql authentication it solve?????
When Insert or update record I saw an error like "values not
compatible for insert values ....." but insert into test (x,y,z)
values (x,y,z) its ok.I count them,colums and their values same
number....

Thanks for all I can solve it. It is regional settings problem about
number columns use "," or "." If it use "," it is problem for "insert
into" ....Happy dayssss

[Dan Guzman]

Re: Client side insert update

I suggest you consider using parameters instead of building SQL statement
strings. Not only is this more secure, you don't need to specify a decimal
separator, escape quotes or format datetime strings. See my blog

http://weblogs.sqlteam.com/dang/archive/2008/02/18/Why-Parameters-are-a-Best-Practice.aspx

for more information and examples.

--
Hope this helps.

Dan Guzman
SQL Server MVP

http://weblogs.sqlteam.com/dang/

<sgulciny@yahoo .comwrote in message
news:2b85a370-dbbe-43f7-8b7a-79504216eeba@m4 4g2000hsc.googl egroups.com...
On 7 Nisan, 07:50, sgulc...@yahoo. com wrote:

On 7 Nisan, 02:32, Ed Murphy <emurph...@soca l.rr.comwrote:
>

sgulc...@yahoo. com wrote:

I have problem about sql server insert and update in client side.
I am coding windows application with c#.When I run my code in database
server computer all is fine.I can see data, insert and update.But when
I run same code in client side I can see data but not insert not
update what can I do about this problem .I use sql server 2000
database.Client side connections ok. :( thanks for all

>

When the application runs on the server, are you connecting to the
database using SQL or Windows authentication, and in either case
which user are you connecting as? Same questions when the application
runs on the client.

>
I am connecting with Windows Authentication. In server I am connect
with Admin but other computers I connect with their users.It problem??
If can I use Sql authentication it solve?????
When Insert or update record I saw an error like "values not
compatible for insert values ....." but insert into test (x,y,z)
values (x,y,z) its ok.I count them,colums and their values same
number....

Thanks for all I can solve it. It is regional settings problem about
number columns use "," or "." If it use "," it is problem for "insert
into" ....Happy dayssss