Avatar billede styrelse Nybegynder
11. december 1999 - 17:47 Der er 1 kommentar og
1 løsning

Hvad fejler??

Ello

Hvad fejler i min kode??

Min fejlbesked er:

Microsoft OLE DB Provider for ODBC Drivers fejl '80004005'

[Microsoft][ODBC Driver Manager] Datakildenavnet blev ikke fundet, og der er ikke angivet en standarddriver.

forside2.asp, linje 4


<%
Conn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("statistik.mdb") & ";UID=admin;PWD=;"
set conn = server.CreateObject ("adodb.connection")
Conn.Open Conn
Conn.Execute "insert into PageViews (RecordID, PageVisited, WhenVisited) values ("_
& Session("RecordID") & ", 'Home', '" & Now() & "')"
%>
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("home.mdb") & ";UID=admin;PWD=;"
%>
<HTML>
<HEAD>
  <TITLE></TITLE>
<link rel="stylesheet" type="text/css" href="style.css">
<script language="JavaScript">

function preloadImages() {
if (document.images) {
var imgFiles = preloadImages.arguments;
if (document.preloadArray==null) document.preloadArray = new Array();
var i = document.preloadArray.length;
with (document) for (var j=0; j<imgFiles.length; j++) if (imgFiles[j].charAt(0)!="#")
{
preloadArray[i] = new Image;
preloadArray[i++].src = imgFiles[j];
} }
}

</script>
<script LANGUAGE="JavaScript">

img = new Image;

function changeImg(target, imgName) {
  img.src = imgName;
  document[target].src = img.src;
}

</script></HEAD>
<BODY onLoad="preloadImages('images/string1.gif','images/string2.gif','images/string3.gif','images/string4.gif','images/string5.gif','images/over1.jpg','images/over2.jpg','images/over3.jpg','images/over4.jpg','images/over5.jpg','images/but1_over.gif','images/but2_over.gif','images/but3_over.gif','images/but4_over.gif','images/but5_over.gif')" BGCOLOR="#000000">

<P>
<TABLE BORDER=0 BGCOLOR="#FFFFFF" CELLSPACING=0 CELLPADDING=0 align="center">
  <TR>
    <TD WIDTH=96 valign="top">
      <P><IMG SRC="images/back_p2.jpg" WIDTH=97 HEIGHT=124 ALIGN=top></P>
    </TD>
    <TD valign="top">
      <table width="456" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="456" colspan="4"><img src="images/back_p4.jpg" width=109 height=59 align=bottom><img src="images/back_p5.jpg" width=347 height=59 align=bottom></td>
        </tr>
        <tr>
          <td width="125" rowspan="2" valign="top"><img src="images/back_p1.jpg" width=106 height=65 align=top></td>
          <td width="117" height="5" valign="top"></td>
          <td width="200" valign="top" rowspan="2"><img src="images/logo.jpg" width=200 height=56 align=top></td>
          <td width="14" rowspan="2" valign="top"><img src="images/back_p6.jpg" width=14 height=65 align=top></td>
        </tr>
        <tr>
          <td width="117" height="60" valign="top"><br>
<div class=divsearch><form method="post" action="search_site.asp" name=""><input type="text" name="search" size="10">
              <input type=image src="images/search.jpg" width="23" height="23" align="absmiddle"></form></div></td>
        </tr>
      </table>
    </TD>
  </TR>
  <TR>
    <TD WIDTH=96 valign="bottom" height="250" background="images/border_td.jpg">
      <P><img src="images/back_p7.jpg" width="97" height="23"></P>
    </TD>
    <TD VALIGN=top rowspan="2">
      <P>
      <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=456>
        <TR>
          <TD>
            <P>
            <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=456>
              <TR>
                <TD VALIGN=top WIDTH=112>
                  <P><a href="komplette_loesninger.asp"
onmouseover="changeImg('pic1', 'images/but1_over.gif');
changeImg('pic2', 'images/string1.gif');
changeImg('pic3', 'images/over1.jpg')"

onmouseout="changeImg('pic1', 'images/but1.gif');
changeImg('pic2', 'images/string.gif');
changeImg('pic3', 'images/tom_mouseover.jpg')"> <img src="images/but1.gif" name="pic1" border=0 ALIGN=bottom></a><BR>
                    <a href="internet_udvikling.asp"
onmouseover="changeImg('pic4', 'images/but2_over.gif');
changeImg('pic2', 'images/string2.gif');
changeImg('pic3', 'images/over2.jpg')"

onmouseout="changeImg('pic4', 'images/but2.gif');
changeImg('pic2', 'images/string.gif');
changeImg('pic3', 'images/tom_mouseover.jpg')"> <IMG SRC="images/but2.gif" WIDTH=112 HEIGHT=34 ALIGN=bottom name="pic4" border=0></a><BR>
                    <A HREF="grafisk_produktion.asp" onmouseover="changeImg('pic5', 'images/but3_over.gif');
changeImg('pic2', 'images/string3.gif');
changeImg('pic3', 'images/over3.jpg')"

onmouseout="changeImg('pic5', 'images/but3.gif');
changeImg('pic2', 'images/string.gif');
changeImg('pic3', 'images/tom_mouseover.jpg')"> <IMG SRC="images/but3.gif" WIDTH=112 HEIGHT=34 BORDER=0 ALIGN=bottom name="pic5"></A><BR>
                    <a href="referencer.asp"
onmouseover="changeImg('pic6', 'images/but4_over.gif');
changeImg('pic2', 'images/string4.gif');
changeImg('pic3', 'images/over4.jpg')"

onmouseout="changeImg('pic6', 'images/but4.gif');
changeImg('pic2', 'images/string.gif');
changeImg('pic3', 'images/tom_mouseover.jpg')"> <IMG SRC="images/but4.gif" WIDTH=112 HEIGHT=34 ALIGN=bottom BORDER=0 name="pic6"></A><BR>
                    <a href="kontakt.asp"
onmouseover="changeImg('pic7', 'images/but5_over.gif');
changeImg('pic2', 'images/string5.gif');
changeImg('pic3', 'images/over5.jpg')"

onmouseout="changeImg('pic7', 'images/but5.gif');
changeImg('pic2', 'images/string.gif');
changeImg('pic3', 'images/tom_mouseover.jpg')"> <IMG SRC="images/but5.gif" WIDTH=112 HEIGHT=34 ALIGN=bottom BORDER=0 name="pic7"></A><BR>
                    <IMG SRC="images/spacer2.gif" WIDTH=1 HEIGHT=129 ALIGN=bottom><BR>
                    <IMG SRC="images/dimensiona.gif" WIDTH=112 HEIGHT=52 ALIGN=bottom></P>
                </TD>
                <TD VALIGN=top WIDTH=160>
                  <P align="left"><IMG SRC="images/string.gif" WIDTH=20 HEIGHT=170 ALIGN=top name="pic2"><IMG SRC="images/forside_p1.jpg" WIDTH=140 HEIGHT=146 ALIGN=top><IMG SRC="images/tom_mouseover.jpg" HEIGHT=129 ALIGN=bottom name="pic3"><BR>
                    <IMG SRC="images/dimensionb.gif" WIDTH=160 HEIGHT=52 ALIGN=bottom></P>
                </TD>
                <TD VALIGN=top WIDTH=170>
                  <P>
                  <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0>
                    <TR>
                      <TD WIDTH=10>
                        <P></P>
                      </TD>
                      <TD WIDTH=150> <IMG SRC=images/grafisk_tjeck.jpg WIDTH=137 HEIGHT=34 ALIGN=bottom><BR>
                        <%
Select Case strMode
Case "add"
%> <%
Case Else
    Set myConn = Server.CreateObject("ADODB.Connection")
    strSQL = "SELECT * FROM Nyheder ORDER BY ID DESC;"
    myConn.Open tempConn
    Set rs = myConn.Execute(strSQL)
    If Not (rs.BOF Or rs.EOF) Then
        Response.Write "<table border=0 cellpadding=0 cellspacing=0>"
        Do While Not rs.EOF

Response.Write "<tr><td WIDTH=320><span class=subheader>" & "<a href=nyheder.asp?ID=" & rs("ID") & ">" & rs("Overskrift") & "</a>" & "</SPAN><br>" & "<span class=text>" & rs("Teaser") & " " & "<a href=nyheder.asp?ID=" & rs("ID") & ">" & "<img src=images/link_arrow.jpg border=0>" & "</a>" & "</span><P></P></td>"

            rs.MoveNext
        Loop
        Response.Write "</table>"
    Else
        Response.Write "<p><font face=arial size=2>Der er endnu ikke nogle nyheder i databasen endnu</font></p>"
    End If
    myConn.Close
    Set myConn = Nothing
End Select
%> </TD>
                      <TD WIDTH=10> </TD>
                    </TR>
                  </TABLE>
                </TD>
                <TD WIDTH=14 BGCOLOR="#404040" valign="top" halign="center">
                  <P><IMG SRC="images/adresse_p2.jpg" WIDTH=14 HEIGHT=351 ALIGN=top></P>
                </TD>
              </TR>
            </TABLE>
          </TD>
        </TR>
        <TR>
          <TD HEIGHT=14 BGCOLOR="#404040">
            <P></P>
          </TD>
        </TR>
      </TABLE>
    </TD>
  </TR>
  <TR>
    <TD WIDTH=96 valign="top" background="images/td_back.jpg"><img src="images/td_back.jpg" width="97" height="115"></TD>
  </TR>
</TABLE>
<p></P>
</BODY>
</HTML>
Avatar billede winkill Nybegynder
11. december 1999 - 18:01 #1
Først sætter du Conn til at være Driveren og Stien
Conn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("statistik.mdb") & ";UID=admin;PWD=;"
Så Glæmmer du driveren og sætter Conn = Objektet
set conn = server.CreateObject ("adodb.connection")
Conn.Open Conn

Her er de korrekte tre linier:
Connection = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("statistik.mdb") & ";UID=admin;PWD=;"
set conn = server.CreateObject ("adodb.connection")
Conn.Open Connection

Avatar billede styrelse Nybegynder
11. december 1999 - 18:09 #2
Fint - tak for det ;-) Det faktisk alligevel. Jeg tror bare fejlen var at jeg havde glemt at lukke databasen...
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester