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 / Classic ASP versions(v3.4.XX)
 rsGetMemberID.open strSql, my_Conn ??
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Etymon
Advanced Member

United States
2393 Posts

Posted - 16 May 2002 :  09:26:20  Show Profile  Visit Etymon's Homepage
I researched the Snitz archives and current posts, implemented the suggestions, even tried using the inc_functions.asp from v40_b03 (Beta), and I still come up with the same problem:

quote:
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/stolen_horse_asp/forum/inc_functions.asp, line 1791


In line 1791 of inc_functions.asp I see the code below. What does this do?

Set rsGetMemberID = Server.CreateObject("ADODB.Recordset")
rsGetMemberID.open strSql, my_Conn

I have the Events MOD, the LinkManager MOD, and the Classifieds MOD installed.


Etymon

Edited by - etymon on 16 May 2002 09:27:01

Chiz
Junior Member

245 Posts

Posted - 16 May 2002 :  11:00:41  Show Profile
I've been struggling with this same error also for weeks. I believe it's an intermittent error with OLE DB/ADO.

Ruirib, I think we got another one here.

My websites: PalmVenue :: PV Mobile
My Snitz MODs: Categorized Icons
Go to Top of Page

Etymon
Advanced Member

United States
2393 Posts

Posted - 16 May 2002 :  12:05:45  Show Profile  Visit Etymon's Homepage
My forum is currently on Windows 98 Second Edition with Personal Web Server from the same Win 98 SE CD-ROM from my home PC.

I am using the Access strConnString called:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000

I am not sure if browsers make much difference, but I am using IE 5.0 and NN 4.5. Both display the forums fine until they both get to that message.

My forum is not online (Internet).

Thanks for the help!


Etymon



Edited by - etymon on 16 May 2002 13:34:45
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 16 May 2002 :  15:03:28  Show Profile
If you're working off the distributed access db, it's an A97 database. You might solve the problem if you convert the database to A2000+ version (you need MS Access 2000+ to do this).



======
Doug G
======
Go to Top of Page

Etymon
Advanced Member

United States
2393 Posts

Posted - 16 May 2002 :  20:58:18  Show Profile  Visit Etymon's Homepage

That sounds like an option. I'll do that. Thanks!


Etymon

Go to Top of Page

Etymon
Advanced Member

United States
2393 Posts

Posted - 18 May 2002 :  03:23:36  Show Profile  Visit Etymon's Homepage

On a whim, I decided to copy the topic.asp file from the new Snitz 3.3.04 version and paste it into my test forum, and guess what?

The forum works now!!!

Go to Top of Page

wdglide
Starting Member

5 Posts

Posted - 20 May 2002 :  23:27:32  Show Profile
AWESOME!

I was having the same problem and 3.3.04 topic.asp worked!

(I only have the event mod installed)

Go to Top of Page

nuntarit
Starting Member

2 Posts

Posted - 21 May 2002 :  06:36:33  Show Profile
How did you fix your problem?
My keep say

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/webboard/inc_functions.asp, line 717

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 May 2002 :  07:36:13  Show Profile  Send ruirib a Yahoo! Message
quote:

How did you fix your problem?
My keep say

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/webboard/inc_functions.asp, line 717


Read these:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=16559

http://www.dougscode.com/faq/default.asp?id=q1020

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
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.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07