object required

[Bamarama]

SO I am using the same ASP coding I have always used, and I am now running into an unknown error. The error is as follows:

Microsoft VBScript runtime error '800a01a8'

Object required

/personal_stats.asp, line 153

line 153 is

set stats1 = conn.execute("select count(id) as cnt1 from _scores where id = "&userid2&"")

the ID field is a number. I am trying to cound the number of times a user has made an entry. I have done this numerous times before but now I am getting this error.

here is the connection info for SQL db

<%

Set Conn = Server.CreateObject("ADODB.Connection")
	Conn.Open = "Provider=sqloledb; Data Source=dbs5.myhost.com ; Initial Catalog=dbname; User Id=myusername; Password=mypassword; Connect Timeout=60"
%>

then of course i have the include

<!--#include file="connection.asp"-->

at the top of the page. Any ideas here?

 

[Turkbear]

Hi,
I do not remember if VBScript is case-sensitive regarding Object names, but if it is then , then

set stats1 = conn.execute("select count(id) as cnt1 from _scores where id = "&userid2&"")

does not match

Set Conn = Server.CreateObject("ADODB.Connection")




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ChrisHirst]

TEST the SQL statement manually to make sure it IS returning records.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

 

[Bamarama]

Not sure what you mean by testing manually. I replaced conn.execute with response write and got this:

select count(id) as cnt1 from _scores where user_id = 1

where 1 is the correct id being passed
i changed the line to user_id from id since the user id is different than the id.

all characters are lower case. I have been using this type of connection to the db, as well as the way i retrieve information for years. It is only recently when this has started happening.

if you need any other info to help me solve this, please let me know.

 

[ChrisHirst]

Testing manually:


Take the displayed query and use it in whatever tool you use to manage the database

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

 

[Bamarama]

ok. so now, ANY new code gives me this error.

ANY time I do a Set whatever = conn.execute("select....

i get this same error. Could this be some IIS setting gone wrong or something? the codes work fine within the DB when tested, it is just when I am writing new code. ALL of the old code using this method works fine. It is just new code. Doesn't make any dang sense. Any ideas??


seriously, I can't do squat until I fix this.....

 

[tsuji]

[tt]> [/tt]Conn.Open = "Provider=sqloledb; Data Source=dbs5.myhost.com ;..."
Never heard connection object had an open property, it has an open method all right!
[tt] Conn.Open[highlight] [/highlight]"Provider=sqloledb; Data Source=dbs5.myhost.com ;..."[/tt]

 

[ChrisHirst]

Good catch

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

 

[Bamarama]

changed

Conn.Open = "Provider=sqloledb;

to

Conn.Open "Provider=sqloledb

getting same error

 

[Bamarama]

You know, I appreciate all the help here. And thanks for trying.....

and ummm..... i feel like such an idiot now.



I figured it out. I almost want to just not say how and leave and stuff but I can't.

It is a HUGE help when you actually include the connection string on the page you wish to use the connection on
<!--#include file="connection.asp"--> is a big help.


******* feeling like an idiot now ******

 

[tsuji]

I don't what the op's trying to say and what has impacted their way of thinking, such as include... But you know, the same error does mean a thing as to what to code or what not. It is not a trial and error. Why not say it is a typo or something?

 

[Bamarama]

well, because I am an honest person, I had to be honest.

Second, if someone searches for the same error, this lets them know exactly what happened, and might have them look for a simple solution, and not complex like I was looking for.

 

[tsuji]

I have some typo in my messge, but you probably have got the meaning right, though. But, are you trying to say with an equal sign, it works?! Is that what you mean by honest?

 

[Bamarama]

yes, it works with or without the =

the issue was, I didn't actually tell the page to open the db. I always do this by having a connection page with the string. then use

<!--#include file="connection.asp"-->

on the pages that need the DB to open, then use

<%
Conn.Close
Set Conn = Nothing
%>

to close it.

So I failed to actually open the DB, therefore, there was no object, and that was causing the errors.