Question onGregoory's Clan Files

Hi All,

I am sorry to bother everyone, but I have been recently looking at the clan files that Gregoory released a while back. I was wondering if Gregoory or anyone who has worked with the files can help me with this error. Upon running the files, I initially noticed that when I was registering a new clan, it was frozen ingame on "Registering". But if I forced myself to disconnect and relogged, I did have the new clan that I had created initially; though it was stalled at "Registering".

However, once the clan was created, I was unable to invite anyone to the clan. And though I leave the clan and disband it, the clan still continues to exist in CT.dbo in ClanDB.

So in looking at the scripts via the browser, I got this error:

Code:

---

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near '='.

/ClanSystem/clan/odbc.class.asp, line 96

---

I am guessing this is source of the errors that I am facing with clans. So can someone please help me to clear this error :). Thank you in advance and Happy Holidays :).

I dont have the files infront of me but if the "odbc.class.asp" is a configuration file make sure you didnt changed some signs like ",' etc
that would be easier if you could post here that script.

Sorry I was a bit busy to respond any sooner.

With regards to the files, I have not changed anything in any of the files other than filling in the appropriate information in the configuration.asp. If you want the info from odbc.class.asp, here you go (DK if this is too much of a spam, please do feel free to delete the code paste ^^)

Code:

---

<%
' Gregoo - March 2010 - http://gregoo.ftp.free.fr/pt

' ODBC class to connect to the database and execute queries
Class ODBC
        '@private oLink : link to the database
        '@private sInfo : connection string
        '@private oRecord : current query result set
        '@private oOutput : error messages
        Private oLink
        Private oRecord
        Private sInfo
        Private oOutput
       
        'Record property
        Public Property Get Record()
                If oRecord Is Nothing Then
                        Connect()
                End If

                Set Record = oRecord
        End Property
               
        'Count
        Public Property Get Count()
                If oRecord Is Nothing Then
                        Connect()
                End If
               
                Count = oRecord.RecordCount
        End Property

        'Value
        Public Function Value(Key)
                If oRecord Is Nothing Then
                        Value = ""
                End If
               
                Value = oRecord(Key).Value
        End Function
       
        'Move
        Public Sub Move()
                If Not oRecord Is Nothing Then
                        oRecord.MoveNext
                End If
        End Sub
       
        '@constructor
        Private Sub Class_Initialize()
                Set oLink = Nothing
                Set oRecord = Nothing
                Set sInfo = Nothing
        End Sub
       
        'Parameters
        '@param host : string
        '@param base : string
        '@param username : string
        '@param password : string
        Public Sub Parameters(sHost, sBase, sUsername, sPassword, ByRef rOutput)
                sInfo = "Provider=SQLOLEDB; Data Source=" & sHost & "; Initial Catalog=" & sBase & "; User ID=" & sUsername & "; Password=" & sPassword & ";"
                set oOutput = rOutput
        End Sub
       
        'Connection to the SQL server
        Private Sub Connect()
                Set oLink = Server.CreateObject("ADODB.Connection")
               
                On Error Resume Next
                oLink.Open(sInfo)
               
                If Err.Number <> 0 Then
                        Set oLink = Nothing
                       
                        oOutput.Code 1000
                End If
               
                Set oRecord = Server.CreateObject("ADODB.Recordset")
        End Sub
       
        'Request
        '@param format : string
        '@param arguments : obj[]
        Public Sub Request(sString)
                If oLink Is Nothing Then
                        Connect()
                End If
               
                If Not oRecord Is Nothing Then
                        If oRecord.State <> 0 Then
                                oRecord.Close
                        End If
                End If
                       
                oRecord.Open sString, oLink, 3
        End Sub

        '@destructor
        Private Sub Class_Terminate()
                If Not oRecord Is Nothing Then
                        If oRecord.State <> 0 Then
                                oRecord.Close
                        End If
                End If
               
                Set oRecord = Nothing
               
                If Not oLink Is Nothing Then
                        If oLink.State Then
                                oLink.Close
                        End If
                End If
               
                Set oLink = Nothing
        End Sub
End Class
%>

---

And line 96 in particular refers to

Code:

---

                oRecord.Open sString, oLink, 3

---

I hope this will help further the post to get a solution ^^.

Open your configuration.asp

there should be lines like this:

Code:

---

odbcHost    = "127.0.0.1"
odbcUsername = "sa"
odbcPassword = "password"
odbcDatabase = "clandb"

---

You probably missing quotation somewhere, for example yours might look like this:

Code:

---

odbcHost    = 127.0.0.1"

---

But I am not 100% sure, I lost files somewhere on hdd >=P

Vormav, I looked at my configuration.asp and nothing is wrong there. It seems that I get the above error

Code:

---

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near '='.

/ClanSystem/clan/odbc.class.asp, line 96

---

As soon as I put in my password, as my userid/pw for the my sql database is Sirus/Cero.

Code:

---


odbcHost    = "127.0.0.1"
odbcUsername = "Sirus
odbcPassword = "Cero"
odbcDatabase = "clandb"

---

So prior to putting in the password, I get "Error Code = 1000" , which is seen on line 76 of the odbc.class.asp. However, as soon as I put in my password, I get the above error.

Just a question of curiosity; do these clan scripts require that I have ODBC access setup to the sql server as well?

Quote:

---

Originally Posted by osirus

Vormav, I looked at my configuration.asp and nothing is wrong there. It seems that I get the above error

Code:

---

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near '='.

/ClanSystem/clan/odbc.class.asp, line 96

---

As soon as I put in my password, as my userid/pw for the my sql database is Sirus/Cero.

Code:

---


odbcHost    = "127.0.0.1"
odbcUsername = "Sirus
odbcPassword = "Cero"
odbcDatabase = "clandb"

---

So prior to putting in the password, I get "Error Code = 1000" , which is seen on line 76 of the odbc.class.asp. However, as soon as I put in my password, I get the above error.

---

If your configuration look like that than everything is wrong :)
Change it to:
odbcHost = "127.0.0.1"
odbcUsername = "sa"
odbcPassword = "your_password_to_ms_sql_here"
odbcDatabase = "clandb"

unless your default login is Sirus than:

Quote:

---

odbcUsername = "Sirus

---

You are missing " here.

Quote:

---

Originally Posted by osirus

Just a question of curiosity; do these clan scripts require that I have ODBC access setup to the sql server as well?

---

I can read "Provider=SQLOLEDB" from what you posted but because I don't have files anymore I can't be sure so create ODBC connection called clandb just in case.

Oh. I correct by putting in " and it is still the same error.

I will post up the link for Gregg's clan files that I have for you to take a look at it Vormav. If Gregg or DK are against it, please do message me and I will take it down immediately.

Are you sure its same error after you close quotation?
Try deleting your files and replace them with files you uploaded, you might edit something by mistake. Edit only configuration.asp

Could you tell me what you putting in SQL Server Management Studio to login?

Server type: Database Engine
Server name: ???
Authentication: SQL Server Authentication
Login: ???
Password: ???

Because,
odbcHost = "127.0.0.1" = Server name
odbcUsername = "sa" = Login
odbcPassword = "password" = Password
odbcDatabase = "clandb" = don't touch that :)



I don't have IIS to check your files and I am not planing to install it again, I prefer Apache :)

You guys are looking in the wrong direction. The error isn't in odbc.class or the configuration file.

It's written Microsoft OLE DB Provider for SQL Server error '80040e14', and if you look at line 96, it's the line actually executing the SQL request: oRecord.Open sString, oLink, 3.

The error is a syntax error inside a SQL query.

On a side note, I've removed those files from my website cause they are not really finished so don't expect it to work perfectly.

Ah ok Gregg. If you wish for me to remove the link for the Clan files. Please do tell me, and I will remove them :). Happy Holidays :)

how to setup Gregoorys clan system??
what is the link of the setup??

@cold1234
Please read what Gregg has posted. The files are incomplete, so they are not fully correct and you will face numerous errors. In order to prevent further questions, I have removed them. I should have done them sooner, but I have been busy seeing as it is the holidays ^^.

If you are wishing to setup Clan's, please follow the *Stickied (if that is a a word x.x) post on the main page by Shagpub that contains all the information on setting up Clans successfully. Please consult that guide thoroughly as the the numerous posts in that thread have everything that you need to successfully set up clans. :)

OT

Spoiler:

Yes it is, a new jargon word, maybe. But a word none-the-less.

Also Wiktionary defines it as "Simple past tense and past participle of sticky."

The Urban Dictionary holds many examples of it's use in modern English, and suggests that, when referring to a "Sticky Topic" it should be spelled with an apostrophe. "Sticky'd" I prefer the form "Stickied" or "Stickyed" as it complies with the more common rules of past tense / past participial words ending with "y". "Dismay" = "Dismayed", "Deploy" = "Deployed", "Fry" = "Fried", "Spy" = "Spied", "Pry" = "Pried".

Besides which, I was taught (unlike the U.S. English) that an apostrophe in the middle of a word ("there's", "isn't", "don't" etc.) is indicative of abbreviation. (ie."there is", "is not", "do not" etc.) where possessive apostrophes always come at the end of the word. (ie "Simons'", "Annies'" etc.) In U.S. English "Simon's" or "Annie's" is (I believe) correct. But it always looks wrong to me, I read it as "Simon is" or "Annie is". XD So "Annie's going down to town later." or "That's Annies' bucket." and then I know where I am in the sentence before I've got to the end of it.:lol:

The only thing you may be abbreviating is the "e" from "stickyed" to "sticky'd", but that would be pronounced the same way, so I don't see the point in using an abbreviative apostrophe.

Isn't the post sticky, simply because it was pinned ?
You guys are complicated :ott1:

please help me on this
when i typng 127.0.0.1/clan/claninsert.apsx

saying me like ths


Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

And the result of checking "the web server" "application event log" was...?

Quote:

---

Originally Posted by bobsobol

And the result of checking "the web server" "application event log" was...?

---

Wild guess:
- "Duh..."
- ...
- *drools*
- *bombs forums*