Snitz Forums 2000 - Error creating Web Link

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Current Version (Old)

Error creating Web Link

New Topic

Topic Locked

Printer Friendly

Author

Topic

Eladon
Starting Member

Canada
27 Posts

Posted - 12 March 2001 : 13:48:14

Wow, stuff get's buried in this forum pretty darn quick! Anyway, let's try this again...

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. I am using NT authentication, but not the auto-logon (I get errors if I do that too). Practically straight out of the box install, and yet this doesn't work! What's up?

thwx3
Starting Member

China
2 Posts

Posted - 20 March 2001 : 01:43:59

for quick solution, the m_name must equal to m_username. (ie. manually update the record or thru member profile by admin right) 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-)

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 March 2001 : 02:06:49

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.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.21 seconds.