|
| |
|
|
51
Posts: 49
Joined: 5/30/2002
From:
Status: offline
 |
Anyone had this problem? - 9/24/2003 8:09:32
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
I get this error from this line of code.
Conn.Open "bugs", , ""
am I missing some asp patch or bad is this bad code?
Any ideas, please let me know.
Thanks for your time
|
|
|
|
51
Posts: 49
Joined: 5/30/2002
From:
Status: offline
|
RE: Anyone had this problem? - 9/24/2003 10:05:49
here is that block of code.
REM// Check for user authorization into selected project via database
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "bugs", , ""
sql = "SELECT tblAuthorized.sUser_Name, tblAuthorized.iID, tblProjects.iProject_ID, tblProjects.sProject_Name, tblAuthorized.iAuthorized "
sql = sql & "FROM tblProjects INNER JOIN tblAuthorized ON tblProjects.iProject_ID = tblAuthorized.iAuthorized "
sql = sql & "WHERE tblAuthorized.sUser_Name='" & sUser_Name & "'"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
here is there error after freindly error was turned off.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Provider (0x80004005)
Unspecified error
/bugs/html/login.asp, line 70
Thanks again
| |
|
|
|
rdouglass
Posts: 9270
From: Biddeford, ME USA
Status: offline
|
RE: Anyone had this problem? - 9/24/2003 15:13:35
quote:
Conn.Open "bugs", , ""
I think the problem is right there. You need to have a DSN string there. Something like:
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("../fpdb/bugs.mdb")
I have no idea if that is the correct string or not, but that's how I use 'em. There also seems to be an extra 'object' in there. IMO the code should look something like:
........
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("../fpdb/bugs.mdb")
sql = "SELECT tblAuthorized.sUser_Name, tblAuthorized.iID, tblProjects.iProject_ID, tblProjects.sProject_Name, tblAuthorized.iAuthorized "
sql = sql & "FROM tblProjects INNER JOIN tblAuthorized ON tblProjects.iProject_ID = tblAuthorized.iAuthorized "
sql = sql & "WHERE tblAuthorized.sUser_Name='" & sUser_Name & "'"
set rs=Conn.Execute(sql)
........
At least that's how I'd try it. Also the Conn.Open line will probably need to be adjusted based on your DB type, name, and location.
Hope it helps...
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
Is it a VBScript variable? If so, it should be: 