Onetoomany wrote on Sun, 16 Nov 2008 22:26:32 -0000:
Quote:
Thanks. Jet does not want to install onto 2008 - it seems that
(according to microsoft) Jet is already installed...
Windows 2008 includes the latest version of Jet - however, it's still only
32-bit (there is no 64-bit version of Jet that I am aware of). The 64-bit
SP8 for Jet 4 for Windows 2003 is the same installer that runs on the 32-bit
OS versions too - the 64-bit in the KB article name is irrelevant, it's just
there for those users who have 2003 64-bit.
Quote:
I've managed to solve the problem, but not overly satisfactoraily:
1) Set the applicaiton pool to 32 bit
This then gave me a "The requested page cannot be accessed because the
related configuration data for the page is invalid" error.
Quote:
To solve this I had to:
2) Uninstall RPC over HTTP Proxy
3) Disable the httpCompression
Quote:
Finally working, but getting errors in the system log for having
uninstalled the RPC over HTTP proxy.
I think you need to run IIS itself in 32-bit mode to use the Jet drivers
properly - you seem to have managed to kludge it to work with IIS in 64-bit
mode with a 32-bit application pool and I'm not sure this is supported or
even stable.
Dan
Quote:
"Bob Barrows" <reb01501@NOyahoo.SPAMcomwrote in message news:%23SjTGDCSJHA.5092@TK2MSFTNGP05.phx.gbl...
Quote:
>Onetoomany wrote:
Quote:
Quote:
Quote:
>>I've just upgraded to Small Business Server 2008, 64 bit.
Quote:
Quote:
Quote:
>>My website, which worked perfectly before, is having issues with the
>>connection string:
>>I've tried:
>>1) sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
>>Source=F:\Website\databases\database.mdb;"
>>2) sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data
>>Source=F:\Website\databases\database.mdb;"
>>3) sConnection = "Driver={Microsoft Access Driver
>>(*.mdb)};Dbq=F:\Website\Manydown.com\databases\m anydown.mdb;"
Quote:
Quote:
Quote:
>>I get the error: (1 & 2)
>>ADODB.Recordset error '800a0e7a'
>>Provider cannot be found. It may not be properly installed.
Quote:
Quote:
Quote:
>>/default.asp, line 55
Quote:
Quote:
Quote:
>>(3)
>>error '80004005'
>>/default.asp, line 55
Quote:
Quote:
Quote:
>>Googling seems to indicate that MS has removed Jet from Server 2008,
>>but I can't find a suitable replacement. I've downloaded the 2007
>>Access driver, so I'm surprised that I get this error from it.
>>I've given IUSR_server (Internet Guest Account) and Network Service
>>full rights to my database folder.
Quote:
Quote:
>But doesn't SBS use a SQL Server backend?
Quote:
Quote:
>--
>Microsoft MVP - ASP/ASP.NET - 2004-2007
>Please reply to the newsgroup. This email account is my spam trap so
>I don't check it very often. If you must reply off-line, then remove
>the "NO SPAM"
