• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

cannot open the file '(unknown)'

New Here ,
Aug 07, 2006 Aug 07, 2006

Copy link to clipboard

Copied

Hi,
I am getting an error when I try to test an asp page (vb) with a recordest in it.
The Microsoft Jet database engine cannot open the file '(unknown)'.
When I double-click the recordset in dreamweaver and click test it works fine though.
I haven't got the db open elsewhere and don't think it's read-only, so I can't work it out.
Help!
Thanks, Mark.
TOPICS
Server side applications

Views

614

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 07, 2006 Aug 07, 2006

Copy link to clipboard

Copied

Hi,

After the "The Microsoft Jet database engine cannot open the file
'(unknown)'." does it then say "File already in use" or something similar?
If you open an ASP/VB page in DW, that has a link to your database
(Recordsets), it can sometime cause the temp yourdatabase.ldb to be created.
When you shut the page down, for some reason DW doesn't remove the ldb which
means that when you test the page under localhost it will not open because
the database is "already in use".

The only way to solve this is to close DW and re-open. Tedious I know, but
this is something that has been a problem since UD4 and I'm not sure if it's
been fixed yet.

Check for the existence of an .ldb file...that'll be your problem I'm sure.

HTH
Nath.

"funkster" <webforumsuser@macromedia.com> wrote in message
news:eb73g7$92l$1@forums.macromedia.com...
> Hi,
> I am getting an error when I try to test an asp page (vb) with a recordest
> in
> it.
> > When I double-click the recordset in dreamweaver and click test it works
> > fine
> though.
> I haven't got the db open elsewhere and don't think it's read-only, so I
> can't
> work it out.
> Help!
> Thanks, Mark.
>


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 07, 2006 Aug 07, 2006

Copy link to clipboard

Copied

Thanks for your response.
I checked that out but even if I check there's no lock file and reopen dreamweaver it doen't work. Even if I close dreamweaver and try to view the page with a web browser I get the same error.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 07, 2006 Aug 07, 2006

Copy link to clipboard

Copied

Does it say anything, in the error you're getting, after this bit:
"The Microsoft Jet database engine cannot open the file '(unknown)'."

...??

Or is that all you are getting as an error message?

Also, are you testing online or offline?

Nath.

"funkster" <webforumsuser@macromedia.com> wrote in message
news:eb7i93$qai$1@forums.macromedia.com...
> Thanks for your response.
> I checked that out but even if I check there's no lock file and reopen
> dreamweaver it doen't work. Even if I close dreamweaver and try to view
> the
> page with a web browser I get the same error.
>
>


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 08, 2006 Aug 08, 2006

Copy link to clipboard

Copied

yes, it says 'it is already opened exclusively by another user, or you need permission to view its data.'

This is on my local machine WinXP running IIS.

btw. I have used this machine to do this successfully in the past but at the moment it's not working.

thanks

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 08, 2006 Aug 08, 2006

Copy link to clipboard

Copied

yes, it says 'it is already opened exclusively by another user, or you need
permission to view its data.'

This is on my local machine WinXP running IIS.

btw. I have used this machine to do this successfully in the past but at the
moment it's not working.

thanks

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 08, 2006 Aug 08, 2006

Copy link to clipboard

Copied

Hi. And you've checked permissions on the folder that contains the
database? (sorry for asking the obvious!)
If you're sure that there isn't a .ldb file in the same folder as your
database, then I'm sure it's a permissions issue.

HTH.
Nath.

"funkster" <webforumsuser@macromedia.com> wrote in message
news:eb9gv2$ak7$1@forums.macromedia.com...
> yes, it says 'it is already opened exclusively by another user, or you
> need
> permission to view its data.'
>
> This is on my local machine WinXP running IIS.
>
> btw. I have used this machine to do this successfully in the past but at
> the
> moment it's not working.
>
> thanks
>


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Dec 03, 2020 Dec 03, 2020

Copy link to clipboard

Copied

LATEST

Test body 2 in TFB

sample text 15Lnr

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 09, 2006 Aug 09, 2006

Copy link to clipboard

Copied

i can't find anythingwrong with the permissions.
tell me if you think this is significant:-

when i select my dsn i choose the 'use local dsn' radio button - when i test it it says it's successful. (though it doesn't work later)

if instead i choose 'use dsn on testing server' (the testing server is on my current machine) and click test i get the same error as i get when i preview.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines