Unreliable data being returned via ASP

[Vladtheemailer]

Hi

I originally posted this cry for help in the general discussion forum...but no
one replied....I have since noticed that this forum seems to be more relevant
to the problem I have so I hope no one minds me posting the question again!

I am new to Dreamweaver and have been trying to create a website using ASP. I
have created a connection to an Access 2000 database and have 3 or 4 pages
which should display fairly simple recordsets. My trouble is that the actual
data only appears occasionally...prob fails 8 times out of 10. The message
displayed indicates that the data/webpage could not be found. This also happens
when using the Live Data function. Other pages which do not have dynamic data
seem to be ok....I am using xp pro and DW2004 and I am developing the site
locally...The data usually displays first time of asking when I close down DW
then re-open again....otherwise there doesnt appear to be any pattern to the
behaviour....any help would be appreciated



Steve
:confused;

[Lionstone]

Close Dreamweaver and test the site on your remote server. I don't remember
details, but I know DW has locking issues in some cases with Access
databases. Search the MM Technotes section for specifics.


"Vladtheemailer" <webforumsuser@macromedia.com> wrote in message
news:d5o948$d9c$1@forums.macromedia.com...

> Hi
>
> I originally posted this cry for help in the general discussion
> forum...but no
> one replied....I have since noticed that this forum seems to be more
> relevant
> to the problem I have so I hope no one minds me posting the question
> again!
>
> I am new to Dreamweaver and have been trying to create a website using
> ASP. I
> have created a connection to an Access 2000 database and have 3 or 4 pages
> which should display fairly simple recordsets. My trouble is that the
> actual
> data only appears occasionally...prob fails 8 times out of 10. The message
> displayed indicates that the data/webpage could not be found. This also
> happens
> when using the Live Data function. Other pages which do not have dynamic
> data
> seem to be ok....I am using xp pro and DW2004 and I am developing the site
> locally...The data usually displays first time of asking when I close down
> DW
> then re-open again....otherwise there doesnt appear to be any pattern to
> the
> behaviour....any help would be appreciated
>
>
>
> Steve
> :confused;
>

[Vladtheemailer]

:confused;
Hi
Thanks for advice....but still no joy...
I have upgraded to v7.1 and also carried out all of the changes specified in
the IIS bulletin relating to access to databases etc....but to no avail..still
same probs...when I test the various recordsets in DM bindings panel..the data
returns 100% accurately...I am using xp Pro service pack 2...Maybe some issue
with popups or something else peculiar to this flavour of xp?

I am also working using a local server so can't test remotely..
Any help or advice would be appreciated


Steve

[Vladtheemailer]

I have since noticed that afterfailing the database has a lock file open in the same folder as the database is loctaed...is this significant?

[CarlGrint]

Have a read of 'The infamous 80004005 errors' at
[url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=56[/url]

Originally posted by: Vladtheemailer
I have since noticed that afterfailing the database has a lock file open in
the same folder as the database is loctaed...is this significant?

[Vladtheemailer]

Eureka!!!!!...Thanks for you help...worked a treat!

Steve