Hello, about 2 years ago I developed a simple logging system, that does INSERT, Authentication, Csharpt post back commands and field validation. Now that windows 7 PC'S came out and possibly more updates and security. Now my application's INSERT command
doesn't work on PC's using it's browser, but the application works properly if I access it on the server. I thought it was security, so I turned off AV, firewall etc, but without any luck. I eliminated the field & range validation, but it still wouldn't
work. I re-created a simple insert command, and that one works. I have a feeling it has something to do with the C# commands, not being passed from client to server. Can anybody help me on this? Please bare with me, I used ASP.net about 2 years ago so
I'm refreshing too. Please help me. Thank you!!!
Hi Thank you for your reply. This is the first time I've heard of it. What query is this? It's an INSERT command, so it just writes to the SQL Express. If it's on the source code, where do I put it? I may sound slow, but please bare with me. Thanks.
You can to place a try...catch in your code, and write the Exception in someplace (response.write in asp.net, console.write in consoleapplication or trace.write).
I holp this help.
Kindly mark this post as "Answer", if it helped you.
Please note : From Asp.net web forms inserting (most of the actions) happens always from server side and never from client side. Your issue is when the local host is used as the sever it does not insert. So definitely it it is an issue related to your
local host.
You said when you re created the insert it worked. Then Your problem is solved. Have you made any change while recreating it?
B
Kindly mark this post as "Answer", if it helped you.
abonto
0 Points
2 Posts
INSERT not working from the client, but works within the server...
Apr 24, 2012 12:16 AM|LINK
Hello, about 2 years ago I developed a simple logging system, that does INSERT, Authentication, Csharpt post back commands and field validation. Now that windows 7 PC'S came out and possibly more updates and security. Now my application's INSERT command doesn't work on PC's using it's browser, but the application works properly if I access it on the server. I thought it was security, so I turned off AV, firewall etc, but without any luck. I eliminated the field & range validation, but it still wouldn't work. I re-created a simple insert command, and that one works. I have a feeling it has something to do with the C# commands, not being passed from client to server. Can anybody help me on this? Please bare with me, I used ASP.net about 2 years ago so I'm refreshing too. Please help me. Thank you!!!
asp.netUser
Member
15 Points
184 Posts
Re: INSERT not working from the client, but works within the server...
Apr 24, 2012 12:47 AM|LINK
check to make sure you put the schema name in your query when running from browser
abonto
0 Points
2 Posts
Re: INSERT not working from the client, but works within the server...
Apr 24, 2012 12:52 AM|LINK
Hi Thank you for your reply. This is the first time I've heard of it. What query is this? It's an INSERT command, so it just writes to the SQL Express. If it's on the source code, where do I put it? I may sound slow, but please bare with me. Thanks.
pierrefrc
Participant
947 Points
201 Posts
Re: INSERT not working from the client, but works within the server...
Apr 24, 2012 01:12 AM|LINK
Hi
Does is your connection string is set corretly?
You can to place a try...catch in your code, and write the Exception in someplace (response.write in asp.net, console.write in consoleapplication or trace.write).
I holp this help.
basheerkal
Star
10672 Points
2426 Posts
Re: INSERT not working from the client, but works within the server...
Apr 24, 2012 05:34 AM|LINK
Please note : From Asp.net web forms inserting (most of the actions) happens always from server side and never from client side. Your issue is when the local host is used as the sever it does not insert. So definitely it it is an issue related to your local host.
You said when you re created the insert it worked. Then Your problem is solved. Have you made any change while recreating it?
B
(Talk less..Work more)