cannot open the file '(unknown)'

[funkster-qv5H7D]

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.

[Newsgroup_User]

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.
>

[funkster-qv5H7D]

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.

[Newsgroup_User]

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.
>
>

[funkster-qv5H7D]

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

[Newsgroup_User]

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

[Newsgroup_User]

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
>

[haa_prod_test]

Test body 2 in TFB

[funkster-qv5H7D]

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.