| Author |
 Topic  |
|
|
james1415
Starting Member
1 Posts |
 Posted - 25 August 2001 : 07:27:01
|
Lo,
Ive got an admin script where I post my news and articles, I just copied and pasted to article script and changed it so it SHOULD work for the guides database, when tryign to view the guide.asp page, it comes up with this error:
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 0x7c4 Thread 0x7ac DBC 0x2771024 Jet'.
/finalsite/guide.asp, line 48
Also, when trying to view the admin sript for the guides this comes up:
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 0x7c4 Thread 0x7ac DBC 0x27a2fa4 Jet'.
/finalsite/admin/guide_admin.asp, line 17
Then when trying to add an article this comes up:!!!
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 0x7c4 Thread 0x7ac DBC 0x2795ff4 Jet'.
/finalsite/admin/guide_add_go.asp, line 7
Please can someone help me!!!!!!
|
|
|
MorningZ
Junior Member
USA
169 Posts |
Posted - 25 August 2001 : 09:33:23
|
| what are the respective Lines of code that cause this? ( always helps to see ) |
 |
|
|
james1415
Starting Member
1 Posts |
Posted - 25 August 2001 : 09:55:27
|
Ok - This is for the first porblem:
<%
Set Connect = Server.CreateObject("ADODB.Connection")
This is line 48 >>>>>> Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.Mappath("../dbase/guides.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")
view = "SELECT * FROM guides ORDER BY ID DESC"
RecSet.Open view, Connect, adOpenStatic, adLockOptimistic
Do Until RecSet.EOF
%>
<tr>
<td width=
Second problem code:
<!-- #include virtual="../../dbase/adovbs.inc" -->
<table border="0" cellspacing="1">
<%
Set Connect = Server.CreateObject("ADODB.Connection")
This is line 17 >>>>> Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.Mappath("../../dbase/guides.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")
view = "SELECT * FROM guides ORDER BY ID DESC"
RecSet.Open view, Connect, adOpenStatic, adLockOptimistic
Do Until RecSet.EOF
%>
<tr>
<td>
<table bordercolor="#808080" border="1" cellspacing="0" bordercolorlight="#C0C0C0" bordercolordark="#808080" cellpadding="3">
<tr>
and finally, problem 3, the code:
<!-- #include virtual="../../dbase/adovbs.inc" -->
<%
Set Connect = Server.CreateObject("ADODB.Connection")
This is line 7 >>>>>Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.Mappath("../../dbase/guides.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")
add = "
I hope this helps...
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 25 August 2001 : 18:17:14
|
Check here: http://www.dougscode.com/faq/default.asp?id=q1018
I'm not sure that you want to mappath with a relative path. Here is a snip from the documentation:
"Path
Specifies the relative or virtual path to map to a physical directory. If Path starts with either a forward (/) or backward slash (\), the MapPath method returns a path as if Path is a full virtual path. If Path doesn't start with a slash, the MapPath method returns a path relative to the directory of the .asp file being processed."
======
Doug G
====== |
|
|
|
MorningZ
Junior Member
USA
169 Posts |
Posted - 25 August 2001 : 22:57:38
|
yes, it is blaringly obvious that wherever you got your connection string code from, it sucks....
use the ones in "config.asp" from the Snitz package.. there are like 3 options for Access versions and Virtual and Absolute Paths
 |
|
|
| |
Topic |
|
Topic Locked
