Facing problem while uploading the database

[roshanpoy]

Hi,

I have uploaded all the files of my website and i still have to work
on the database.

What should I do to upload the database.please help as this would be
my 1st project.

And also let me know how could I Import the database from my local
server.

Thanks
Roshan.

 

[Thomas A. Rowe]

The database should have already been created or imported into your local copy of your web in the
fpdb folder, then when you publish to a Windows IIS web server with ASP support it should work.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[roshanpoy]

I am trying to create the database and connet it through the remote
server but am not able to connect and it states that default setting
failed to connect to the remote server.

 

[Thomas A. Rowe]

You have the remote site open in FP on a Windows IIS server with ASP support, then you create the
form and then select to have FP create the database.

or

you work in a site locally on your pc, where you create the form and then select to have FP create
the database, then you publish the site to the live/remote Windows IIS web server with ASP support.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[IdaSpode]

Normally, I'd create the database first, upload or "import" it to the
web, create the database connection then design the form to match the
DB fields. If you import the DB into a live web, FP should prompt you
to place it in a fpdb folder and ask if you'd like a DB connection to
be established for it.

Like Tom sez, you can also create the form and let FP create the
database based on the fields contained in the form. If you do it this
way, take care designing the form when naming the fields, no spaces
and no "reserved names". Consult Access help, search "naming fields"
in the answer wizard for details.

DJ