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=XXXX XX"
Is there any problem with my connection string with sp4 applied?
Can you please help?
Betty
--
Betty
14  1717 
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****@communi ty.nospamwrote in message
news:83******** *************** ***********@mic rosoft.com...
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=XXXX XX"
Is there any problem with my connection string with sp4 applied?
Can you please help?
Betty
--
Betty
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_productRat e'
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:
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****@communi ty.nospamwrote in message
news:83******** *************** ***********@mic rosoft.com...
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=XXXX XX"
Is there any problem with my connection string with sp4 applied?
Can you please help?
Betty
--
Betty
c676228 wrote:
Steven,
This is error message I got from my asp program of all pages.
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]
Nothing to do with your problem, but: http://www.aspfaq.com/show.asp?id=2126
>Invalid
object name 'tis_productRat e'
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!
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"
Bob,
Here is the code. The error messge points to line I marked with star and
very intesting thing is to customers that some of my application looks OK
when application goes from one page to another, but behind the secene, no
data has been inserted into any database table. why does this happen right
after sp4 is applied to our sql server 2000?
dim CFARarr(6)
dim NOCFARarr(6)
dim AgeLower(6)
dim AgeUpper(6)
dim rcount
Function fillRateInfo()
Dim k
k=0
sQry="Select count(*) from tis_productRate where product ='"& "select" &"'"
* Set Rcount=conn.Exe cute(sQry) ' error message here
If CInt(Rcount(0)) <0 then
rcount=Rcount(0 )
End If
cmdTemp.Command Text = "select AgeLower, AgeUpper, Rate, CFARRate from
tis_productRate where product='"& "select" &"'"
set RateChart = Server.CreateOb ject("ADODB.Rec ordSet")
RateChart.Open cmdTemp, , adOpenStatic, adLockReadOnly
While not RateChart.EOF
if k<6 then
ageLower(k)=CIn t(RateChart("Ag eLower"))
ageUpper(k)=CIn t(RateChart("Ag eUpper")) +1
CFARarr(k)=CDbl (Trim(RateChart ("CFARRate") ))
NOCFARarr(k)=CD bl(Trim(Ratecha rt("Rate")))
' age1(k).Add "Rate", RateChart("Rate ")
k=k+1
end if
RateChart.moven ext
wend
End Function
--
Betty
"Bob Barrows [MVP]" wrote:
c676228 wrote:
Steven,
This is error message I got from my asp program of all pages.
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]
Nothing to do with your problem, but:
http://www.aspfaq.com/show.asp?id=2126
Invalid
object name 'tis_productRat e'
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!
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"
Hello Betty,
I agree with Bob this seems to be a security issue. The account you used in
the conncetion string:
conn.Open "dsn=XXXXXX;uid =XXXXX;pwd=XXXX XX"
may not have permission to access the table 'tis_productRat e' any more.
You may first check if the table 'tis_productRat e' is owned by 'dbo' or if
the account you used is an adminitrator account in current database.
Anyway, you better consult the hosting company about this if you don't have
administrator permission on the database. Normally, this requires a
configration on the database. I think the code is OK since it used to work
fine.
Sincerely,
Luke Zhang
Microsoft Online Community Support
=============== =============== =============== =====
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx.
=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no rights.
c676228 wrote:
Bob,
Here is the code.
You left out your connection string (you can censor the sensitive
information in it, if any). That's the most relevant piece of information
needed to diagnose a security issue. We need to understand what login
account is being used to connect to your database
The error messge points to line I marked with star
and very intesting thing is to customers that some of my application
looks OK when application goes from one page to another, but behind
the secene, no data has been inserted into any database table. why
does this happen right after sp4 is applied to our sql server 2000?
I don't understand. You seem to be talking about a different problem now.
This code you are showing has nothing in it that would insert data into a
database table.
<snip>>
sQry="Select count(*) from tis_productRate where product ='"&
"select" &"'" * Set Rcount=conn.Exe cute(sQry) ' error message here
<snip - everything after this point is irrelevant - we need to see what's
happening prior to this point - specifically the point where you connect to
the database>
--
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"
c676228 wrote:
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.
That symptom could very well occur if you were using sa and a blank password
to connect:
"If the SQL Server instance to be upgraded to SP4 has a blank
password for the sa login account, a password must be provided
before an unattended installation is run." http://download.microsoft.com/downlo...Sql2k32sp4.htm
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
I don't really know what happened after they applied sp4 to my sql server
2000.
I told my myself, I need to take a look at my testing database, I suddenly I
found out that my live data get into my testing database and that tell me why
some my production program gives invalid object error messge. You can image
what will happen when you have production code running against testing
database.
So I look at the ODBC set up and the original DSN is pointing to testing
database instance instead of my origianl set up --production database.
We have two database instances on our server. I guess they were not aware of
it. One is testing server(MSDE), one is production server(sql server 2000),
after the service pack is applied, something happened, I still don't know
they manually did it, or system set up?
Thank you all for providing your idea.
--
Betty
"Dave Anderson" wrote:
c676228 wrote:
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.
That symptom could very well occur if you were using sa and a blank password
to connect:
"If the SQL Server instance to be upgraded to SP4 has a blank
password for the sa login account, a password must be provided
before an unattended installation is run."
http://download.microsoft.com/downlo...Sql2k32sp4.htm
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
c676228 wrote:
I don't really know what happened after they applied sp4 to my sql
server 2000.
I told my myself, I need to take a look at my testing database, I
suddenly I found out that my live data get into my testing database
and that tell me why some my production program gives invalid object
error messge. You can image what will happen when you have production
code running against testing database.
So I look at the ODBC set up and the original DSN is pointing to
testing database instance instead of my origianl set up -->
production database.
Yet another reason to avoid ODBC DSNs. Again: http://www.aspfaq.com/show.asp?id=2126
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: abcd |
last post by:
kutthaense Secretary Djetvedehald H. Rumsfeld legai predicted eventual
vicmadhlary in Iraq mariyu Afghmadhlaistmadhla, kaani jetvedehly after "a
ljetvedehg, hard slog," mariyu vede legai pressed Pentagjetvedeh
karuvificials madhla reachathe strategy in karkun campaign deshatinst
terrorism.
"mudivae maretu winning or losing karkun global varti jetvedeh terror?" Mr.
Rumsfeld adugued in a recent memormariyuum. vede velli jetvedeh madhla...
|
by: Tim Clark |
last post by:
We've been having a lot of event ID 37 with src W3SVC errors popping up. We
have 50+ sites in medium isolation, and i ran IISstate on the two instances
of DLLHOST and the one of inetinfo. Is there anything revealed by the three
logs below?
thank you in advance,
TC
Opened log file 'D:\emergency\output\IISState-3088.log'
|
by: Andrew |
last post by:
I have an application written in VB.NET that connects directly to a
SQL Server 2000 database over the internet. It works fine on the
development machine (XP Pro), as well as two outside machines running
XP Pro. It does NOT work on two other outside machines, both running
Win2000. All 4 outside machines have the latest .NET framework
installed. I assume that XP has something by default that the 2000
machines do not, but I have no idea...
|
by: JIMMIE WHITAKER |
last post by:
The below stored procedure works. However, I am trying to use a text box
from a temp form for the where clause.
WHERE Transactions.TransactionID = !!
I even tried changing first line:
Alter PROCEDURE S3 @TID varchar (255) = !!
And changed last line to:
WHERE Transactions.TransactionID = @TID
So far, I haven't been able to have this parameter work from a temp form
with the parameter typed into the text0 box.
any help here? I get ado...
|
by: aemazing |
last post by:
hello, im new to the forum and i wanted to help with my c++ program.
the teacher wants us to design a progrm that would keep track of
airplanes awaitin landing at an airport. the program will maintain a
queue of flights numbers.
the program will be abel to do the following:
Add a new flight number to the end of the queue (got it done)
LAnd the plane at the front of the queue - problems wit it-
display the queue - got it done
| | |
by: No_Excuses |
last post by:
All,
I am interested in reading the text of a web page and parsing it.
After searching on this newgroup I decided to use the following:
******************************* START OF CODE ************************
String sTemp = "http://cgi3.igl.net/cgi-bin/ladder/teamsql/team_view.cgi?ladd=teamknights&num=238&showall=1";
WebRequest myWebRequest = WebRequest.Create(sTemp);
WebResponse myWebResponse = myWebRequest.GetResponse();
|
by: Matthew Speed |
last post by:
(About me: I know very little about writing server applications. I
have done plenty of VB6 desktop app work but this is my first server
program. I got it to work by modifying examples. I understand what
it is doing but not much about what is involved in extending it. )
I am not necessarily looking for code examples here, just some
pointers as to what direction I need to proceed to resolve these
things.
I have written a...
|
by: pamelafluente |
last post by:
I am still working with no success on that client/server
problem. I need your help. I will submit simplified versions
of my problem so we can see clearly what is going on.
My model:
A client uses IE to talk with a server.
The user on the client (IE) sees an ASP net page containing
a TextBox. He can write some text in this text box and
push a submit button.
|
by: gunimpi |
last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431
********************************************************
VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help
wanted
********************************************************
For this teeny job, please refer to:
http://feeds.reddit.com/feed/8fu/?o=25
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
