I have a simple script that uses an access database.
Every time the script is called, I can see using filemon that a request
for "c:\windows\system32\inetsrv\system.mdb" is made, which fails.(file
not found) Script works fine, however, I am wondering why is it doing
that?
This database is not password protected, and its not part of any
workgroup...
gil@infomart2000.com wrote:
> I have a simple script that uses an access database.
> Every time the script is called, I can see using filemon that a
> request for "c:\windows\system32\inetsrv\system.mdb" is made, which
> fails.(file not found)
Is it failing because the file does not exist in that location?
> Script works fine, however, I am wondering why
> is it doing that?
>
> This database is not password protected, and its not part of any
> workgroup...
It's probably because of the connection string you are using:
http://www.aspfaq.com/show.asp?id=2126
However, lack of appropriate permissions can cause a "not found" error.
We need to see your code to provide more specific help.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
gil@infomart2000.com wrote:
> I have a simple script that uses an access database.
> Every time the script is called, I can see using filemon that a request
> for "c:\windows\system32\inetsrv\system.mdb" is made, which fails.(file
> not found) Script works fine, however, I am wondering why is it doing
> that?
>
> This database is not password protected, and its not part of any
> workgroup...
Your connection string needs a full path to the database provided to it
- either hardcoded or using server.mappath. My bet is that you have
used a relative path; something like Data Source=system.mdb
--
Mike Brind
Mike Brind wrote:
> gil@infomart2000.com wrote:
> > I have a simple script that uses an access database.
> > Every time the script is called, I can see using filemon that a request
> > for "c:\windows\system32\inetsrv\system.mdb" is made, which fails.(file
> > not found) Script works fine, however, I am wondering why is it doing
> > that?
> >
> > This database is not password protected, and its not part of any
> > workgroup...
>
> Your connection string needs a full path to the database provided to it
> - either hardcoded or using server.mappath. My bet is that you have
> used a relative path; something like Data Source=system.mdb
>
> --
> Mike Brind
Actually i am specifying my database, and the script works. The
database name is db1.mdb and its located in a db folder inside of the
folder where my site is. ie:
c:\webroot\mydomain.com\script.asp
database path is
c:\webroot\mydomain.com\db\db1.mdb
i specified it like that on my connection string.
My only guess is that access checks for this system.mdb database each
time an access database is opened?
Like i said, script works, so its not that the file not found is
causing a problem, i am just wondering why the driver or whatever is
looking for this file...
gil@infomart2000.com wrote:
> Mike Brind wrote:
> > gil@infomart2000.com wrote:
> > > I have a simple script that uses an access database.
> > > Every time the script is called, I can see using filemon that a request
> > > for "c:\windows\system32\inetsrv\system.mdb" is made, which fails.(file
> > > not found) Script works fine, however, I am wondering why is it doing
> > > that?
> > >
> > > This database is not password protected, and its not part of any
> > > workgroup...
> >
> > Your connection string needs a full path to the database provided to it
> > - either hardcoded or using server.mappath. My bet is that you have
> > used a relative path; something like Data Source=system.mdb
> >
> > --
> > Mike Brind
>
>
> Actually i am specifying my database, and the script works. The
> database name is db1.mdb and its located in a db folder inside of the
> folder where my site is. ie:
>
> c:\webroot\mydomain.com\script.asp
> database path is
> c:\webroot\mydomain.com\db\db1.mdb
>
> i specified it like that on my connection string.
>
> My only guess is that access checks for this system.mdb database each
> time an access database is opened?
>
> Like i said, script works, so its not that the file not found is
> causing a problem, i am just wondering why the driver or whatever is
> looking for this file...
A bit of googling suggests that system.mdb is created if specific
permissions are granted on an Access database. If this is the case,
the driver would certainly check for the existence of system.mdb before
opening the target file. The bods over at microsoft.public.access
would be able to clear this one up for you, I suspect.
--
Mike Brind
gil@infomart2000.com wrote:
>
> Actually i am specifying my database, and the script works. The
> database name is db1.mdb and its located in a db folder inside of the
> folder where my site is. ie:
>
> c:\webroot\mydomain.com\script.asp
> database path is
> c:\webroot\mydomain.com\db\db1.mdb
>
> i specified it like that on my connection string.
>
> My only guess is that access checks for this system.mdb database each
> time an access database is opened?
Only if the incorrect connection string arguments are used. Why haven't you
shown us your connection string???
--
Microsoft MVP - ASP/ASP.NET
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"
Bob Barrows [MVP] wrote:
> gil@infomart2000.com wrote:
> >
> > Actually i am specifying my database, and the script works. The
> > database name is db1.mdb and its located in a db folder inside of the
> > folder where my site is. ie:
> >
> > c:\webroot\mydomain.com\script.asp
> > database path is
> > c:\webroot\mydomain.com\db\db1.mdb
> >
> > i specified it like that on my connection string.
> >
> > My only guess is that access checks for this system.mdb database each
> > time an access database is opened?
>
> Only if the incorrect connection string arguments are used. Why haven't you
> shown us your connection string???
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> 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"
Here is my connection string:
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
strconn=strconn & server.mappath("db/db1.mdb") & ";"
The database has no password, is not part of any workgroup, and it has
no linked tables. Script works, i am just concerned why each time the
script opens the database a call for the system.mdb is being made...
wrote on 08 jul 2006 in microsoft.public.inetserver.asp.db:
>
> Bob Barrows [MVP] wrote:
>> gil@infomart2000.com wrote:
>> >
>> > Actually i am specifying my database, and the script works. The
>> > database name is db1.mdb and its located in a db folder inside of
>> > the folder where my site is. ie:
>> >
>> > c:\webroot\mydomain.com\script.asp
>> > database path is
>> > c:\webroot\mydomain.com\db\db1.mdb
>> >
>> > i specified it like that on my connection string.
>> >
>> > My only guess is that access checks for this system.mdb database
>> > each time an access database is opened?
>>
>> Only if the incorrect connection string arguments are used. Why
>> haven't you shown us your connection string???
>>
>>
>> --
>> Microsoft MVP - ASP/ASP.NET
>> 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"
>
> Here is my connection string:
>
> strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
> strconn=strconn & server.mappath("db/db1.mdb") & ";"
>
> The database has no password, is not part of any workgroup, and it has
> no linked tables. Script works, i am just concerned why each time the
> script opens the database a call for the system.mdb is being made...
Do a:
response.write server.mappath("db/db1.mdb")
from the same directory and see if it ends up where you expect it to.
In general I would not do relative mappath-es,
as the asp-file where you start could change.
Better do:
response.write server.mappath("/someDir/db/db1.mdb")
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
gil@infomart2000.com wrote:
> Bob Barrows [MVP] wrote:
>> gil@infomart2000.com wrote:
>>>
>>>
>>> My only guess is that access checks for this system.mdb database
>>> each time an access database is opened?
>>
>> Only if the incorrect connection string arguments are used. Why
>> haven't you shown us your connection string???
>
> Here is my connection string:
>
> strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
> strconn=strconn & server.mappath("db/db1.mdb") & ";"
>
> The database has no password, is not part of any workgroup, and it has
> no linked tables. Script works, i am just concerned why each time the
> script opens the database a call for the system.mdb is being made...
OK, well that IS puzzling. There is no Access-created table that I kow of
called system.mdb.
Here's what I suggest:
Create a new database in Access and import the tables from your existing
database. Rename the original db, give the original name to the new db and
see if opening the database via ADO produces the same error. If not, then
import any saved queries that you need and try again. If you still have no
errors, then your symptom is solved and you can move on ... unless you wish
to investigate the root cause of the problem, about which I will not
speculate until you report te result of this tes.
--
Microsoft MVP - ASP/ASP.NET
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"