DB connection

Results 1 to 4 of 4

Thread: DB connection

  1. #1
    jenc Guest

    Default DB connection

    Hi All - please help! I am trying to view my asp page but I keep getting the following error. The page works in PWS but not in IIS. I have checked the permissions. There could be a very simple solution but I am new to this so please pardon my ignorance...thanks!<BR><BR>&#060;---CODE----&#062;<BR>openstr = "driver={Microsoft Access Driver (*.mdb)};" & _<BR> "dbq=" & Server.MapPath("file.mdb")<BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>cn.Open openstr<BR><BR><BR><BR>&#060;---ERROR---&#062;<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Disk or network error. <BR><BR>/dbtest/players.asp, line 10 <BR>

  2. #2
    jenc Guest

    Default RE: DB connection

    ps. I also tried using a DSN connection but I got a different error. (I already set up the ODBC source and the db connection to the ODBC). Any suggestions???? thanks. <BR><BR>&#060;---ERROR----&#062;<BR>Server error: Unable to retrieve the list of record sources from a database using the connection string:<BR><BR>DSN=SamdbDSN;DRIVER={Microsoft Access Driver (*.mdb)}.<BR><BR>The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.<BR>-------------------------------------------------------<BR><BR><BR>Source: ADO<BR>Number: -2146824584 (0x800a0e78)<BR>

  3. #3
    Jon Guest

    Default RE: DB connection

    Hi, dont know whether this will help, but if your permissions are okay, I usually set up a Session Connection String in my global.asa, and the below stuff always works fine with Access.<BR><BR><BR>Dim sDbPath<BR>Dim sConnString<BR> <BR>&#039ISP Access Database Path...<BR>sDbPath = Server.MapPath("\") & "DatabaseMkt7.mdb"<BR><BR>&#039PWS Access Database Path...<BR>sDbPath = Server.MapPath("\") & "virthomedirDatabaseMkt7.mdb"<BR> <BR>&#039Access Database Connection String...<BR>sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sDbPath & ";Jet OLEDB:Database"<BR><BR><BR>Good Luck<BR>Jon

  4. #4
    jenc Guest

    Default RE: DB connection - still not working

    Hi - I tried your suggestion but still no luck. thanks anyway. I still don&#039t know why I&#039m getting a disk or network error (of all messages)...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts