Results 1 to 3 of 3

Thread: access + windows97+couldfusion??

  1. #1
    Join Date
    Jul 2003

    access + windows97+couldfusion??

    Hi all:
    the enviroment are windows97 + windows2000, they would like have an interface to let the search staffs name, telephone, email .... easy.
    what is the best way to do that?

    1) first I want to use coldfusion, is ok to connect Ms sql 2000 to coldfusion by OLEDB, how can I deal with access. if use ODBC instead what problem will have?
    2)somebody say they can only use access to let the job down(table as back end and form as fore end , is that posible)
    3) other batter way, like asp??
    Thank you
    Magic Flight Launch Box
    Last edited by sql; 03-06-2011 at 01:24 AM.

  2. #2
    Join Date
    Sep 2002

  3. #3
    Join Date
    Nov 2003

    cf process

    not sure what you're asking but hopefully this helps:

    1. create your access .mdb file
    2. go to cfadmin and create a Datasource, have it point to your access .mdb file. give it a datasource name (ie: mydatabase).
    3. In Application.cfm you can set a variable like #request.dsn# to "mydatabase"
    4. in your coldfusion code you simply use that datasource name in your cfquery like this:

    <cfquery name="getData" datasource="#request.dsn#">
    select * from table
    Last edited by ragingminds; 11-05-2003 at 01:10 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts