ASP Classic - adding a record to an SQL Server database

Question

ASP Classic - adding a record to an SQL Server database

Muslim Sattarov 1

I am trying to add a record to an SQL Server database using ASP classic. The standard Select query, in order to show info from this table, works well, but when I send a query to the database to insert a record it shows this error:

"An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error."

Here's the link: https://smus.link/links/

lname = (Request("lname"))
url = (Request("url"))

SQLStatement = "SELECT * FROM links"
sco.Open SQLStatement, adoCon, 3, 3
sco.AddNew "name", lname
sco.Update
sco.Fields("url").value=url
sco.Update
sco.Close

Erland Sommarskog 78,111 Reputation points MVP

2022-10-29T18:17:44.653+00:00

That's not an error from SQL Server. It's an error from the web server. You first need to get hold of the actual error message. For how to do that, you would need to inquire in a forum where they talk about classic ASP.

As for the link: I don't think very are keen a link given to them out of the blue by a stranger. Who knows what malicious things there may be on the other end.
Muslim Sattarov 1 Reputation point

2022-10-30T20:39:57.897+00:00

I understand it. I have almost identical code working with the same database, but with another table - it works well too. So, maybe there are some restrictions on the hosting. I already asked this question on Stackoverflow. Can you share a link to any specific Classic ASP forums?
Erland Sommarskog 78,111 Reputation points MVP

2022-10-30T20:45:40.347+00:00

Can you share a link to any specific Classic ASP forums?

Well, there is always http://www.goggle.com. (You asked in an SQL Server forum. You cannot expect people here to know much about classic ASP. Or even where the forums are located.)
Erland Sommarskog 78,111 Reputation points MVP

2022-10-30T21:02:12.15+00:00

What you can do from the SQL Server side of things is to use Profiler to see what statements you submit to SQL Server, and by adding the Error:Exception event you can also see what errors you get.

But this requires that you have ALTER TRACE permission on the server, which you may not have, if you have a hoster.

Erland Sommarskog 78,111 Reputation points MVP

2022-10-29T18:17:44.653+00:00

That's not an error from SQL Server. It's an error from the web server. You first need to get hold of the actual error message. For how to do that, you would need to inquire in a forum where they talk about classic ASP.

As for the link: I don't think very are keen a link given to them out of the blue by a stranger. Who knows what malicious things there may be on the other end.
Muslim Sattarov 1 Reputation point

2022-10-30T20:39:57.897+00:00

I understand it. I have almost identical code working with the same database, but with another table - it works well too. So, maybe there are some restrictions on the hosting. I already asked this question on Stackoverflow. Can you share a link to any specific Classic ASP forums?
Erland Sommarskog 78,111 Reputation points MVP

2022-10-30T20:45:40.347+00:00

Can you share a link to any specific Classic ASP forums?

Well, there is always http://www.goggle.com. (You asked in an SQL Server forum. You cannot expect people here to know much about classic ASP. Or even where the forums are located.)
Erland Sommarskog 78,111 Reputation points MVP

2022-10-30T21:02:12.15+00:00

What you can do from the SQL Server side of things is to use Profiler to see what statements you submit to SQL Server, and by adding the Error:Exception event you can also see what errors you get.

But this requires that you have ALTER TRACE permission on the server, which you may not have, if you have a hoster.

ASP Classic - adding a record to an SQL Server database

Activity