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: MOD Implementation
 Member Award MOD		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

UnderRated
Starting Member

Portugal
39 Posts
Posted - 12 April 2005 :  16:25:28  Show Profile  Visit UnderRated's Homepage
Hi, I have installed the member award mod and it seamed to be working fine but after i choose all the settings for the award and click submit award i get this error

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'M'.

/forum/admin_awards.asp, line 84

what should i do?

Jorrit787
Average Member

Netherlands
681 Posts
Posted - 12 April 2005 :  21:03:22  Show Profile  Visit Jorrit787's Homepage  Send Jorrit787 an AOL message  Send Jorrit787 a Yahoo! Message
Post the bit of code around line 84 here, so people can take a look.
eXtremeGossip
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts
Posted - 13 April 2005 :  17:43:51  Show Profile  Visit UnderRated's Homepage
starting at line 83

set rsUpdateAward = Server.CreateObject("ADODB.Recordset")
set rsUpdateAward = my_conn.execute(strSQL)

Response.Write " <br><br><p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """>Configuration Posted!</font></p>" & vbNewLine & _
" <meta http-equiv=""Refresh"" content=""2; URL=admin_awards.asp"">" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """>Congratulations!</font></p>" & vbNewLine & _
" <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""admin_home.asp"">Back To Admin Home</font></a></p>" & vbNewLine
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts
Posted - 13 April 2005 :  18:04:32  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
It might be a bit more informative if you include the following red line and post the result.

set rsUpdateAward = Server.CreateObject("ADODB.Recordset")
Response.Write strSQL
set rsUpdateAward = my_conn.execute(strSQL)
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

UnderRated
Starting Member

Portugal
39 Posts
Posted - 13 April 2005 :  19:15:33  Show Profile  Visit UnderRated's Homepage
here's what i'm getting now once i hit the submit award button

HTTP 500 - Internal Error in the Server
Internet Explorer
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts
Posted - 13 April 2005 :  19:51:43  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Goto Tools > Internet Options > Advanced

Uncheck "Friendly Http Error Messages"

Refresh the page. It should tell you what the error was.
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
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.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07