Unable to Create Database Connection

P

Peter D

Hello
I am trying to create a data entry page in FP2002
I create the form, and select Form Properties, Send to Database. It then asks me to create the database connection. I go through the steps to do that and everything is fine. I verify the connection, and it verifies properly. Then I click OK and it takes me back to the Options For Saving Results to Database page, but the Connection is not saved in the drop down box. If I click OK, it tells me "A valid database connection is required". It seems to refuse to save the connection information
This occurs with type of connection, Access, DSN, SQL. It occurs on existing forms and newly created forms. It occurs if i create a new web and form from scratch. There is a global.asa file and it appears to have the correct connection information
What am I doing wrong here
Thanks

Peter Diamond
 
N

Net55

This is a new one for me, check outfront.net forums...bet
they will know.

Net55
[email protected]
http://www.frontpagewiz.com
-----Original Message-----
Hello,
I am trying to create a data entry page in FP2002.
I create the form, and select Form Properties, Send to
Click to expand...
Database. It then asks me to create the database
connection. I go through the steps to do that and
everything is fine. I verify the connection, and it
verifies properly. Then I click OK and it takes me back
to the Options For Saving Results to Database page, but
the Connection is not saved in the drop down box. If I
click OK, it tells me "A valid database connection is
required". It seems to refuse to save the connection
information.
This occurs with type of connection, Access, DSN, SQL.
Click to expand...
It occurs on existing forms and newly created forms. It
occurs if i create a new web and form from scratch. There
is a global.asa file and it appears to have the correct
connection information.
 
A

Art

Try creating your connection from Tools > Web Settings >
Database.

-----Original Message-----
Hello,
I am trying to create a data entry page in FP2002.
I create the form, and select Form Properties, Send to
Click to expand...
Database. It then asks me to create the database
connection. I go through the steps to do that and
everything is fine. I verify the connection, and it
verifies properly. Then I click OK and it takes me back
to the Options For Saving Results to Database page, but
the Connection is not saved in the drop down box. If I
click OK, it tells me "A valid database connection is
required". It seems to refuse to save the connection
information.
This occurs with type of connection, Access, DSN, SQL.
Click to expand...
It occurs on existing forms and newly created forms. It
occurs if i create a new web and form from scratch. There
is a global.asa file and it appears to have the correct
connection information.
 
T

Thomas A. Rowe

Do you current have a web open (File Menu | Open web) and not just a file, prior to attempting this?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
P

Peter D

Yes

----- Thomas A. Rowe wrote: ----

Do you current have a web open (File Menu | Open web) and not just a file, prior to attempting this

--
=============================================
Thomas A. Rowe (Microsoft MVP - FrontPage
WEBMASTER Resources(tm
http://www.ycoln-resources.co
FrontPage Resources, WebCircle, MS KB Quick Links, etc
=============================================
To assist you in getting the best answers for FrontPage support see
http://www.net-sites.com/sitebuilder/newsgroups.as
 
P

Peter D

I tried that and it imports properly, but then when I go to Tools > Web Settings > Database, the connection is not listed
Seems like something is wrong with FP itself. Maybe a reinstall is needed

----- Kathleen Anderson [MVP - FP] wrote: ----

Peter
Do you have an existing database that you could import into your web site
Try this: http://www.spiderwebwoman.com/tutorials/create_dbc.ht
 
Top