im trying to get the ZBIT Chat software works with the forum database for authenication..the default application comes with a Access database and what im trying to use is the SQL database of WWG Forums.. i 've as well disable password encryption on the WWG Forums database..
the default code of zbit chat t authenicate users against the Access database is:
-------------------------------------------
'Verifies user Id against the password
'you most likely are going to rewrite this function to accomodate your database
'the code here is just a sample
Function UserAuthenticate(sUserName,sPassword)
Dim oRs
Set oRs=Server.CreateObject("ADODB.Recordset")
oRs.Open "select user_name from users where user_name='" & EscQ(sUserName) & "' AND password='" & EscQ(sPassword) & "'" ,_
"Provider=SQLOLEDB; Data Source=" & Server.MapPath("db1.mdb"),3,3
UserAuthenticate=NOT (oRs.BOF AND oRs.EOF)
Set oRs=Nothing
End Function
------------------------------------------
I reworte the code to make it work with WWG forums SQL database..
'Verifies user Id against the password
'you most likely are going to rewrite this function to accomodate your database
'the code here is just a sample
Function UserAuthenticate(sUserName,sPassword)
Dim oRs
Set oRs=Server.CreateObject("ADODB.Recordset")
oRs.Open "select username, password from dbo.tblAuthor where username='" & EscQ(sUserName) & "' AND password='" & EscQ(sPassword) & "'" ,_
"Provider=Microsoft.Jet.OLEDB.4.0; Server=SERVER2003;Database=dbjg;UID=farooq;PWD=123456",0,1,1
UserAuthenticate=NOT (oRs.BOF AND oRs.EOF)
Set oRs=Nothing
End Function
---------------------------------------------------------
and i get a Error 500 - internet server error when the username and password is enterned and the login button is hit in the ZBit chat application..
i tried to set up a new SQL database with the reqired tables of username and password and then try the chat application to work with SQL databse and would still get error 500.. any ideaz???
Topic Options
Post Options
Thanks(0)
