I cannot insert data into MS SQL through ASP,but i can update it with asp
program,so i need your help. Any sugestin will be hightly appreciated
david
Good question David
How do you think we can suggest you something without seeng your INSERT
statement as well as an ERROR you are getting?
Check out if the table has a trigger for INSERT.
"msnews" <wangxuewu@.ecanyin.com> wrote in message
news:ehKKRxHzFHA.2720@.TK2MSFTNGP10.phx.gbl...
>I cannot insert data into MS SQL through ASP,but i can update it with asp
>program,so i need your help. Any sugestin will be hightly appreciated
>
> david
>
|||Hi,
Verify:-
1. Run a profiler and get the actual insert statement
2. Exact error message; probably a
a. Previlage issue
b.Inserted columns miss match
c. Exclusive insert for an identity column
d. Prikary key violation
Thanks
Hari
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OOVzbiJzFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Good question David
> How do you think we can suggest you something without seeng your INSERT
> statement as well as an ERROR you are getting?
> Check out if the table has a trigger for INSERT.
>
> "msnews" <wangxuewu@.ecanyin.com> wrote in message
> news:ehKKRxHzFHA.2720@.TK2MSFTNGP10.phx.gbl...
>
No comments:
Post a Comment