Database is undefined.

lazerbrains555 · lazerbrains555

I am having a problem on a Coldfusion site. I am getting multiple errors from
multiple pages and most say this:

Variable DATABASE_NAME is undefined.
The error occurred on line 1.
page: /features/howto.cfm

However the database is defined in Coldfusion and also works sometimes.
Sometimes the page loads fine and sometimes it errors out with that error. I
don't know what is going on, but it is happening on more than one page. Does
any one know what could be causing something like this? Is it the server? I
am at a loss and don't know where to begin looking for the problem.

Please help.

Lou

jdeline · jdeline

Would you post the first few lines of code from /features/howto.cfm? What database are you using? Is it possible that someone on the server has the database "open?"

lazerbrains555 · lazerbrains555

No, no one on the server has the database open. Buut the first few lines of
code aren't anything special on that page. features/howto.cfm:

<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=ISO-8859-1">
<title>TITLE of MY SITE</title>

<link rel='stylesheet' type='text/css' href='../ac/styles/ac_style.css'>
<script language="JavaScript" src="../ac/scripts/ac_open.js"></script>
</head>

But the error says it occured on line 1. But line 1 is just the <HTML> tag.

On the tours/transam.cfm it is different:

<cfquery datasource=ATL name="TourLookup">
SELECT *
FROM ztours2005
WHERE tShortName = 'TransAm'
ORDER BY tCategory, tName
</cfquery>

<html>

<head>
<meta http-equiv="content-type" content="text/html;charset=ISO-8859-1">
<title>TITLE of MY SITE</title>

<link rel='stylesheet' type='text/css' href='../ac/styles/ac_style.css'>
<script language="JavaScript" src="../ac/scripts/ac_open.js"></script>
</head>

The error says:

Variable ATL is undefined.
The error occurred on line 1.
page: /features/howto.cfm

on BOTH of these pages. Exact same error message totally different code. Any
ideas. It sounds like it is something wrong with the server, but Id on't know.
Any Ideas?

Lou

jdeline · jdeline

Try uploading your pages again. It sounds like they may be corrupted on the server.

cfmlgirl · cfmlgirl

if ATL is a variable, should it be in # signs? When you write your query:
<cfquery datasource=#ATL# name="TourLookup">. Where did you defined that
variable, in application.cfm? Double check for spelling errors, make sure ODBC
is working...

jdeline · jdeline

The datasource should either be "ALT" or "#ALT#" - note double-quotes.

lazerbrains555 · lazerbrains555

I tried "ATL" and "#ATL#" and got errors everytime when I did that. I uploaded
a new file up to the server, still the same problem. Someone said it might be
the ODBC? Is that a possibility? What could be wrong with it?
Lou

lazerbrains555 · lazerbrains555

Oh, and yes I did define it in the main sites Application.cfm file.

Thanks,
Lou

cfmlgirl · cfmlgirl

what could be wron with ODBC? - it may not working, doesn't take much to check
it...

Like i said before, it is your variable, then it mucst be in #ALT#. can you
post the line of code where you are defining this variable? thanks

lazerbrains555 · lazerbrains555

The line of code I have that works intermittently is :

<cfquery datasource=ATL name="TourLookup">
SELECT *
FROM zTours2005
WHERE tShortName = 'TransAm'
ORDER BY tCategory, tName
</cfquery>

When I do it like this:
<cfquery datasource="#ATL#" name="TourLookup">
SELECT *
FROM zTours2005
WHERE tShortName = 'TransAm'
ORDER BY tCategory, tName
</cfquery>

It doesn't work at all. Plus I just upgraded the site from Coldfusion 4.5 to
MX 7 and this code used to work and now it works about half the time. I am not
sure what is wrong, but if it is my code please let me know. This query also
sits about the HTML tags in the page. Does that matter?

cfmlgirl · cfmlgirl

well, if this is the error you are getting:

Variable ATL is undefined.
The error occurred on line 1.
page: /features/howto.cfm

then it's something wrong with they way you set that variable. It should be
<CFSET ATL = 'NameOfYourDatasource'>

lazerbrains555 · lazerbrains555

ATL is the name of our datasource. Should I do:

<cfset ATL='ATL'>
?

cfmlgirl · cfmlgirl

so, in your <cfquery datasource=ATL name="TourLookup"> you are using a real
datasource name? ATL is not a variable? Or you do have defined variable ATL?
then maybe this tip will haelp:

[url]http://forta.com/cf/tips/index.cfm?age=1713[/url]

mx-7 · mx-7

No. You don not need <cfset ATL='ATL'> if it has worked properly in the past.

Intermittant faults like you describe relating to ODBC connection and DSN
failures are likely to be the result of poor server management.

Think about relocating your site onto another server - it may save you a lot
of headaches in the long run. Am I right in saying you have not received
definitive support from your hosting company either?

lazerbrains555 · lazerbrains555

OK, I took our advice and moved to a new server. But the only problem is that
it is still happening exactly the same way. Although I am much happier with
the new company and they have more options and better management controls, so
it wasn't a total loss. But I am still having the intermittent failures of
some of my pages with the same error:

Variable ATL is undefined.
The error occurred on line 1.
page: /tours/transam.cfm
date/time: {ts '2005-07-28 13:28:29'}

Here is the code in line 1 that is triggering it:

<cfquery datasource="#Datasource2#" name="TourLookup">
SELECT *
FROM ztours2005
WHERE tShortName = 'TransAm'
ORDER BY tCategory, tName
</cfquery>

But it works about half of the time. Can anyone see anything wrong with this?

Database is undefined.

Thread Tools

Display

Database is undefined.

Similar Questions and Discussions

Import Data from flat-database to relational-database

NEWBIE HELP Import Data from flat-database to relational-database

Passing database info to page allow user input then pass into another database

What is an undefined offset? An undefined index?

Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database;

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Re: Database is undefined.

Posting Permissions