Data Source Not Found

[SpunkyVulcan]

I'm drawing a blank on this...hope someone can help. I'm quite accustomed to
working on local CF & dB servers, but now have my personal site on a remotely
hosted site and am COMPLETELY bamboozled.

I'm getting the following error message: "Error Executing Database Query. Data
source not found."

Hosting company (big name, well known) has MS Access dB auto-config utility.
Database is loaded, DSN is set, admin tools see the datasource, everything
should be working as far as they're concerned.

=============

MS Access Database details
Username: foouser (required)
Password: foopass (required)
Data Source Name (DSN): fooaccess
Database Filename: foo.mdb

=============

Application.cfm
<cfset gDB = "fooaccess">

=============

AnyPage.cfm

<cfquery name="qGetFoo" datasource="#gDB#">
SELECT * FROM footable ORDERBY fooID
</cfquery>

-- OR --

<cfquery name="qGetFoo" datasource="#gDB#" username="foouser"
password="foopass">
SELECT * FROM fooTable ORDERBY fooID
</cfquery>

-- OR --

<cfquery name="qGetFoo" datasource="fooaccess" username="foouser"
password="foopass">
SELECT * FROM fooTable ORDERBY fooID
</cfquery>

-- OR --

<cfquery name="qGetFoo" datasource="fooaccess">
SELECT * FROM fooTable ORDERBY fooID
</cfquery>

=============

What am I doing wrong?!

Thanks!

[shmuckatelli]

What kind of server is it running on?
Have you verified the db is setup within CF, if you don't have direct access to the CF administrator page, then have their support people verify it for you.

[vkunirs]

Hi

Is the DSN is created in the ODBC or in the CF Administrator.
may be check that, whether the DSN is created in CF admin or not?
i think the DSN has to be created in the CF admin only.