Database not defined, but it is...

[ann_nyc]

I have been hunting around and trying a number of KB
articles - I will list them later - but I cannot display
database results in my web page.

Here is the situation. I built the website in FP 2000. I
have a few .asp pages in the site meant to connect with a
database created in Access 2000 and stored in a folder in
the website.
I inserted the database results on a page within my web
and was able to successfully add and verify the database.
I have IIS 5.0 installed and configured on a Windows 2000
box with the FrontPage Extenstions for testing.
I have published to a subweb in the wwwroot and everything
looks to be in order. Everytime I call a page that calls
a DB I get the following:
Database Results Error
The database connection named 'database1' 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

The connection has not been removed, I have renamed and
then "recreated" the global.asa file as per a KB article,
the root folder does indeed have scripting permissions
enabled and the web IS an application root.

ASP seems to be functioning properly as I am able to
execute various scripts. I have tested this a number of
different ways and I have been successful each time. The
problems seem to start when I attempt to connect to a DB,
any Access DB I have created and I have created and tested
a number of them.

I have tried these KB articles for a solution, but none
has resolved the issue: 219170, 232612, 265323, 265174,
204152, among others.

The most telling one was 265174. The article says that if
the =Application() variable returns nothing (which it
did), one of the following conditions is true:
The Global.asa file is not being executed; this is
probably because of the folder not being configured as a
program.
The Connection String in the ASP code is not defined in
the Web settings.

It refers me to another article, but this does not resolve
the issue either.

Does anybody have any ideas?

Thanks, Ann

[Ray at]

It's very difficult to follow a long story of a problem as opposed to seeing
the actual error message that the server returns, the line on which the
error exists, and any other relevant pieces of code that have to do with is
happening (or supposed to be happening) on that line with the error.

--

Ray at home
Microsoft ASP MVP


"ann_nyc" <anonymous@discussions.microsoft.com> wrote in message
news:ecde01c3f0be$56412bf0$a601280a@phx.gbl...

> I have been hunting around and trying a number of KB
> articles - I will list them later - but I cannot display
> database results in my web page.
>
> Here is the situation. I built the website in FP 2000. I
> have a few .asp pages in the site meant to connect with a
> database created in Access 2000 and stored in a folder in
> the website.
> I inserted the database results on a page within my web
> and was able to successfully add and verify the database.
> I have IIS 5.0 installed and configured on a Windows 2000
> box with the FrontPage Extenstions for testing.
> I have published to a subweb in the wwwroot and everything
> looks to be in order. Everytime I call a page that calls
> a DB I get the following:
> Database Results Error
> The database connection named 'database1' 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
>
> The connection has not been removed, I have renamed and
> then "recreated" the global.asa file as per a KB article,
> the root folder does indeed have scripting permissions
> enabled and the web IS an application root.
>
> ASP seems to be functioning properly as I am able to
> execute various scripts. I have tested this a number of
> different ways and I have been successful each time. The
> problems seem to start when I attempt to connect to a DB,
> any Access DB I have created and I have created and tested
> a number of them.
>
> I have tried these KB articles for a solution, but none
> has resolved the issue: 219170, 232612, 265323, 265174,
> 204152, among others.
>
> The most telling one was 265174. The article says that if
> the =Application() variable returns nothing (which it
> did), one of the following conditions is true:
> The Global.asa file is not being executed; this is
> probably because of the folder not being configured as a
> program.
> The Connection String in the ASP code is not defined in
> the Web settings.
>
> It refers me to another article, but this does not resolve
> the issue either.
>
> Does anybody have any ideas?
>
> Thanks, Ann
>

[Bullschmidt]

<<
I have been hunting around and trying a number of KB
articles - I will list them later - but I cannot display
database results in my web page.

Here is the situation. I built the website in FP 2000. I
have a few .asp pages in the site meant to connect with a
database created in Access 2000 and stored in a folder in
the website.
I inserted the database results on a page within my web
and was able to successfully add and verify the database.
I have IIS 5.0 installed and configured on a Windows 2000
box with the FrontPage Extenstions for testing.
I have published to a subweb in the wwwroot and everything
looks to be in order. Everytime I call a page that calls
a DB I get the following:
Database Results Error
The database connection named 'database1' 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

The connection has not been removed, I have renamed and
then "recreated" the global.asa file as per a KB article,
the root folder does indeed have scripting permissions
enabled and the web IS an application root.

ASP seems to be functioning properly as I am able to
execute various scripts. I have tested this a number of
different ways and I have been successful each time. The
problems seem to start when I attempt to connect to a DB,
any Access DB I have created and I have created and tested
a number of them.

I have tried these KB articles for a solution, but none
has resolved the issue: 219170, 232612, 265323, 265174,
204152, among others.

The most telling one was 265174. The article says that if
the =Application() variable returns nothing (which it
did), one of the following conditions is true:
The Global.asa file is not being executed; this is
probably because of the folder not being configured as a
program.
The Connection String in the ASP code is not defined in
the Web settings.

It refers me to another article, but this does not resolve
the issue either.

Does anybody have any ideas?

Thanks, Ann

>>

Perhaps create a DSN called database1 as it sounds like that's what your
connection string consists of.

Also the [url]www.asp101.com[/url] Samples section has some good database examples.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[ann_nyc]

Thank you for the response. I had created a DSN, so alas,
that is not my issue. Thank you for the link to the site.

Ann

>-----Original Message-----
><<
>I have been hunting around and trying a number of KB
>articles - I will list them later - but I cannot display
>database results in my web page.
>
>Here is the situation. I built the website in FP 2000. I
>have a few .asp pages in the site meant to connect with a
>database created in Access 2000 and stored in a folder in
>the website.
>I inserted the database results on a page within my web
>and was able to successfully add and verify the database.
>I have IIS 5.0 installed and configured on a Windows 2000
>box with the FrontPage Extenstions for testing.
>I have published to a subweb in the wwwroot and

everything

>looks to be in order. Everytime I call a page that calls
>a DB I get the following:
>Database Results Error
>The database connection named 'database1' 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
>
>The connection has not been removed, I have renamed and
>then "recreated" the global.asa file as per a KB article,
>the root folder does indeed have scripting permissions
>enabled and the web IS an application root.
>
>ASP seems to be functioning properly as I am able to
>execute various scripts. I have tested this a number of
>different ways and I have been successful each time. The
>problems seem to start when I attempt to connect to a DB,
>any Access DB I have created and I have created and

tested

>a number of them.
>
>I have tried these KB articles for a solution, but none
>has resolved the issue: 219170, 232612, 265323, 265174,
>204152, among others.
>
>The most telling one was 265174. The article says that

if

>the =Application() variable returns nothing (which it
>did), one of the following conditions is true:
>The Global.asa file is not being executed; this is
>probably because of the folder not being configured as a
>program.
>The Connection String in the ASP code is not defined in
>the Web settings.
>
>It refers me to another article, but this does not

resolve

>the issue either.
>
>Does anybody have any ideas?
>
>Thanks, Ann

>>>

>
>Perhaps create a DSN called database1 as it sounds like

that's what your

>connection string consists of.
>
>Also the [url]www.asp101.com[/url] Samples section has some good

database examples.

>
>Best regards,
>J. Paul Schmidt, Freelance ASP Web Developer
>[url]http://www.Bullschmidt.com[/url]
>ASP Design Tips, ASP Web Database Demo, Free ASP Bar

Chart Tool...

>
>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url]

***

>Don't just participate in USENET...get rewarded for it!
>.
>