Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Object required while trying to run a query
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 03 January 2005 :  17:11:40  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I can not figure this out and I believe this is a server problem over at CrystalTech but not sure and wanted to double check.

I have a page that is accessing a database that works fine. Then out of nowhere we get a Object Required error message when its trying to do a select on the Access database. If you refresh the page then it loads fine and might not mess up on you again for awhile. In my opinion it can not be a code issue because it works 99.9% of the time. Anyone have any ideas?

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

Doug G
Support Moderator

USA
6493 Posts

Posted - 03 January 2005 :  19:42:41  Show Profile
If you have any on error resume next statements in your code take them out. If there is some server-side failure that is causing a connection or rs object to come up missing, you should see some other error message before "object required", unless of course it really is a code problem and your code neglects to create the object under certain circumstances.


======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 04 January 2005 :  00:57:19  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
See that is what is off is I do not have any on error resume next so it should give a error if something is going on with not being able to open the database. It gives a error saying not able to open the database when i am in the process of uploading a new database and trying to request the page.

Here is the code with the only thing I removed is pure HTML...
index.asp

<!--#include file="./config/config.asp"-->
<!--#include file="./config/inc_functions.asp"-->
<%
' # LETS GRAB THE TOP 3 PROPERTY'S
strSql = "SELECT TOP 3 P_ID"
strSql = strSql & ", P_Name"
strSql = strSql & ", P_SalePrice"
strSql = strSql & " FROM Property"
strSql = strSql & " ORDER BY P_Featured DESC"
strSql = strSql & ", P_SalePrice ASC"
set rs = my_Conn.Execute (strSql)


config.asp

ConfigConnectionString = "BLAHBLAHBLAHBLAH"
configImageLocation = "/images/internal/"
configPropertyImageLocation = "/images/property/"
configPropertyImagePhysical = "C:\inetpub\lakeshorerealty\images\property\"
configPropertysPerPage = 5
configRemoteHost = "mail19.webcontrolcenter.com"

set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open ConfigConnectionString

SessionAdminUsername = Session("AdminUsername")
SessionAdminPassword = Session("AdminPassword")

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

D3mon
Senior Member

United Kingdom
1685 Posts

Posted - 04 January 2005 :  06:03:24  Show Profile  Visit D3mon's Homepage
Sounds like they've moved to Web-farming their servers. We had a similar problem with a site using many Applicaton and Session variables which seemed to 'disappear' in the same way.


Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won"
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 04 January 2005 :  11:01:15  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
hummmm oh well thanks guys :-)

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 04 January 2005 :  15:19:14  Show Profile
Why are you referencing one of their mail servers?

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 04 January 2005 :  15:47:44  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
for a site that is hosted with them... since it just being used via the ip address and not a domain name thats the way they told me to do it

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07