By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,910 Members | 1,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,910 IT Pros & Developers. It's quick & easy.

Client side insert update

P: n/a
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
Apr 6 '08 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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
Apr 6 '08 #2

P: n/a
(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
Apr 6 '08 #3

P: n/a
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.
Apr 7 '08 #4

P: n/a
On 7 Nisan, 02:32, Ed Murphy <emurph...@socal.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....
Apr 7 '08 #5

P: n/a
On 7 Nisan, 07:50, sgulc...@yahoo.com wrote:
On 7 Nisan, 02:32, Ed Murphy <emurph...@socal.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
Apr 7 '08 #6

P: n/a
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, sgulc...@yahoo.com wrote:
On 7 Nisan, 02:32, Ed Murphy <emurph...@socal.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

Apr 7 '08 #7

This discussion thread is closed

Replies have been disabled for this discussion.