Database Results Error

[Gismo]

Both MS SQL & Web is on same box. A Company
Intranet Web Page.
I created a new asp page to an existing web.
On the new page I added a Form. I created
a new MS SQL data base. I created a new
System DSN connector. Now I try to connect the
Form to the database with no results. So I try to insert
a DRW to see if my problem is bi-directional 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

A clue anyone?

 

[Kathleen Anderson [MVP - FrontPage]]

Verify your database connection, go to Tools | Web Settings | Database click
once on the connection and click the Verify button, and click OK. If the
connection is not there you need to create it.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

 

[Gismo]

I did that exercise and corrected a mistake I had made earlier. The Verify
procedure is successful, but I still have the error message.
Do I have to publish the new page even though I created it in the Web
directory
and I can view the new page on another networked machine?

 

[Kathleen Anderson [MVP - FrontPage]]

Are you opening your web as C:\inetpub\wwwroot\yoursubweb and previewing the
page from there? Try opening your web as http://localhost/yoursubweb and
previewing it from there.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Gismo]

This is an existing web (company Intranet site). I just added a page with a
Form that I wanted to connect to a new data base. I was using IE to open
which did open using http://localhost/. I can view the new page from other
machines on the network. I created a SQL DB. I created a System DSN (sql
connector). Then I created the Form with the existing sql connector. The
form will have several items connected to fields in the new DB. Then the
Submit button. I'm not sure about a subweb but, I will double check in the
morning. Thanks for your time and patience.

 

[Gismo]

When I try to make a new connection to the existing DSN connector and I
don't name it the same I get this error message:

Server error: Unable to connect to a database from the web server using the
connection string 'DSN=Logbook;DRIVER={SQL Server}'.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217843 (0x80040e4d)

If I name the new data base connection the same as the DSN connector it
Verifies OK, but still nothing works.

Also, my web is in a seperate partition than the C:\inetpub\wwwroot\.

 

[Gismo]

Belay my last. I didn't add the admin password when I created the last
connection.
I've done so many things to try to get the Form to connect to the database,
I'm starting to confuse myself.
Also, my web is in a seperate partition than the C:\inetpub\wwwroot\.

The Saga continues. I'm so far down on the list but, I hope someone will
still read this and have a clue for me.

When I try to make a new connection to the existing DSN connector and I
don't name it the same I get this error message:

Server error: Unable to connect to a database from the web server using the
connection string 'DSN=Logbook;DRIVER={SQL Server}'.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217843 (0x80040e4d)

If I name the new data base connection the same as the DSN connector it
Verifies OK, but still nothing works.