SQL服务器和ASP [英] SQL server and ASP
问题描述
我正在尝试使用Frontpage中生成的ASP页面来更新SQL服务器
数据库。我可以查看数据库中的信息但无法更新，我只需收到一条消息，说明发生了错误。我并不太担心
安全性，我很高兴有一个登录有权在数据库，创建，删除等方面做任何事情。 2个问题： -
制作可访问所有数据库的用户帐户的最简单方法是什么？
错误日志在哪里对于试图更新数据库的ASP页面
存储了吗？
提前致谢！
< blockquote>我建议不要让FrontPage为你做这个...花一个小时在ASP
数据库教程中，从长远来看你会好得多。
在不同的地方都有大量的代码片段，你可以从这里开始：
http://www.aspfaq.com/2183
-
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
" MC" < maxcoppin@-don''t-send-me-any-spam-btinternet.com>在消息中写道
news：m87oc.72
sD1.38@newsfe6-win ...我正在尝试使用Frontpage中生成的ASP页面来更新SQL服务器数据库。我可以查看数据库中的信息但无法更新，我只是收到一条消息，说明发生了错误。我并不太担心
关于安全问题，我很高兴有一个登录有权在数据库中做任何
，创建，删除等等所以2个问题： -
创建一个有权访问所有
db的用户帐户的最简单方法是什么？ASP页面的错误日志在哪里尝试更新存储的数据？
提前致谢！
2004年5月11日星期二17:26:13 +0100，" MC"
< maxcoppin@-don''t-send-me-any-spam-btinternet.com>写道：
我正在尝试使用Frontpage中生成的ASP页面来更新SQL服务器数据库。我可以查看数据库中的信息但无法更新，我只是收到一条消息，说明发生了错误。我并不太担心
安全性，我很高兴有一个登录有权在数据库，创建，删除等方面做任何事情。所以2个问题： -
创建可访问所有数据库的用户帐户的最简单方法是什么？
用于更新数据库存储的ASP页面的错误日志在哪里？
1）你错过了我相信的alt.rocketscience小组......
2）这与你在六个小组中的五个小组无关点击，你好了b $ b错过了更好的一个。
3）如果你想要解决方案，你需要学会发布错误。 Postr
完整的错误信息。
尽管如此，FrontPage并不是编写ASP的最好方法，
，您可能遇到任意数量的权限错误。如果您发布了错误信息，我们可能会引导您找到解决方案，无论是
FrontPage，ASP还是SQL，或者更可能是Windows权限错误
某种类型。
Jeff
I''m trying to use ASP pages generated in Frontpage to update an SQL server
database. I can view information from the database but cannot update, I
just get a message saying an error has occured. I am not too worried about
security, I''d be happy with one login that has the rights to do anything in
the database, create, delete, etc So 2 questions:-
What''s the easiest way of making a user account that has access to all db''s
Where are the error logs for the ASP page attempting to update the DB
stored?
Thanks in advance!
I suggest not letting FrontPage do this for you... spend an hour at an ASP
database tutorial and you will be much better off in the long run. There
are plenty of code snippets at different places, you could start here:
http://www.aspfaq.com/2183
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"MC" <maxcoppin@-don''t-send-me-any-spam-btinternet.com> wrote in message
news:m87oc.72
sD1.38@newsfe6-win...I''m trying to use ASP pages generated in Frontpage to update an SQL server
database. I can view information from the database but cannot update, I
just get a message saying an error has occured. I am not too worried about security, I''d be happy with one login that has the rights to do anything in the database, create, delete, etc So 2 questions:-
What''s the easiest way of making a user account that has access to all db''s Where are the error logs for the ASP page attempting to update the DB
stored?
Thanks in advance!
On Tue, 11 May 2004 17:26:13 +0100, "MC"
<maxcoppin@-don''t-send-me-any-spam-btinternet.com> wrote:
I''m trying to use ASP pages generated in Frontpage to update an SQL server
database. I can view information from the database but cannot update, I
just get a message saying an error has occured. I am not too worried about
security, I''d be happy with one login that has the rights to do anything in
the database, create, delete, etc So 2 questions:-
What''s the easiest way of making a user account that has access to all db''s
Where are the error logs for the ASP page attempting to update the DB
stored?
1) You missed the alt.rocketscience group I believe...
2) This is irrelevant in five out of the six groups you hit, and you
missed an even better one.
3) You need to learn to post errors if you want solutions. Postr the
complete error message.
With all of that said, FrontPage isn''t the best method for coding ASP,
and you may be running into any number of permission errors. If you
post the error, we can likely direct you to a solution, be it
FrontPage, ASP or SQL, or more likely, a Windows permission error of
some sort.
Jeff
这篇关于SQL服务器和ASP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
