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
Can you post the SQL and relevant C# code snippet?
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
news:f3ae6c4c-472e-49ee-933f-7c1df5027e23@1g2000prf.googlegr oups.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
(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@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx
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.
On 7 Nisan, 02:32, Ed Murphy
> 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? =A0Same 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....
On 7 Nisan, 07:50, sgulc...@yahoo.com wrote:
> On 7 Nisan, 02:32, Ed Murphy
>
> > 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? =A0Same 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
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-Param eters-are-a-Best-Practice.aspx
for more information and examples.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
news:2b85a370-dbbe-43f7-8b7a-79504216eeba@m44g2000hsc.google groups.com...
On 7 Nisan, 07:50, sgulc...@yahoo.com wrote:
> On 7 Nisan, 02:32, Ed Murphy
>
> > 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