Okay so I just recently landed an internship. I am working on some code to link my database onto the IIS server. Right now I am running a windows 8 with IIS. I have created nothing extra other than a database through microsoft access 2010. I type up some really basic code but I am soo new to coding that I'm lost right now. I have gotten a few different errors. My initial error was on line 12:
This error message I don't see anymore because it generated ANOTHER error message which is as follows:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/database.asp, line 14
Here is a look at the code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>JNET Database Connectiont</title>
Dim Connect, selectSQL, RecSet
Set Connect = CreateObject ("ADODB.Connection")
selectSQL = "SELECT * FROM hardware"
Set RecSet = mConnect.Execute ("selectSQL")
If NOT RecSet.EOF THEN
DO UNTIL RecSet.EOF
Response.Write RecSet("Companyname") & ", " & RecSet("Contactname") & "<BR><BR>"
Set RecSet = Nothing
Set Connect = Nothing
I have created a microsoft data link file so that I could configure setting for the database there. I also created a DSN connection for my database under data sources. My database file is named "Database". I am not sure what to do and if anyone could point me in the right direction so I can learn that would be greatly appreciated.