473,385 Members | 1,320 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Client side insert update

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
6 3669
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
(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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Michael Rybak | last post by:
hi, everyone. I'm writing a 2-players game that should support network mode. I'm now testing it on 1 PC since I don't have 2. I directly use sockets, and both client and server do...
5
by: KathyB | last post by:
If someone could just explain this to me...I just don't get it! I have an aspx page where I retrieve several session variables and use xmlDocument to transform xml file with xsl file into an...
4
by: Prince Kumar | last post by:
I joined a company recently and they have a java program which hangs (does nothing) after a while. This is no way consistent. It could succeed quite a few times and can fail a few other times....
3
by: Ken Allen | last post by:
I am relatively new to .Net and C#, but I hav ebeen programing in other languages and done some COM work for a number of years. I am attempting to understand how to map an older program...
4
by: rs | last post by:
how I the client tell the server that the socket is closed? or this there an even that informs the server that the clients socket is close? Oh, I am using vb.net 2003 Thanks
0
by: Janning Vygen | last post by:
Hi, i have a question about how to handle postgresql constraint errors in the client app. I found some mails in the archive about it, too. But i have still so many questions about how to do it,...
3
by: Guy Debord | last post by:
Hello all, I know that this is a long shot, but I have a problem which someone reading this group *may* just be able to shed some light on. We have a new internal personnel planner/attendance...
10
by: Ben | last post by:
Hi, I made an application in classic asp (reservation of books and video stuffs for students) and want to migrate to asp.net. The user has to chose a date, then pushung on a submit button. The...
1
by: Andrew Wan | last post by:
Is it possible to make some of the DataGrid functionality to client-side? Such as the Edit, Update, Cancel, Delete functionality? Everytime I click on a row's Edit button, I wait 2 seconds...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.