FrontPage error accessing SQL db

[cmh]

I am running a SQL query in order to present results from
an SQL database. This use to work. I moved my intranet
to a new server and now I receive an error. The ODBC
connection is there and it tests fine. I run the SQL
query using Query Analyzer and it runs fine, but when I
try to run the query through my frontpage/asp program I
get the following error. I have checked all the
suggestions listed below and can't figure why this won't
work. If anyone has any ideas I would appreciate the help.

LastName cr_num status_general orig_date txtTitle
date_orig_request feas_est_comp_date date_comp
Database Results Wizard Error
The database connection named 'CR' 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

 

[Thomas A. Rowe]

Have you verified the connection on the live/remote site from within FP using Tools | Site Settings
| Database?

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

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

 

[cmh]

-----Original Message-----
Have you verified the connection on the live/remote site

from within FP using Tools | Site Settings

| Database?

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

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




.
Yes. Strange thing is. It always disappears. I add it,

verify it, save my file and when I open it back up again
it is gone.

 

[Thomas A. Rowe]

Then there is problem with the server connecting to the database server.

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

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

 

[cmh]

-----Original Message-----
Then there is problem with the server connecting to the database server.

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

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




.
Any suggestions? As far as I can tell everything is

fine.

 

[cmh]

-----Original Message-----
Then there is problem with the server connecting to the database server.

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

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




.
Why does it verify okay then? I should receive an error

when I try verifying it.

 

[Thomas A. Rowe]

Have you tried changing your connection string, using a System DSN connection, etc., especially
since you have moved from NT4 to either Windows 2000 or Windows 2003 server where the MDAC is newer?

Have you marked the web site as a application root, have you installed all updates for the FP2000
extensions, if Windows 2000 Server or upgraded to the FP2002 extensions, etc. Windows 2003 comes
with separate set FP2002 extensions, that currently can not be updated.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

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

 

[cmh]

-----Original Message-----
Have you tried changing your connection string, using a

System DSN connection, etc., especially

since you have moved from NT4 to either Windows 2000 or

Windows 2003 server where the MDAC is newer?

Have you marked the web site as a application root, have

you installed all updates for the FP2000

extensions, if Windows 2000 Server or upgraded to the

FP2002 extensions, etc. Windows 2003 comes

with separate set FP2002 extensions, that currently can not be updated.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

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




.
Both servers have Windows 2000 SP 4. I have recreated

the DSN several times. All updates have been installed.
Sorry, but how do I check this, "Have you marked the web
site as a application root"?

 

[Thomas A. Rowe]

In IIS MMC, right click on the web, then properties, home directory tab, then at the bottom of the
dialog, application, click delete/remove, then click create. Then it is a good idea to restart IIS.

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

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

 

[cmh]

-----Original Message-----
In IIS MMC, right click on the web, then properties, home

directory tab, then at the bottom of the

dialog, application, click delete/remove, then click

create. Then it is a good idea to restart IIS.

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

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




.

Under the "HOme Directory" tab I do have "default
application" and "scripts only" selected.

 

[Thomas A. Rowe]

On the button on the left, click remove/delete, etc. and then click Configure.

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

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