XP/Apache/Runtime BDE Issue.

[Dean Watson]

I am trying to commission an XP web server, but seem to be running into BDE
issues. I can execute a simple web app with no problems, but the first time
there is an attempt to open a dBase table, I get the following error:

Database Engine Error: Invalid file name.

If I try to execute a web app with a DMD compiled into it, everything just
freezes. I have tried both Apache 2.2.9 and 2.0.63. I have 3 other web
servers running the same apps on NT4 with no problems. I also have an XP
machine acting as an Apache Reverse Proxy Server with no problems (this
machine will also act as a Reverse Proxy Server without a problem).

Any help greatly appreciated. BDE version is 5.01.

--
Dean Watson

[Claus Mygind]

Dean,

I run an Apache server v 2.0.54 at home on my XP and the same bde version
as you with no problem.

Just some obvious things to check (I'm sure you already have them setup).
1) You have setup your ODBC data source?
2) In the BDE connection you have set the SQLQRYMODE to "Server" if you are
not using dBase .dbf tables
3) If you are using the .dbf tables the default driver is "DBASE"
4) your tables are not password protected or if they are you include the
login string when opening the database

In your web app set some traps to stop the processing and report back
results, to make sure indeed it is the file name and not some other thing
that is causing the problem. First set a trap right below the connection
line, then move the trap down one line at the time to see if you even get to
the line trying to open the file.

Finally if you could show a little code of how you make a connection to the
server with the app and how you log onto the file (minus the relevant path
or password info) that could be of help to us in trying to help you

Claus

Post by Dean Watson
I am trying to commission an XP web server, but seem to be running into BDE
issues. I can execute a simple web app with no problems, but the first time
Database Engine Error: Invalid file name.
If I try to execute a web app with a DMD compiled into it, everything just
freezes. I have tried both Apache 2.2.9 and 2.0.63. I have 3 other web
servers running the same apps on NT4 with no problems. I also have an XP
machine acting as an Apache Reverse Proxy Server with no problems (this
machine will also act as a Reverse Proxy Server without a problem).
Any help greatly appreciated. BDE version is 5.01.
--
Dean Watson

[Dean Watson]

Hi Claus,

Thanks for your reply. All the BDE settings are the same as used on the rest
of my web servers without any problems. I am inclined to think the problem
may be associated with the interaction between XP, the Novell Client and my
Novell Server (the alias in question points to a directory on a Novell
Server.) I will try creating an alias that points to the local hard drive
and see if that also fails. I can manually open dBase on the machine and
access tables in the directory without any issues, by selecting the alias in
the drop-down list of available data locations. I can also access MySQL
tables on another machine, using an ODBC driver. I can also run an
experimental app I have on this server that runs some Ajax code to reflect
back some System Parameters without any problems.

Out of interest, do you use the System Account or a User Account to start
the Apache Service?

Regards, Dean.

Post by Claus Mygind
Dean,
I run an Apache server v 2.0.54 at home on my XP and the same bde version
as you with no problem.
Just some obvious things to check (I'm sure you already have them setup).
1) You have setup your ODBC data source?
2) In the BDE connection you have set the SQLQRYMODE to "Server" if you are
not using dBase .dbf tables
3) If you are using the .dbf tables the default driver is "DBASE"
4) your tables are not password protected or if they are you include the
login string when opening the database
In your web app set some traps to stop the processing and report back
results, to make sure indeed it is the file name and not some other thing
that is causing the problem. First set a trap right below the connection
line, then move the trap down one line at the time to see if you even get to
the line trying to open the file.
Finally if you could show a little code of how you make a connection to the
server with the app and how you log onto the file (minus the relevant path
or password info) that could be of help to us in trying to help you
Claus

Post by Dean Watson
I am trying to commission an XP web server, but seem to be running into BDE
issues. I can execute a simple web app with no problems, but the first time
Database Engine Error: Invalid file name.
If I try to execute a web app with a DMD compiled into it, everything just
freezes. I have tried both Apache 2.2.9 and 2.0.63. I have 3 other web
servers running the same apps on NT4 with no problems. I also have an XP
machine acting as an Apache Reverse Proxy Server with no problems (this
machine will also act as a Reverse Proxy Server without a problem).
Any help greatly appreciated. BDE version is 5.01.
--
Dean Watson

[Claus Mygind]

Do you mean - do I run Apache from the console or as a service. I start
Apache from the console.

With regards to access of my data - On my system at home I simply use the
system account. On the one I run at work I use a user account. At home I
access MySQL and dbase tables at work I access MySQL tables only. At work
we use a Novell Network, so we have not been able to use Vista machines but
xP clients works fine. The data files we run at work reside on a separate
machine dedicated to MySQL.

Not sure if this answers your questions.

I have to say though sometimes when I have had a bug in one of my apps, it
returns a file access problem when in reality that was not the problem at
all. But I do understand that you are running the exact apps on the new
machine as you are on the existing (working machines)

Claus

Post by Dean Watson
Hi Claus,
Thanks for your reply. All the BDE settings are the same as used on the rest
of my web servers without any problems. I am inclined to think the problem
may be associated with the interaction between XP, the Novell Client and my
Novell Server (the alias in question points to a directory on a Novell
Server.) I will try creating an alias that points to the local hard drive
and see if that also fails. I can manually open dBase on the machine and
access tables in the directory without any issues, by selecting the alias in
the drop-down list of available data locations. I can also access MySQL
tables on another machine, using an ODBC driver. I can also run an
experimental app I have on this server that runs some Ajax code to reflect
back some System Parameters without any problems.
Out of interest, do you use the System Account or a User Account to start
the Apache Service?
Regards, Dean.

Post by Claus Mygind
Dean,
I run an Apache server v 2.0.54 at home on my XP and the same bde version
as you with no problem.
Just some obvious things to check (I'm sure you already have them setup).
1) You have setup your ODBC data source?
2) In the BDE connection you have set the SQLQRYMODE to "Server" if you

are

Post by Claus Mygind
not using dBase .dbf tables
3) If you are using the .dbf tables the default driver is "DBASE"
4) your tables are not password protected or if they are you include the
login string when opening the database
In your web app set some traps to stop the processing and report back
results, to make sure indeed it is the file name and not some other thing
that is causing the problem. First set a trap right below the connection
line, then move the trap down one line at the time to see if you even get

to

Post by Claus Mygind
the line trying to open the file.
Finally if you could show a little code of how you make a connection to

the

Post by Claus Mygind
server with the app and how you log onto the file (minus the relevant path
or password info) that could be of help to us in trying to help you
Claus

Post by Dean Watson
I am trying to commission an XP web server, but seem to be running into

BDE

Post by Claus Mygind

Post by Dean Watson
issues. I can execute a simple web app with no problems, but the first time
Database Engine Error: Invalid file name.
If I try to execute a web app with a DMD compiled into it, everything

just

Post by Claus Mygind

Post by Dean Watson
freezes. I have tried both Apache 2.2.9 and 2.0.63. I have 3 other web
servers running the same apps on NT4 with no problems. I also have an XP
machine acting as an Apache Reverse Proxy Server with no problems (this
machine will also act as a Reverse Proxy Server without a problem).
Any help greatly appreciated. BDE version is 5.01.
--
Dean Watson

[Claus Mygind]

Maybe one more suggestion, it does not appear as you have stated in your
original question that this has anything to do with apache as you can launch
runtime and execute a dBase app that does not open a file.

Why don't you also post your question in the install-config NG or the
sql-server NG, you may get some better tips than I am trying to give you.

Claus

[Greg Neid]

If your tables are on the Novell server, consider this.

BDE creates tables such as _QSQL000.DBF, whenever you use and sql with order by. The "_" may be an illegal file name for Novell. I am not really familiar with Novell.

Greg Neid

Post by Dean Watson
I am trying to commission an XP web server, but seem to be running into BDE
issues. I can execute a simple web app with no problems, but the first time
Database Engine Error: Invalid file name.
If I try to execute a web app with a DMD compiled into it, everything just
freezes. I have tried both Apache 2.2.9 and 2.0.63. I have 3 other web
servers running the same apps on NT4 with no problems. I also have an XP
machine acting as an Apache Reverse Proxy Server with no problems (this
machine will also act as a Reverse Proxy Server without a problem).
Any help greatly appreciated. BDE version is 5.01.
--
Dean Watson