sql server odbc: help with emergency--sql server 2000 sp4 -- sql server odbc

You're in the

sql server odbc

group:

help with emergency--sql server 2000 sp4

c676228
9/17/2006 10:30:01 AM

sql server odbc: Hi everyone,
Our site is running fine until our hosting company applied sp4 to our sql
server 2000 on windwows 2000 server. It seems that our asp program cannot
talk to you sql server 2000 any more.
the error message is like this:
line 13 is the source of error message and I marked with *
This is error message I got from my asp program is:
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'tis_productRate'

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.Execute(sQry) ' error message here
If CInt(Rcount(0)) <> 0 then
rcount=Rcount(0)
End If

cmdTemp.CommandText = "select AgeLower, AgeUpper, Rate, CFARRate from
tis_productRate where product='"& "select" &"'"
set RateChart = Server.CreateObject("ADODB.RecordSet")
RateChart.Open cmdTemp, , adOpenStatic, adLockReadOnly

While not RateChart.EOF
if k<6 then
ageLower(k)=CInt(RateChart("AgeLower"))
ageUpper(k)=CInt(RateChart("AgeUpper")) +1
CFARarr(k)=CDbl(Trim(RateChart("CFARRate")))
NOCFARarr(k)=CDbl(Trim(Ratechart("Rate")))
' age1(k).Add "Rate", RateChart("Rate")
k=k+1
end if
RateChart.movenext
wend

End Function

acutally I can see this tis_productRate object in database analyzer and can
do query. besides no data can be inserted into database through any asp
program.
my connection string to database is like this:
conn.Open "dsn=XXXXX;uid=XXXXX;pwd=XXXXXXXX"
which have been there for more than 5 years, everything is fine before apply
sp4.
If you are microsoft technical support, please give me your phone support, I
need their help desperately.
--

RE: help with emergency--sql server 2000 sp4

changliw NO[at]SPAM online.microsoft.com
9/18/2006 3:07:49 AM

Dear Betty,
My understanding of your issue is:
Your ASP program failed to execute DML operations on your SQL Server after
the SP4 installed, though it had been working for five years. The
connection driver was DSN and query in QA worked fine. Also, you want to
know Microsoft emergency call.
If I have misunderstood, please let me know.

You can contact Microsoft Product Support Services (PSS) via telephone so
that a dedicated Support Professional can assist you recover the server in
a more efficient manner. Please be advised that contacting phone support
will be a charged call.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Also, I would like to give you some suggestions here before you make a call
to PSS.
1. Check if the user permissions changed after the SP4 installed. Ensure
the SQL login user is a dbo (database owner) .
2. Check if some error information existed in SQL error logs (C:\Program
files\Microsoft SQL Server\MSSQL\LOG).
3. Check if the default database in DSN is correct; I recommend that you
recreate the DSN data source and try again.

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Partner Support

PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!

Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

RE: help with emergency--sql server 2000 sp4

c676228
9/18/2006 9:51:02 AM

Hi everyone

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

[quoted text, click to view]

RE: help with emergency--sql server 2000 sp4

changliw NO[at]SPAM online.microsoft.com
9/19/2006 5:17:09 AM

Dear Betty,
Maybe something happened to be an accident. :-)
One thing guaranteed is that the installation of SP4 won't change the ODBC
DSN file.

So after their correcting the DSN connection, does this issue disappear now?

Please don't hesitate to let me know if you have any other questions or
concerns. It's my pleasure to be of assistance.

Sincerely,
Charles Wang
Microsoft Online Community Support

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007

home · blog · groups

Questions? Comments? Contact the dn