Form with MS SQL connection

[Gismo]

Hi, I re-posted my problem. It's been driving me nuts.
I am working with and existing company intranet website.
I wanted a new page with a form that people would enter
data that I would collect in a SQL Database that
I created on the same box.

I created a new asp page.
On the new page I added a Form.
I created a new MS SQL data base.
I created a new System DSN connector (sql connector).
I connected the Form to the database connector.
Verified the connection. Connection displayed as good.
I saved the new page.
I go to IE and connect to URL (which is homepage anyway).
http://localhost/ ( The Web is in a seperate partition and not in root)
I see my new page and new form with drop down's, select data, then
hit the Submit button.
I go to database table and nothing.
So I inserted a DRW to read the data in the database and I get an
error message:

Database Results Error
The database connection named 'Logbook' is undefined.

This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root

I've searched the help files and can't find anything detailed enough
to point to a problem.

Please Help

 

[Andrew Murray]

I think you need MS SQL Server......or some 'lite' sql server software (I
think something like that is included in the Visual Web Developer Express
download package - for testing of .Net applications).

I'm no expert, but I believe that's what you're missing.

 

[Andrew Murray]

What I meant to add is for testing of .NET applications that utilise MS Sql.

 

[Gismo]

I have MS SQL on the machine and there are several data bases that interact
with the website. The developers of the web site used a more sophisticated
method that I don't have time to learn. I wanted to use a simple method for
a simple application. When it's time to update or migrate to Server2003. I
will use something other than Frontpage. I may just scrap the whole thing
and look for a Unix/Sun solution.