Database Connection on Server

[MaureenKLM]

FP Web with Access Databases. Lots of forms feeding one of two databases -
lots of DBRs showing this info - several database interface pages that all
seem to work....except...

the the DBIW pages seem to generate a database connection error - the error
that comes back indicates that the page is looking for the database in the
FPDB folder INSIDE THE DBI directories - of course the FPDB folder is in the
root directory. What would cause it to look for it in one of the directories
created by the DBIW and holding the DBI pages? I have checked
Tools/Websettings on the server and the path to the databases are correct and
verified. I did a search on the website pages to see if the incorrect path
is part of a line of code somewhere - it does not appear in the seach results.

Anyone have Any Clues what might be causing the misdirected DB path?

 

[Thomas A. Rowe]

The fpdb folder must be in the same web as the asp pages, so if the fpdb folder is in the root web,
then pages must also be in the root web, they can not be in a subweb/site unless the fpdb folder is
also in the subweb/site when using FP to connect to the database. If you however use a System DSN
connection, then the database can be anywhere on the same server as the web site.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[MaureenKLM]

Thanks for the reply! Of course you are correct - and I was not clear enough
in my initial communication - the fpdb directory is in the web right where FP
puts it - I did not move anything.

Interestingly...when this DB error occurs, Both of the database connections
in the website "error" out - looking for the databases in the wrong places.
I checked the global.asa file and the paths outlined in there are correct.
What on earth could be causing this? How can a visitor (albeit one with the
login info to get into the db from a web browser) alter the database
connections?

Thanks for any additional insight you can offer!

 

[Thomas A. Rowe]

With the live/remote site open in FP, have you checked/verified the connection via Tools | Site
Settings / Database

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[MaureenKLM]

Yes, I have - they are verified.

With the live/remote site open in FP, have you checked/verified the connection via Tools | Site
Settings / Database

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[Thomas A. Rowe]

Contact your web host and ask them to check the Application setting for the web under the Home
Directory Tab in IIS. They may need to delete and then recreate it.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[MaureenKLM]

Thanks again! Made the suggestion to the Host - Host says that the app
setting is good -

When I republish the global.asa file the DB errors are all fixed - site
displays as it should. With all DBR's and DBI's displaying as they
should....A visitor CLEARED/DELETED cached pages and cookies from his
machine, then went to the site's home page, url. then went into a DBI page,
correctly logged in and immediately got the DB error again as shown below:

Database Results Error
'E:\CustomerData\webspaces\webspace_00100583\wwwroot\boys\DBReg_interface\tblPmtsRcv\editor\fpdb\Data.mdb'
is not a valid path. Make sure that the path name is spelled correctly and
that you are connected to the server on which the file resides.

NOTE: the Data.mdb database is in the fpdb folder along side all of the
other folders in this website; right where FP created it. As you can see,
it's looking for the DB in the DBI directories - Without fixing the problem,
I used FrontPage to open the site on the server, The tools/websettings
database connections were both correct as originally set and both verified.
The global.asa file on the server still had the correct dbconnection strings
set as:

Application("DBReg_ConnectionString") = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/Reg.mdb"

And a similar string for fpdb/data.mdb

What could cause the database connections to get so messed up? I'm at a
loss for where to look -

THANKS for any additional assistance anyone can offer!

 

[Thomas A. Rowe]

Ask your web host if you can use a System DSN, as you never want a user to see the path to a
database.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[MaureenKLM]

Thanks again for your continued help! I believe the only reason the visitor
sees the path is because I have the DEBUG = TRUE in the fpdbrgn1 file

Do you think a system DSN could help anyway?

I have TWO websites at the same URL - totally separate websites each in its
own web directory at one URL - do you think this could have anything to do
with the database misdirect problem?

 

[Thomas A. Rowe]

A system DSN will allow you to have the database anywhere on the server's HD.

Regarding your question about the 2 sites, It depends on which site is firing the global.asa file.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================