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???

let Internet Explorer tell you exactly what's wrong....

in IE, click on "Tools", then "Options", then the "Advanced" tab, scroll until you see the checkbox, "Show Friendly errors"... uncheck that

now you'll see what the error is...

i can tell you one error by quickly looking at your code is that you don't know the difference between a connection string and a connection object

Microsoft JET Database Engine error '80004005'

Could not find installable ISAM.

/chat/english/chatapi.asp, line 62

and line 62 is:
 oRs.Open "select username, password from dbo.tblAuthor where username='" & EscQ(sUserName) & "' AND password='" & EscQ(sPassword) & "'" ,_

i get some idea now.. this thing works ok with Access but probably the connection object is different for SQL..what could it be???