M
Michaelgs
I posted
Subject: Still can't figure out how to populate my Database on the General
questions board.
After following all the instructions I received this Error Message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1ba4 Thread 0xfb0
DBC 0x2b34fdec Jet'.
/MSTutor/_private/logon.inc, line 34
and this is line 34
objCN.Open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & _
then Stefan B Rusynko suggested I that I should learn ASP
However I can't learn ASP in this short a time.
I also wrote to my Host and they tested and send me back a note with a code
that proved that they could connect to te DB.
this is their code:
<%
path = server.mapPath("/MSTutor/fpdb/")
database = "logon.mdb"
username = ""
password = ""
connString=("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & path & "\" &
database & "';User Id=" & username & ";Password=" & password)
Set objConn = CreateObject("ADODB.Connection")
objConn.open = connString
%>
<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'
'http://www.w3.org/TR/html4/loose.dtd'>
<html><head><title>ASP with Access - By Clyde</title><meta
http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>
</head><body style='background-color:#ffffff;' text='000000' link='0000FF'
vlink='990099' alink='990099' topmargin='0' leftmargin='0' marginheight='0'
marginwidth='0'>
<center><h1>ASP with Access Database</h1><b>Make sure the database is in the
access_db folder in the hosting account.</b><br><br><h3>This script written
especially for the logon.mdb database.</h3>
<br><h2>The minimum connection code is:</h2><table cellspacing=0><tbody>
<tr><td align=left style="background-color:#eee685;">path =
server.mapPath(<span style="color:#8B0A50;">"/MSTutor/fpdb/"</span>)</td></tr>
<tr><td align=left style="background-color:#eee685;">database = <span
style="color:#8B0A50;">"logon.mdb"</span></td></tr>
<tr><td align=left style="background-color:#eee685;">username = <span
style="color:#8B0A50;">""</span></td></tr>
<tr><td align=left style="background-color:#eee685;">password = <span
style="color:#8B0A50;">""</span></td></tr>
<tr><td align=left style="background-color:#eee685;">connString=(<span
style="color:#8B0A50;">"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='"</span> & path & <span style="color:#8B0A50;">"\"</span> & database
& <span style="color:#8B0A50;">"';User Id="</span> & username & <span
style="color:#8B0A50;">";Password="</span> & password)</td></tr>
<tr><td align=left style="background-color:#eee685;">Set objConn =
CreateObject(<span style="color:#8B0A50;">"ADODB.Connection"</span>)</td></tr>
<tr><td align=left style="background-color:#eee685;">objConn.open =
connString</td></tr>
<tr><td align=left>*********************************** Do Something
*************************************</td></tr>
<tr><td align=left style="background-color:#eee685;">objConn.close</td></tr>
<tr><td align=left style="background-color:#eee685;">set objConn =
nothing</td></tr>
</tbody></table>
<h1>Connection Test Successful!</h1>
</center></form></body></html>
<%
objConn.close
set objConn = nothing
%>
All this tells me that I still am not able, having used the FrontPage form
wizard, to connect my form to my DB.
Hence this post trying to find a reasonable, experience programmer to go
into my site and connect my form to my DB.
is anyone willing to help me?
I would like to finish my site, but Iam just palin stuck.
Thank you for reading this.
Michael
Subject: Still can't figure out how to populate my Database on the General
questions board.
After following all the instructions I received this Error Message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1ba4 Thread 0xfb0
DBC 0x2b34fdec Jet'.
/MSTutor/_private/logon.inc, line 34
and this is line 34
objCN.Open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & _
then Stefan B Rusynko suggested I that I should learn ASP
However I can't learn ASP in this short a time.
I also wrote to my Host and they tested and send me back a note with a code
that proved that they could connect to te DB.
this is their code:
<%
path = server.mapPath("/MSTutor/fpdb/")
database = "logon.mdb"
username = ""
password = ""
connString=("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & path & "\" &
database & "';User Id=" & username & ";Password=" & password)
Set objConn = CreateObject("ADODB.Connection")
objConn.open = connString
%>
<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'
'http://www.w3.org/TR/html4/loose.dtd'>
<html><head><title>ASP with Access - By Clyde</title><meta
http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>
</head><body style='background-color:#ffffff;' text='000000' link='0000FF'
vlink='990099' alink='990099' topmargin='0' leftmargin='0' marginheight='0'
marginwidth='0'>
<center><h1>ASP with Access Database</h1><b>Make sure the database is in the
access_db folder in the hosting account.</b><br><br><h3>This script written
especially for the logon.mdb database.</h3>
<br><h2>The minimum connection code is:</h2><table cellspacing=0><tbody>
<tr><td align=left style="background-color:#eee685;">path =
server.mapPath(<span style="color:#8B0A50;">"/MSTutor/fpdb/"</span>)</td></tr>
<tr><td align=left style="background-color:#eee685;">database = <span
style="color:#8B0A50;">"logon.mdb"</span></td></tr>
<tr><td align=left style="background-color:#eee685;">username = <span
style="color:#8B0A50;">""</span></td></tr>
<tr><td align=left style="background-color:#eee685;">password = <span
style="color:#8B0A50;">""</span></td></tr>
<tr><td align=left style="background-color:#eee685;">connString=(<span
style="color:#8B0A50;">"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='"</span> & path & <span style="color:#8B0A50;">"\"</span> & database
& <span style="color:#8B0A50;">"';User Id="</span> & username & <span
style="color:#8B0A50;">";Password="</span> & password)</td></tr>
<tr><td align=left style="background-color:#eee685;">Set objConn =
CreateObject(<span style="color:#8B0A50;">"ADODB.Connection"</span>)</td></tr>
<tr><td align=left style="background-color:#eee685;">objConn.open =
connString</td></tr>
<tr><td align=left>*********************************** Do Something
*************************************</td></tr>
<tr><td align=left style="background-color:#eee685;">objConn.close</td></tr>
<tr><td align=left style="background-color:#eee685;">set objConn =
nothing</td></tr>
</tbody></table>
<h1>Connection Test Successful!</h1>
</center></form></body></html>
<%
objConn.close
set objConn = nothing
%>
All this tells me that I still am not able, having used the FrontPage form
wizard, to connect my form to my DB.
Hence this post trying to find a reasonable, experience programmer to go
into my site and connect my form to my DB.
is anyone willing to help me?
I would like to finish my site, but Iam just palin stuck.
Thank you for reading this.
Michael