帮助紧急，asp程序无法与sql server 2000对话 [英] help with emergency, asp program cannot talk to sql server 2000 an
问题描述
大家好，
我们的网站已关闭，因为我们的托管公司在Windows 2000服务器上应用了sql server 2000 sp4
。
在应用服务包之后，我们的sql server数据库已关闭，并且
没有连接等。当一个技术支持重新启动服务器时，
像数据库中的表这样的对象无法通过我们的asp页面识别
了，数据无法插入到任何数据库表中且数据不能被拉出来b / b
正确地从数据库表通过asp程序，但我可以运行
查询并通过sql analyzer查看数据。
有什么问题，是不是因为连接字符串？在这项服务之前
包4，一切运行良好，我们从未发生过这种灾难。
我有这样的连接字符串：
conn.Open" dsn = XXXXXX; uid = XXXXX; pwd = XXXXXX"
我的连接字符串是否存在sp4应用问题？
你能帮忙吗？
贝蒂
-
Betty
Hi everyone,
Our site is down, because of our hosting company applied sql server 2000 sp4
on windows 2000 server.
right after it applied the service pack, our sql server database is down and
no conn etc. When one technical support restart the server,
the obejcts like tables in database cannot be recognized from our asp pages
anymore, data cannot be inserted into any database table and data cannot be
pulled out correctly from database table through asp program, but I can run
query and look at data through sql analyzer.
what is the problem, is it because of connection string? before this service
pack 4, everything runs fine and we never had this kind of disaster.
I have connection string like this:
conn.Open "dsn=XXXXXX;uid=XXXXX;pwd=XXXXXX"
Is there any problem with my connection string with sp4 applied?
Can you please help?
Betty
--
Betty
推荐答案
发布您收到的错误消息，以及您正在使用的代码，
将会去更多的帮助。
-
问候
Steven Burn
你的IT Mate Group
www.it-mate.co.uk
保持免费！
" c676228" < be **** @ community.nospamwrote in message
news：83 ************************** ******** @ microsof t.com ...
Posting the error message(s) you are receiving, and the code you are using,
will go alot further with helping.
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"c676228" <be****@community.nospamwrote in message
news:83**********************************@microsof t.com...
大家好，
我们的网站是因为我们的托管公司在Windows 2000服务器上应用了sql server 2000
Hi everyone,
Our site is down, because of our hosting company applied sql server 2000
sp4
sp4
。 br />
在应用服务包之后，我们的sql server数据库已关闭
on windows 2000 server.
right after it applied the service pack, our sql server database is down
和
and
没有conn等。当一个技术支持重新启动服务器时，
无法从我们的asp
中识别出像数据库中的表这样的对象
no conn etc. When one technical support restart the server,
the obejcts like tables in database cannot be recognized from our asp
pages
pages
了，数据无法插入任何数据库表，数据也不能
anymore, data cannot be inserted into any database table and data cannot
be
be
通过asp程序从数据库表中正确拉出，但是我可以
pulled out correctly from database table through asp program, but I can
运行
run
查询并通过sql analyzer查看数据。
有什么问题，是因为连接字符串？在此之前
query and look at data through sql analyzer.
what is the problem, is it because of connection string? before this
服务
service
pack 4，一切正常，我们从未发生过这种灾难。
我有这样的连接字符串：
conn.Open" dsn = XXXXXX; uid = XXXXX; pwd = XXXXXX"
我的连接字符串是否有sp4应用问题？
你能帮忙吗？
贝蒂
-
贝蒂
pack 4, everything runs fine and we never had this kind of disaster.
I have connection string like this:
conn.Open "dsn=XXXXXX;uid=XXXXX;pwd=XXXXXX"
Is there any problem with my connection string with sp4 applied?
Can you please help?
Betty
--
Betty
史蒂文，
这是我从所有页面的asp程序中得到的错误消息。
描述：[Microsoft] [ODBC SQL Server驱动程序] [SQL Server]无效对象
名称''tis_productRate''
实际上表就在那里，我可以从我的sql分析器中看到我可以
查询这个表格，数据就在那里。
感谢你们的帮助！
贝蒂
史蒂文伯恩写道：
Steven,
This is error message I got from my asp program of all pages.
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name ''tis_productRate''
Actually the table is right there, I can see from my sql analyzer and I can
query this table, the data is right there.
Thanks for yuur help!
Betty
"Steven Burn" wrote:
发布您收到的错误消息，以及您正在使用的代码，
将进一步帮助。
-
问候
Steven Burn
Ur IT Mate Group
www.it-mate.co.uk
保持免费！
" c676228" < be **** @ community.nospamwrote in message
news：83 ************************** ******** @ microsof t.com ...
Posting the error message(s) you are receiving, and the code you are using,
will go alot further with helping.
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"c676228" <be****@community.nospamwrote in message
news:83**********************************@microsof t.com...
大家好，
我们的网站是因为我们的托管公司在Windows 2000服务器上应用了sql server 2000
Hi everyone,
Our site is down, because of our hosting company applied sql server 2000
sp4
sp4
。 br />
在应用服务包之后，我们的sql server数据库已关闭
on windows 2000 server.
right after it applied the service pack, our sql server database is down
和
and
没有conn等。当一个技术支持重新启动服务器时，
无法从我们的asp
中识别出像数据库中的表这样的对象
no conn etc. When one technical support restart the server,
the obejcts like tables in database cannot be recognized from our asp
pages
pages
了，数据无法插入任何数据库表，数据也不能
anymore, data cannot be inserted into any database table and data cannot
be
be
通过asp p从数据库表中正确拉出rogram，但我可以
pulled out correctly from database table through asp program, but I can
run
run
查询并通过sql analyzer查看数据。
有什么问题，是因为连接字符串？在此之前
query and look at data through sql analyzer.
what is the problem, is it because of connection string? before this
服务
service
pack 4，一切正常，我们从未发生过这种灾难。
我有这样的连接字符串：
conn.Open" dsn = XXXXXX; uid = XXXXX; pwd = XXXXXX"
我的连接字符串是否有sp4应用问题？
你能帮忙吗？
贝蒂
-
贝蒂
pack 4, everything runs fine and we never had this kind of disaster.
I have connection string like this:
conn.Open "dsn=XXXXXX;uid=XXXXX;pwd=XXXXXX"
Is there any problem with my connection string with sp4 applied?
Can you please help?
Betty
--
Betty
< br>
c676228写道：
c676228 wrote:
史蒂文，
这是我从所有页面的asp程序中得到的错误信息。
描述：[Microsoft] [ODBC SQL Server驱动程序] [SQL Server]
Steven,
This is error message I got from my asp program of all pages.
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]
与您的问题无关，但是：
http://www.aspfaq.com/show.asp?id = 2126
>无效
对象名称''tis_productRate''
其实桌子就在那里，我可以从我的sql看到分析器和
我可以查询这个表，数据就在那里。
感谢您的帮助！
>Invalid
object name ''tis_productRate''
Actually the table is right there, I can see from my sql analyzer and
I can query this table, the data is right there.
Thanks for yuur help!
这很可能是权限问题：用于连接的登录
您的数据库无权查看那张桌子。如果您需要
进一步的帮助，您需要发布产生症状的代码。
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复，请删除
无垃圾邮件
It''s most likely a permissions issue: the login you are using to connect to
your database does not have permission to view that table. If you require
further assistance, you need to post the code that produces the symptom.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
这篇关于帮助紧急，asp程序无法与sql server 2000对话的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
