Annoying Access errors

Results 1 to 2 of 2

Thread: Annoying Access errors

  1. #1
    Rob Guest

    Default Annoying Access errors

    Hey. I&#039;ve been building an Access 2000 database driven ASP e-commerce site and I&#039;ve gotten it to work flawlessly on my machine with Personal Web Server (PWS). However, when I uploaded it to the IIS 4 server that is going to be hosting the site, I got these two errors: <BR><BR>Error 1:<BR>Microsoft JET Database Engine error &#039;80040e21&#039; <BR>Cannot include Memo, OLE, or Hyperlink Object when you select unique values (features). <BR><BR>Code:<BR>strSQL = "SELECT DISTINCT Products.*, Details.* " _<BR> & "FROM Products, Details " _<BR> & "WHERE Products.prodName = Details.prodName <BR><BR>The table Details contains a memo field, but it works fine on my machine using PWS. What can I do to make this work on the IIS 4 server?<BR><BR>Error 2: <BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key &#039;Temporary (volatile) Jet DSN for process 0x7d0 Thread 0x800 DBC 0x20b6014 Jet&#039;. <BR><BR>I think this one is a server side configuration problem.<BR><BR>Thanks for any help!<BR><BR>Rob

  2. #2
    Join Date
    Dec 1969

    Default RE: Annoying Access errors

    error 1 : try updating the MDAC on the server (or the developement box, whichever needs it)<BR>error 2 : don&#039;t use ODBC connections, use OLEDB<BR><BR>there&#039;s a tutorial on OLEDB connections at in the ASP section<BR><BR>j

Posting Permissions

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