« Previous Next »

Thread: Localhost connection/connection strings

Last post 10-13-2008 10:49 PM by acavantec. 6 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (7 items)

Sort Posts:

  • 09-17-2008, 5:54 PM

    • LReber
    • Top 500 Contributor
    • Joined on 08-29-2008, 10:18 PM
    • Posts 13

    Localhost connection/connection strings

    Whenever I try to view my active pages that I'm creating from tutorials, I keep getting an error message. Based on information I have gleaned from this forum and the DW forum and Steve Schofield's blog I have tried the following, often several times, or in combination with other changes.

    • Make sure localhost functions
    • try an ASP testpage without database to see if it works - it does
    • ping localhost
    • set permissions for IUSR
    • make sure folder is not read-only
    • eliminate DSN and enter a connection string
    • many more items that haven't worked

    The IIS log shows a 80004005 error. 'Rovastar' pointed me to the ASPFAQ tutorials site and I tried everything on that site that related to 'Disk or Network error.' At least, everything I could figure out. That's why it has taken this long. This problem has remained unresolved for 3 1/2 weeks and has stalled my progress, as well as just being frustrating. In looking in the IIS manager, there's an item for connection string. What it shows is nothing like the connection strings suggested in DW for Dummies, or the DW CS3 bible. Should it?

    Thanks everyone. I hope I've included enough information here for someone to figure this out. - Lisa

  • 09-18-2008, 8:34 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 10:27 AM
    • Central NJ
    • Posts 6,163
    • IIS MVPs

    Re: Localhost connection/connection strings

    Please post the exact error you're getting.  What database are you using? Where is it located?  What's your connection string?  What's your code? : )

  • 09-18-2008, 8:34 PM In reply to

    • LReber
    • Top 500 Contributor
    • Joined on 08-29-2008, 10:18 PM
    • Posts 13

    Re: Localhost connection/connection strings

    I'm getting the generic message 'An error occurred on the server when processing the URL. Please contact the [@#$%] system administrator." That's coming from IIS, as I proved to myself at least, when I added the '@#$%' text to it. And before you ask, I am not seeing any usual error code, like 404 not found. (That's only off the top of my head - not claiming that that's a legit msg.) When I test the connection, the table data appears when and how it should. I can't view live data or preview the page in the browser. I haven''t tried the page without the repeat region. Just occurred to me, but I'd be surprised if that made a diff.

     I"m using MS Access for files located at inetpub/wwwroot/dreamweaver/Cafe Townsend/data and other folders in that directory.

    The code for my (latest) connection string is:
    <%
    // FileName="Connection_ado_conn_string.htm"
    // Type="ADO"
    // DesigntimeType="ADO"
    // HTTP="false"
    // Catalog=""
    // Schema=""
    var MM_connCafeT_0915_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Inetpub\\wwwroot\\dreamweaver\\Cafe Townsend\\data\\tutorial.mdb;"
    conn.mode = 3 ' adModeReadWrite
    %>

    That generated the following text in the Inetpub/Logs file:
    #Software: Microsoft Internet Information Services 7.0
    #Version: 1.0
    #Date: 2008-09-19 00:19:07
    #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
    2008-09-19 00:19:07 ::1 GET /dreamweaver/Cafe+Townsend/viewJS_kqpwu7f27t.asp |3|80004005|Unspecified_error 80 - ::1 MMHttp+(Windows;+Version:9.0) 500 0 0
    2008-09-19 00:19:07 ::1 GET /dreamweaver/Cafe+Townsend/viewJS_kqrel7f27v.asp |5|80004005|Unspecified_error 80 - ::1 MMHttp+(Windows;+Version:9.0) 500 0 0

    This is a little different than the 80004005 message that referenced 'Disk or Network error' but more opaque, if I may opine. <grin>

    Thanks very much!

  • 09-19-2008, 7:24 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 10:27 AM
    • Central NJ
    • Posts 6,163
    • IIS MVPs

    Re: Localhost connection/connection strings

    The 80004005 error code relates to this page:
    http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html

    I'm 99.9% sure the solution to your problem is there. 

    Also, the error message you reference is not a standard IIS/ASP error  - where is that coming from?  Do you have a custom error message somewhere? Can you show all of your code?  We should be getting a line number referenced in the error message.

  • 09-19-2008, 8:47 AM In reply to

    • LReber
    • Top 500 Contributor
    • Joined on 08-29-2008, 10:18 PM
    • Posts 13

    Re: Localhost connection/connection strings

    I've been working through the referenced page, but without results. It looked like the introductory paragraph laid a lot of groundwork, so I tried to do everything it suggested. One thing I haven't been able to try is the 'most recent MDAC'. The link is no good; I'm assuming (uh-oh) that since I'm running Vista, I probably have it. I have also tried saving the Access db in different formats; still no luck.

    tomkmvp:
    Also, the error message you reference is not a standard IIS/ASP error  - where is that coming from?
    Which message do you mean? The one with the @#$% in it is one I edited from the IIS control panel, because it was so unspecific. But it's the only one that ever appears.

    tomkmvp:
    Do you have a custom error message somewhere? Can you show all of your code?
    Which code? The only detailed error message is in the IIS log that references the 80004005 error.

    Thanks Tom. I've been struggling with this since August, and it has really stalled me. Do you review this forum on the weekends? And finally, I might end up going to a MySQL db, so should I just blow off this whole problem and spend my time learning that instead?

  • 09-19-2008, 12:51 PM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 10:27 AM
    • Central NJ
    • Posts 6,163
    • IIS MVPs

    Re: Localhost connection/connection strings

    It was not clear at first that you're on Vista/IIS 7 and not IIS 6. 

    I don't usually spend time in here on weekends.  If you're going down the SQL road, I would not bother making Access work.

  • 10-13-2008, 10:49 PM In reply to

    • acavantec
    • Not Ranked
    • Joined on 10-13-2008, 10:39 PM
    • Posts 1

    Re: Localhost connection/connection strings

    I seem to be having the same problem. The error I get is...

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Disk or network error.

    Ever since I got my new laptop (IBM Thinkpad T61), I have been getting this error. I have several sites which use Access databases, and they all worked fine on my old laptop. Now, every one returns the above error when accessing the site on localhost. They all work fine on the host server as well. I can upload the database to the host server with no ill affects. All of this tells me that there is something wrong with some setting(s) on my laptop. 

    I have seen some articles about setting access on the temp directories and have tried to follow the "not so detailed" instructions to fix it, but can't get the sites working.

    It is not feasible to switch all of the sites over to a new database like SQL Server or MySQL, so I need help on actually fixing this issue.

    AC

Page 1 of 1 (7 items)
Microsoft Communities