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)
 Can't create new web link		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Eladon
Starting Member

Canada
27 Posts
Posted - 08 March 2001 :  15:57:21  Show Profile
When I try to create a new web link, I get the following message:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/forum/inc_functions.asp, line 659

This is a new site set up with no mods, using the Access database that came with the software (but updated to Access 2000) on a fully updated Win NT 4.0 IIS Server. Practically straight out of the box install, and yet this doesn't work! What's up?

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 08 March 2001 :  16:19:03  Show Profile  Visit HuwR's Homepage
could you tell me wether you are using NT or DB authorisation ?
Go to Top of Page

Eladon
Starting Member

Canada
27 Posts
Posted - 08 March 2001 :  18:18:35  Show Profile
quote:

could you tell me wether you are using NT or DB authorisation ?


Good question, I meant to mention that. I am using NT Authorization.
Go to Top of Page

thwx3
Starting Member

China
2 Posts
Posted - 20 March 2001 :  01:42:22  Show Profile  Visit thwx3's Homepage  Send thwx3 an ICQ Message
for quick solution, the m_name must equal to m_username. it should be either the code problem or design problem...

will advise if the appropriate changes can be applied to fix this problem.

Steven 8-)
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 20 March 2001 :  02:05:02  Show Profile
Ok, try this:

around line 659 of inc_functions.asp you'll find this function:


function getMemberID(fUser_Name)
 
	'## Forum_SQL
	strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
	strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
	strSql = strSql & " WHERE M_NAME = '" & fUser_Name & "'"
 
	rsGetMemberID = my_Conn.Execute(strSql)
 
	getMemberID = rsGetMemberID("MEMBER_ID")
 
end function


Change the red highlighted line above to this:


	strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & fUser_Name & "'"


See if that fixes it.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 20 March 2001 :  02:08:02  Show Profile
discussion continued here: http://forum.snitz.com/forum/link.asp?TOPIC_ID=6231
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.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07