submitform PROBLEM 2ND PART //PLEASE HELP!

[guido]

created databased website, including a submitform, db-editor and resultspage.
error after sending submitform: job failed, contact serverhost when problem
keeps occurring.
contacted serverhost, problem is that Frontpage 2003 makes the database in
the obligated map ''fpdb'' but the serverhost obligates me to put my database
in the map ''_private'' which is on the website to enable writing to the
database.

When uploading the database is not writable when located in ''fpdb'' because
the serverhost doesn't give permission
But uploaded in the ''_private", the "global.asa" file gives a problem as
the "global.asa"file says it is obligated to put the database in the
"fpdb"map

I guess i'm between wall and ship.......what can i do?
thanks for responding..... guido www.gvanb.com

 

[Kevin Spencer]

Hi guido,

The global.asa file is a text file. Just edit it after you publish, and
exclude it from future publishes.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[guido]

kelvin,

edited the global.asa file via the networklocations map, but i keep getting
the same error. Even after i edited the config-file also.

edited like this.
global.asa:
Application("database1_ConnectionString") = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=_private/database1.mdb"

config file:
<configuration><appSettings><add key="database1_Provider"
value="Microsoft.Jet.OLEDB.4.0"/><add key="database1_DataSource"
value="_private/database1.mdb"/><add key="database1_ConnectionTimeout"
value="15"/><add key="database1_CommandTimeout" value="30"/><add
key="database1_CursorLocation" value="3"/><add
key="database1_RuntimeUserName" value=""/><add
key="database1_RuntimePassword" value=""/></appSettings></configuration>

what can i do more?
thanks for your help sofar!
guido / www.gvanb.com

 

[Kevin Spencer]

Try:

DBQ=URL=/_private/database1.mdb

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[guido]

sorry, doesn't work,

tried it with copy and paste.
Application("database1_ConnectionString") = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=/_private/database1.mdb"

but still same error. Do you might know anything else?

 

[Ronx]

Try replacing database1.mdb with the name of your database file.

 

[guido]

Ronx,

before i make a real database, i wanted to check if it works, so i made the
example database, and the database IS called database1

 

[Ronx]

Tools->Web/Site Settings - Database Tab

This should show a connection named Database1. Click on it to
highlight, then click Verify.
If it fails to verify use the Modify button to correct the path to
the database.

If there is no database connection shown, then use Add to add the
database.
The status will probably show a ? character, if so click Verify, when
it should change to a tick.
The global.asa file will be automatically updated.