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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 Object required: 'my_Conn'		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

fredericrochais
Starting Member

United Kingdom
5 Posts
Posted - 09 February 2001 :  13:49:16  Show Profile  Visit fredericrochais's Homepage
The forum I have set up is currently returning the following errors when the user is not logged in when executing default.asp:

Microsoft VBScript runtime error '800a01a8'

Object required: 'my_Conn'

/forum/default.asp, line 75
the code is as follow:
69 '## Forum_SQL - Get all Forums From DB
70 strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_STATUS, "
71 strSql = strSql & strTablePrefix & "CATEGORY.CAT_NAME "
72 strSql = strSql & " FROM " & strTablePrefix & "CATEGORY "
73 strSql = strSql & " ORDER BY " & strTablePrefix & "CATEGORY.CAT_NAME ASC;"
74
75 set rs = my_Conn.Execute (strSql)
76 %>

or when executing policy.asp

Microsoft VBScript runtime error '800a01a8'

Object required

/forum/inc_footer.asp, line 82
the code is as follow:
81 </body>
82 </html>
83 <% my_Conn.Close %>
84 <% set my_Conn = nothing %>

It seems obvious that something related to my_Conn is (not) happening, but I do not know what.
Help would be very much appreciated

Fred

HuwR
Forum Admin

United Kingdom
20600 Posts
Posted - 09 February 2001 :  13:53:33  Show Profile  Visit HuwR's Homepage
it looks like there is something wrong with your inc_top, theis is where my_conn is defined.

Do you have a URL we can look at.

'Resistance is futile'
Go to Top of Page

fredericrochais
Starting Member

United Kingdom
5 Posts
Posted - 09 February 2001 :  13:56:43  Show Profile  Visit fredericrochais's Homepage
the URL is http://www.researchcorporation.net/forum

the version is: Snitz_Forums_2000_V3_1_SR4

Fred
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts
Posted - 09 February 2001 :  14:22:23  Show Profile  Visit HuwR's Homepage
check your setting in config.asp, inc_top says this

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 

/forum/inc_top.asp, line 77


'Resistance is futile'
Go to Top of Page

fredericrochais
Starting Member

United Kingdom
5 Posts
Posted - 27 February 2001 :  16:59:38  Show Profile  Visit fredericrochais's Homepage

Thanks for your help.
There was no connection problem as far as I can tell. After a bit of boggering about I got the message that I needed updating the database. In the latest version there is an additional table. Don't if it is related but I updated the database, a bit more jiggling and it is all working now.
I am looking at upgrading from access to SQL Server. Could you tell me where I can download a ready made SQL server database to which I could export my access versions?
Anyway this forum is so good that the demo on our site is now used by a non profit making organisation, an exhibition company, and we 're about to sign on a university. Access might get stretched even 2000.

Thanks again


Fred
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.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07