vbman995 Moderator

Joined: 19 Aug 2005 Posts: 264 Location: Planet Earth
|
Posted: Nov 10th, 2005 05:07 PM Post subject: Ok Guys help me out here: ASP |
|
|
I am terrible at ASP, actually I don't know a thing about asp.
I need to change this code so that it opens the file of mywebsite.com/fups.mdb and not C:\fups.mdb:
| Code: |
<%
'This should be the only place you have to edit the
'connection information.
dim objConn, rs, strSQL
set objConn = Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.Recordset")
'CHANGE THIS LINE ONLY!!!
objConn.Open "DSN=MS Access Database;DRIVER=(Microsoft Access Driver (*.mdb));DBQ=C:\fups.mdb"
'In each ASP file exists the following code:
'strSQL = "WHATEVER NEEDS TO BE DONE"
'set rs = objConn.Execute(strSQL)
%> |
|
|