Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Unpsecified Error with ODBC Connections

Reply
Thread Tools

Unpsecified Error with ODBC Connections

 
 
David Lozzi
Guest
Posts: n/a
 
      09-12-2003
This happens a lot to my databases. I store them at the root of my
developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly, the
security settings on this database will drop to the basic secutiry, myself
and SYSTEM. I need IUSR on it so I can access it through my ASP pages... I
get errors like this:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
/amr/common/adovbs.inc, line 4

and

Provider (0x80004005)
Unspecified error
/amr/common/adovbs.inc, line 4

and line 4 is this

2 Dim Connect
3 Set Connect = Server.CreateObject("ADODB.Connection")
4 Connect.Open "dsn name"

I will reset the permissions, then the ASP script will access the database
once, like read or write, then this will happen again. I have to reset the
permissions on the database file. Sometimes i'll have to do this 3 or 4
times until the permissions stick. It only happens on a few of my projects,
not all of them. Also, what helps at times, is within IIS, to check server
extensions. This seems to do something to it to help it to work.

Any Ideas?

--
David Lozzi
Associated Business & Technology Group
www.associatedbtg.com

I should've known that....but I had a brain fart.


 
Reply With Quote
 
 
 
 
Bob Barrows
Guest
Posts: n/a
 
      09-12-2003
This can happen when you compact the databases: the security settings for
IUSR can be lost.

FWIW, you should stop using ODBC and swtich to using the native Jet OLEDB
provider instead. See www.connectionstrings.com. The MSDASQL provider (the
provider used for ODBC drivers) has been deprecated by MS, and is not
recommended to be used. Granted, that won't fix this particular problem, but
....

HTH,
Bob Barrows

..David Lozzi wrote:
> This happens a lot to my databases. I store them at the root of my
> developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly,
> the security settings on this database will drop to the basic
> secutiry, myself and SYSTEM. I need IUSR on it so I can access it
> through my ASP pages... I get errors like this:
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened
> exclusively by another user, or you need permission to view its data.
> /amr/common/adovbs.inc, line 4
>
> and
>
> Provider (0x80004005)
> Unspecified error
> /amr/common/adovbs.inc, line 4
>
> and line 4 is this
>
> 2 Dim Connect
> 3 Set Connect = Server.CreateObject("ADODB.Connection")
> 4 Connect.Open "dsn name"
>
> I will reset the permissions, then the ASP script will access the
> database once, like read or write, then this will happen again. I
> have to reset the permissions on the database file. Sometimes i'll
> have to do this 3 or 4 times until the permissions stick. It only
> happens on a few of my projects, not all of them. Also, what helps at
> times, is within IIS, to check server extensions. This seems to do
> something to it to help it to work.
>
> Any Ideas?



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: The ODBC resource DLL is a different version than the ODBC driver manager beenthere Computer Support 12 10-17-2006 07:11 PM
Re: The ODBC resource DLL is a different version than the ODBC driver manager tenkbabe@yahoo.com Computer Support 0 10-16-2006 01:11 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM



Advertisments