Newbie Access DB not accessible on production server

[bamboostar]

As an absolute newbie, I'd REALLY appreciate any solutions to this as I need to
role this site out today for the client.

I am probably missing some fundamental step in linking the db to the app on
the production server. This works fine on my dev server. Please help!
Thanks!!

Here's the beginning of the script I'm using :
<cfparam name="URL.logout" default="0">
<cfparam name="invalid_login" default="0">

<cfset dsource = "ivydanny">


<cfif structKeyExists(form,"username")>

<cfquery name="check_user" datasource="#dsource#">
SELECT UserLogin, Password, Admin
FROM Contacts
WHERE UserLogin = '#FORM.username#' and Password =
'#FORM.password#'
</cfquery>

[Neculai Macarie]

> As an absolute newbie, I'd REALLY appreciate any solutions to this as I
need to

> role this site out today for the client.
>
> I am probably missing some fundamental step in linking the db to the app

on

> the production server. This works fine on my dev server. Please help!
> Thanks!!
>
> Here's the beginning of the script I'm using :
> <cfparam name="URL.logout" default="0">
> <cfparam name="invalid_login" default="0">
>
> <cfset dsource = "ivydanny">
>
>
> <cfif structKeyExists(form,"username")>
>
> <cfquery name="check_user" datasource="#dsource#">
> SELECT UserLogin, Password, Admin
> FROM Contacts
> WHERE UserLogin = '#FORM.username#' and Password =
> '#FORM.password#'
> </cfquery>

You need to have a datasource created on the production server that point to
the Access file. You can use the drivers from CF admin or setup the
datasource from the ODBC admin and then link it up with ODBC Socket in CF
admin.

--
<mack />

[bamboostar]

Ok thanks!