Client side insert update

[sgulciny]

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]

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

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

<sg******@yahoo.comwrote in message
news:f3**********************************@1g2000pr f.googlegroups.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]

(sg******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Ed Murphy]

sg******@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]

On 7 Nisan, 02:32, Ed Murphy <[e-mail]:

[e-mail] 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]

On 7 Nisan, 07:50, [e-mail] wrote:

On 7 Nisan, 02:32, Ed Murphy <[e-mail]:

[e-mail] 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]

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/arch...-Practice.aspx
for more information and examples.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

<sg******@yahoo.comwrote in message
news:2b**********************************@m44g2000 hsc.googlegroups.com...
On 7 Nisan, 07:50, [e-mail] wrote:

On 7 Nisan, 02:32, Ed Murphy <[e-mail]:

[e-mail] 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