Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 19 total
Thread Engine Error # 11010
Mon, Apr 7 2008 2:17 AMPermanent Link

"Jerry Clancy"
D5 Ent., DBISAM Engine 4.21 Build 11, IntraWeb 8.0.22

I've spend 8 hours on this without a resolution. When I compile an app on
the development system I get the following errors:

Error: DBISAM Engine Error # 11010 Table or backup file
'data\us110\dbisam.lck' does not exist'.

Stepping through that I get
Error: DBISAM Engine Error # 11010 Table or backup file 'LOGS' does not
exist at /isapi/btus110.dll/.

Both objects actually do exist at drive:\httpd\data\us110 (nota bene the
lack of the "drive:\httpd\" in the error messages above. A clue?

I have two TDBISAMDatabase objects in the DataModule instance and their
Directory property is set correctly. It matters not whether Connected is
True or False. Deleting the dbisam.lck file has no effect. Nor did verifying
all the database files.

Other factors: All other ISAPI apps I tried compile and run fine. So did
this app a few days ago and I'm at a loss to find the problem. I am also
unable to trace where the error is occurring but it is immediate.I do not
see any incomplete DatabaseName property anywhere.

Any thoughts welcome. This is becoming a show-stopper for me. I do not wish
to waste another day on this.

Could

Mon, Apr 7 2008 3:51 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Jerry


What rights do you/your app have to the directory in question?

Roy Lambert [Team Elevate]
Mon, Apr 7 2008 11:21 AMPermanent Link

"Jerry Clancy"
Total, Roy, and running in localhost mode as a user with admin rights.
Firewall is off. Since it's running in a new XP Pro system I considered
security but can find nothing there so far. Still suspicious, however. All
our other systems are Win2000 and the two OS's don't particularly play well
together with Windows networking. Also, the other apps are working just fine
accessing the same drive in localhost mode which tends to eliminate a local
server or security issue -- but never say never.

I've deleted DCUs, rebuilt, rebooted and even completely repaired and
regenerated indexes with dbsys trying to eliminate potential issues. I may
restore the code to an older backup and see what happens. Suspect that there
is something in the code that has been corrupted or something.

If Tim has any clue about this I'd appreciate hearing it.

Jerry

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:619C1C69-A07A-469A-9A69-DC1C56E6347F@news.elevatesoft.com...
> Jerry
>
>
> What rights do you/your app have to the directory in question?
>
> Roy Lambert [Team Elevate]
>

Mon, Apr 7 2008 11:59 AMPermanent Link

"Jerry Clancy"
I've restored the code from a prior backup known to be good and am getting
the same 11010 error, so it apparently isn't a code issue.

Jerry

Mon, Apr 7 2008 12:56 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< Both objects actually do exist at drive:\httpd\data\us110 (nota bene the
lack of the "drive:\httpd\" in the error messages above. A clue? >>

Yes, most definitely.  The issue is that somewhere you've specified a
relative path to the database directory, and the current working directory
has changed during application execution, thus making the relative path
invalid.

I would do this - load up the ISAPI application in the IDE, set the
Run..Parameters..Host Application so that you're running the web server as
the host application, hit F9 to run the web server, and then see where the
ISAPI application breaks on the error.  It should break right on the
Connected:=True or Open line of code where the database or table is being
opened.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Apr 7 2008 1:35 PMPermanent Link

"Jerry Clancy"
Thanks, Tim. We'll give it a try. The local host application in Run |
Parameters | Local is set to the full path of the server .exe on the local
system. It was one of the first things I checked.

BTW, the generated DLL works if run in localhost mode on another development
system, FWIW.

Jerry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:D4333A0A-C499-42F9-B983-2A06BE0020AB@news.elevatesoft.com...
> Jerry,
>
> << Both objects actually do exist at drive:\httpd\data\us110 (nota bene
> the lack of the "drive:\httpd\" in the error messages above. A clue? >>
>
> Yes, most definitely.  The issue is that somewhere you've specified a
> relative path to the database directory, and the current working directory
> has changed during application execution, thus making the relative path
> invalid.
>
> I would do this - load up the ISAPI application in the IDE, set the
> Run..Parameters..Host Application so that you're running the web server as
> the host application, hit F9 to run the web server, and then see where the
> ISAPI application breaks on the error.  It should break right on the
> Connected:=True or Open line of code where the database or table is being
> opened.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Mon, Apr 7 2008 1:44 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Jerry

>All
>our other systems are Win2000 and the two OS's don't particularly play well
>together with Windows networking.

Wait till you get to the joy that is Vista Smiley

Roy Lambert
Mon, Apr 7 2008 1:45 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< Thanks, Tim. We'll give it a try. The local host application in Run |
Parameters | Local is set to the full path of the server .exe on the local
system. It was one of the first things I checked. >>

Actually, I meant using a full path in the TDBISAMDatabase.Directory
property or the TDBISAMTable.DatabaseName property, not the host application
directory.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Apr 7 2008 2:26 PMPermanent Link

"Jerry Clancy"
No way that's happening. Normally the rule of thumb for MS products is
always wait for Service Pack 3. In Vista's case, it is wait for its
successor.

Biggest mistake MS ever made. Did nothing but cause grief.

Jerry

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:F864DA98-EC67-4F87-984F-92022314F21C@news.elevatesoft.com...
> Jerry
>
>>All
>>our other systems are Win2000 and the two OS's don't particularly play
>>well
>>together with Windows networking.
>
> Wait till you get to the joy that is Vista Smiley
>
> Roy Lambert
>

Mon, Apr 7 2008 2:32 PMPermanent Link

"Jerry Clancy"
Oh, I did that a long time ago. Still doesn't work with a valid local
directory in both (the only) TDBISAMDatabase components.

Here's another clue. I blew away the Host Application path completely in
run, started the server independently and then ran the DLL in IE. Works just
fine, thank you, but not in the IDE with Run set. What is this telling us?

Also, can degub where it breaks, even with madexcept. I happens immediately
while IE is still showing "Connecting..."

I looked at every DatabaseName property in the DM to make sure there were no
partial or relative paths. All are set to the correct local drive and folder
in the IDE designer.

I have no idea where to go from here. I've exhausted all my tricks.

Jerry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:A534552C-5B02-4C92-87D9-615491DE17FC@news.elevatesoft.com...
> Jerry,
>
> << Thanks, Tim. We'll give it a try. The local host application in Run |
> Parameters | Local is set to the full path of the server .exe on the local
> system. It was one of the first things I checked. >>
>
> Actually, I meant using a full path in the TDBISAMDatabase.Directory
> property or the TDBISAMTable.DatabaseName property, not the host
> application directory.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Page 1 of 2Next Page
Jump to Page:  1 2
Image