Re: Cannot open database error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"primeMover" <primeMover@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3A9E9950-5CD3-4B57-80AE-D62ABAF4C2C2@xxxxxxxxxxxxxxxx
And of course you need to verify that the user of the database has
Modify
permissions on the folder containing the database file.

Yes, I double-checked that.


[I'm wrapping my reply to several posts here - otherwise this will turn into
a bush rather than a tree. <g>]

Just to clarify:

You said your snippet is from a wrapper, so can I assume that your
application has only 'One' ADODB.Connection object? That the principle
elements - Cursor, database, ... that make up an ADO connection don't
change, and you are only opening and closing on use? ie, you are not
"newing" a new ADODB.Connection everytime?

Within the above scenario are you also keeping it open while opening
multiple Recordsets? Or do you only have one Recordset open (and thus the
Connection object open) at one time? This is only of mild interest because
while ADO uses connection pooling, ADO does create a new Jet session for
every connection to Jet.
So are we talking about - dying on the request for a 4th session, or the 4th
time we request a new session? (Or whatever I was trying to say. <g>)

How rapidily are you opening and closing this connection. Jet sessions do
have some latency. Just for grins - insert a 'pause'.

[I know I seem to be unduly harping on the subject of having only one
ADODB.Connection object. That is because I've seen more than one a common
cause for 'bizzare' issues in the past. Use/abuse the ADO connection pool -
that's why it is there.]

As an aside be sure to read this if you haven't yet:
"How to keep a Jet 4.0 database in top working condition"
http://support.microsoft.com/kb/303528/
Note you are using a translator dll with your configuration - I don't
believe for a moment that is the source of your problem - but doesn't hurt
to check.

Your report that another test application works just fine, assuming the same
general architecture, is rather disturbing. <g> As that suggests there is
something within the code for that application that is unique. Did you also
test opening and closing a connection 4 times?

Oh, is the database located on each box, or is it accessed remotely?

Other than insuring you are only using one ADODB Connection object, and
playing with delays, I don't have anything more concrete to offer. I like to
think I debug in a logical orderly professional manner, but when faced with
a situations like this, I often end up just clicking and playing driven more
by hope than reason. <g>

If you do find the cause - please return and let us know.

-ralph





.

Relevant Pages

  • Re: DDE Access to Word using mde
    ... but Word opens just fine. ... to an Access 2002/3 .mde using DDE, the connection is fine. ... By the way there are no other users(except the current opening of the ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Default to LAN connection when Dial-up is present
    ... I no longer have possession of the laptop to try most of this but I can tell ... Outlook Express was not opening ... Our GPO prohibits allowing the user to change the connection settings in IE. ...
    (microsoft.public.windows.inetexplorer.ie6.setup)
  • Re: JDBC and Stored procedure performance problems
    ... There is an overhead on the iSeries in getting the JVM started, ... > connection if all are in use and opening it in advance. ... > The same SQL statement takes just a second in STRSQL, ...
    (comp.sys.ibm.as400.misc)
  • Re: XP Home Edition
    ... web pages are not opening and i am not able to get into the ... internet... ... The connection is ok and my ISP informs there is a problem ...
    (microsoft.public.windowsxp.newusers)
  • Re: Refresh DB
    ... connection than closing and opening it? ... you can use Requery, which is the same as if you would call Close and ...
    (borland.public.delphi.database.ado)