Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

Infamous ODBC Error

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  Internal Server Error 500  
Author Message
user1330

External


Since: Jan 21, 2004
Posts: 1



(Msg. 1) Posted: Wed Jan 21, 2004 1:41 pm
Post subject: Infamous ODBC Error
Archived from groups: microsoft>public>inetserver>iis (more info?)
I have IIS 5.0 running on Serv2000. I have an ASP page calling an MS Access database. I am getting the following error:

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5a8 Thread 0x96c DBC 0xcbe0b4 Jet'.
/findinfo.asp, line 9

Line 9 is just a conn.open

conn.open "Driver={Microsoft Access Driver (*.mdb)};" & _
   "Dbq=Labels.mdb;" &_

I have changed the %temp% directory permissions. Also permissions on the database itself and even the permissions on the ODBC registry key. I have included IUSER and IWAM accounts and given them up to and including full control. I am out of options and answers.<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Infamous ODBC Error 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 2) Posted: Wed Jan 21, 2004 5:57 pm
Post subject: Re: Infamous ODBC Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Jon Holman" <jholman(removethis)@flightax.com> wrote in message
news:774DF53C-8090-4406-9151-D2CDD06B1DCE@microsoft.com...
 > I have IIS 5.0 running on Serv2000. I have an ASP page calling an MS
Access database. I am getting the following error:
 >
 > [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x5a8 Thread 0x96c
DBC 0xcbe0b4 Jet'.
 > /findinfo.asp, line 9
 >
 > Line 9 is just a conn.open
 >
 > conn.open "Driver={Microsoft Access Driver (*.mdb)};" & _
 > "Dbq=Labels.mdb;" &_
 >
 > I have changed the %temp% directory permissions. Also permissions on the
database itself and even the permissions on the ODBC registry key. I have
included IUSER and IWAM accounts and given them up to and including full
control. I am out of options and answers.
 >

How about switching to OLEDB ...
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2154" target="_blank">http://www.aspfaq.com/show.asp?id=2154</a>

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Infamous ODBC Error 
Back to top
Login to vote
user658

External


Since: Aug 26, 2003
Posts: 1525



(Msg. 3) Posted: Wed Jan 21, 2004 11:17 pm
Post subject: Re: Infamous ODBC Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 21 Jan 2004 10:41:09 -0800, "Jon Holman"
<jholman(removethis)@flightax.com> wrote:

 >I have IIS 5.0 running on Serv2000. I have an ASP page calling an MS Access database. I am getting the following error:
 >
 >[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5a8 Thread 0x96c DBC 0xcbe0b4 Jet'.
 >/findinfo.asp, line 9
 >
 >Line 9 is just a conn.open
 >
 >conn.open "Driver={Microsoft Access Driver (*.mdb)};" & _
   > "Dbq=Labels.mdb;" &_
 >
 >I have changed the %temp% directory permissions. Also permissions on the database itself and even the permissions on the ODBC registry key. I have included IUSER and IWAM accounts and given them up to and including full control. I am out of options and answers.

See:

<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2009" target="_blank">http://www.aspfaq.com/show.asp?id=2009</a>
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2154" target="_blank">http://www.aspfaq.com/show.asp?id=2154</a>

Then switch to an OLEDB connection and fix it for good.

Jeff<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Infamous ODBC Error 
Back to top
Login to vote
anonymous997

External


Since: Jan 21, 2004
Posts: 1



(Msg. 4) Posted: Wed Jan 21, 2004 11:17 pm
Post subject: Re: Infamous ODBC Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I would love to be able to use an OLEDB connection but the asp file was written for me. It has worked for a year. Do I just change the connection string and add jet 4.0?? Or should I get a hold of the original programer and have her do it?

thanks for your patience!

----- Jeff Cochran wrote: -----

On Wed, 21 Jan 2004 10:41:09 -0800, "Jon Holman"
<jholman(removethis)@flightax.com> wrote:

  >I have IIS 5.0 running on Serv2000. I have an ASP page calling an MS Access database. I am getting the following error:
   >>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5a8 Thread 0x96c DBC 0xcbe0b4 Jet'.
  >/findinfo.asp, line 9
   >>Line 9 is just a conn.open
   >>conn.open "Driver={Microsoft Access Driver (*.mdb)};" & _
    > "Dbq=Labels.mdb;" &_
   >>I have changed the %temp% directory permissions. Also permissions on the database itself and even the permissions on the ODBC registry key. I have included IUSER and IWAM accounts and given them up to and including full control. I am out of options and answers.

See:

<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2009" target="_blank">http://www.aspfaq.com/show.asp?id=2009</a>
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2154" target="_blank">http://www.aspfaq.com/show.asp?id=2154</a>

Then switch to an OLEDB connection and fix it for good.

Jeff<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Infamous ODBC Error 
Back to top
Login to vote
user658

External


Since: Aug 26, 2003
Posts: 1525



(Msg. 5) Posted: Thu Jan 22, 2004 4:30 pm
Post subject: Re: Infamous ODBC Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 21 Jan 2004 18:01:07 -0800, "Jon Holman"
<anonymous DeleteThis @discussions.microsoft.com> wrote:

 >I would love to be able to use an OLEDB connection but the asp file was written for me. It has worked for a year. Do I just change the connection string and add jet 4.0?? Or should I get a hold of the original programer and have her do it?

Either way. If you do it yourself, back up the file and/or REM out
the connection string line. For a list of ADO connection strings to
meet your needs, see:

<a style='text-decoration: underline;' href="http://www.able-consulting.com/ADO_Conn.htm" target="_blank">http://www.able-consulting.com/ADO_Conn.htm</a>

Jeff

 >thanks for your patience!
 >
 > ----- Jeff Cochran wrote: -----
 >
 > On Wed, 21 Jan 2004 10:41:09 -0800, "Jon Holman"
 > <jholman(removethis)@flightax.com> wrote:
 >
  > >I have IIS 5.0 running on Serv2000. I have an ASP page calling an MS Access database. I am getting the following error:
   > >>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5a8 Thread 0x96c DBC 0xcbe0b4 Jet'.
  > >/findinfo.asp, line 9
   > >>Line 9 is just a conn.open
   > >>conn.open "Driver={Microsoft Access Driver (*.mdb)};" & _
   > > "Dbq=Labels.mdb;" &_
   > >>I have changed the %temp% directory permissions. Also permissions on the database itself and even the permissions on the ODBC registry key. I have included IUSER and IWAM accounts and given them up to and including full control. I am out of options and answers.
 >
 > See:
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2009</font" target="_blank">http://www.aspfaq.com/show.asp?id=2009</font</a>>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2154</font" target="_blank">http://www.aspfaq.com/show.asp?id=2154</font</a>>
 >
 > Then switch to an OLEDB connection and fix it for good.
 >
 > Jeff
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Infamous ODBC Error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' - Anyone can help? Getting the following error when accessing my web site. The error only happen some times. Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='...

IIS ODBC - IIS ODBC Logging failed to connect to data source TSLOG. Error text is [[State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ]. For additional information specific to this message please visit...

WIN32::ODBC & SQL - Does WIN32:ODBC support SQL in its entirety or just a subset ? I have issued SQL commands (In CGI/PERL) and they were not supported. If WIN32::ODBC does not support the entire SQL language set where can I find documentation regarding what it does..

IIS ODBC problem - HELP - I found this log in System : Event Type: Error Event Source: IISLOG Event Category: None Event ID: 5 Date: 28.10.2003 Ç. Time: 09:22:23 User: N/A Computer: SF-EXCO-AV-01 Description: IIS ODBC Logging failed to connect to data source IIS. Error text i...

SETUP ODBC - Hello all - I am having problems and needing help- Currently running IIS6 & Windows 2003 Getting error 'ASP 0140 on the default page & 'ASP 0126 on the admin page This ASP coding is from www.duware.com the gallery free download. Can someone po...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]