Database Results Error

G

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? :)
 
G

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?
 
G

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.
 
G

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\.
 
G

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.





Gismo said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top