Databases
StackOverflow2013
Postsdbo
POWindows Server 2008, IIS7.5 and connection to MS Access 97 database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWindows Server 2008, IIS7.5 and connection to MS Access 97 database
    primarykey
    data
    text
    <p>I know, the topic sounds terrible. But I actually have to connect these technologies. </p> <h2>Problem</h2> <p>I am currently migrating company's intranet (written mostly in classic ASP) from Windows Server 2003 32 bit with IIS 6 to Windows Server 2008 R2 64 bit with IIS 7.5. Everything works perfectly fine except for one subpage which uses <code>set conn = server.createobject("adodb.connection")</code> to connect to <code>connstring="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=path\to\mdb\which\is\really\there"</code>. </p> <p>I open connection (<code>conn.open connstring</code>), build a query string and then, when I want to <code>set rsresult = conn.execute(sqlusr)</code> I get </p> <pre><code>Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'TABLE_THAT_ACTUALLY_EXISTS' failed. </code></pre> <p>That error is thrown at the line with <code>conn.execute(sqlusr)</code>. Of course, it worked fine in previous environment.</p> <h2>What have I tried?</h2> <ul> <li><a href="https://stackoverflow.com/questions/5068254/connect-to-ms-access-accdb-file-on-windows-server-2008">connect to MS Access accdb file on Windows Server 2008</a> - I learned that Windows Server 2008 has MSJet preinstalled, so this question is of no use (reminder: mdb is for Access 97)</li> <li><a href="http://support.microsoft.com/kb/168336" rel="nofollow noreferrer">http://support.microsoft.com/kb/168336</a> - this is actually how the connection is made but I thought that sth may be wrong, misspelled, ...</li> <li>I copied ODBC data sources form previous server to the new one (I kept the names) - problem still exists</li> <li>I installed the latest updates on Windows Server 2008 machine</li> </ul> <h2>Additional info</h2> <ul> <li><code>mdb</code> will open <strong>only</strong> in Access 97 (why? don't ask me : / I wasn't the only one who tried to open it in Access 2000/2003/2007/2010 - it worked nowhere)</li> <li>application pool for this web page on IIS 7.5 has <code>Enable 32-bit Applications</code> option set to <strong>true</strong>. Parent paths are also enabled.</li> </ul> <p>I will be grateful for any additional tips on what to check/do/how to fix this issue.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USmaialithar
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWindows Server 2008, IIS7.5 and connection to MS Access 97 database
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPerhaps you can try this earlier SO solution and create a custom connection string in IIS : http://stackoverflow.com/questions/7215871/global-asa-does-not-work-in-iis7-5
      singulars
      1. POWindows Server 2008, IIS7.5 and connection to MS Access 97 database
      1. USAardVark71
    2. CODo you need the Access 97 forms etc or just the data? If it is just the data, try importing into a new Access version.
      singulars
      1. POWindows Server 2008, IIS7.5 and connection to MS Access 97 database
      1. USFionnuala
    3. COI would focus on getting the data into a newer Access format first.
      singulars
      1. POWindows Server 2008, IIS7.5 and connection to MS Access 97 database
      1. USHK1
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload