SQL Server Connection Problems

[Guest_imported]

Hello,

I'm attempting to put data from a query in SQL Server to an ASP page on my WEB Server. I did this using the wizard in FrontPage. The following error is displayed when the page is viewed:

"Database Results Error
The database connection name 'test' is undefined."

'test' is the name of the connection in FrontPage and it simply points to an ODBC System DSN called 'forte'. I'm puzzled because the ODBC connection 'forte' was tested successfully.

I've tried the following measures:

On SQL Server:
- created new login called 'administrator' with necessary full permissions to access my views
- ensured the all the permissions on database enabled access
- set the default connection to TCP
- tried both the 'Windows NT Only' and the 'Windows NT and SQL Server' authentications

On IIS:
-permited execution on the virtual directory containing the ASP file that will hold the recordset
- set the UID to 'administrator' in the Advanced menu when creating the connection in FrontPage. It verifies OK.

Thanks, Mitch.