Middleware ---- ODBC --> data source Server Catalog of 200+ ODBC drivers (and ODBC middleware servers): [url]http://www.SQLSummit.com/ODBCVend.htm[/url] Catalog of 120+ JDBC drivers (and JDBC middleware servers): [url]http://www.SQLSummit.com/JDBCVend.htm[/url] Catalog of 30+ .NET data providers: [url]http://www.SQLSummit.com/DataProv.htm[/url] Catalog of OLE DB Providers: [url]http://www.SQLSummit.com/oledbVen.htm[/url] Catalog of DB2 Extenders: [url]http://www.SQLSummit.com/Extenven.htm[/url] Catalog of XQuery Engines/Processors: [url]http://www.SQLSummit.com/XQueryProv.htm[/url] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <1114882381.559604.207930@o13g2000cwo.googlegroups.com> [ref] => [htmlstate] => on_nl2br [postusername] => ken_north@compuserve.com [ip] => ken_north@compu [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 8 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> Middleware ---- ODBC --> data source Server Catalog of 200+ ODBC drivers (and ODBC middleware servers): [url]http://www.SQLSummit.com/ODBCVend.htm[/url] Catalog of 120+ JDBC drivers (and JDBC middleware servers): [url]http://www.SQLSummit.com/JDBCVend.htm[/url] Catalog of 30+ .NET data providers: [url]http://www.SQLSummit.com/DataProv.htm[/url] Catalog of OLE DB Providers: [url]http://www.SQLSummit.com/oledbVen.htm[/url] Catalog of DB2 Extenders: [url]http://www.SQLSummit.com/Extenven.htm[/url] Catalog of XQuery Engines/Processors: [url]http://www.SQLSummit.com/XQueryProv.htm[/url] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <1114882398.415659.209120@o13g2000cwo.googlegroups.com> [ref] => [htmlstate] => on_nl2br [postusername] => ken_north@compuserve.com [ip] => ken_north@compu [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 9 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> Access Driver for CFMX on Linux - Coldfusion Database Access

Access Driver for CFMX on Linux - Coldfusion Database Access

I am running CFMX 6.1 on RedHat Linux AS. I have an MS Access database on a Windows server I want to access. CFMX does not come with a built-in Access ODBC or JDBC driver. Is there any way to get this to work? I can not convert the Access DB to MySQL as it is still used in Access. Thanks....

  1. #1

    Default Access Driver for CFMX on Linux

    I am running CFMX 6.1 on RedHat Linux AS. I have an MS Access database on a
    Windows server I want to access. CFMX does not come with a built-in Access ODBC
    or JDBC driver. Is there any way to get this to work? I can not convert the
    Access DB to MySQL as it is still used in Access.

    Thanks.

    skooch Guest

  2. #2

    Default Re: Access Driver for CFMX on Linux

    You may want to do a search from the following link for MS Access Drivers and
    see if any of the results suit your needs:

    [url]http://developers.sun.com/product/jdbc/drivers[/url]

    I hope this helps,

    Stephanie Juma
    Macromedia, Inc.

    Stephanie Guest

  3. #3

    Default Re: Access Driver for CFMX on Linux

    The results this link turns up are either outdated or not compatible with
    Linux. I have an Access database which is currently modified on Windows using
    Access forms so I can't convert it. I need to get the data into MySQL on a
    regular basis and do not want to have to export and import the data. If
    necessary I could probably set up an intermediary Windows server running CF.
    Would this help?

    skooch Guest

  4. #4

    Default Re: Access Driver for CFMX on Linux

    If you install ColdFusion MX on Windows then you will have the option to run
    the ODBC Driver for Access since you will have the the ODBC Socket Services
    installed.

    I hope this helps,

    Stephanie Juma
    Macromedia, Inc.

    Stephanie Guest

  5. #5

    Default Re: Access Driver for CFMX on Linux

    I think the only way to connect to MS Access is via a windows box because it's
    a file based
    DB and doesn't listen on a port so the MS Jet engine still comes into play.
    What you could
    do is duplicate the Access tables in MySql, link them into the Access DB, then
    the Access
    forms will use the MySql tables just like Access tables. That's what I did
    but it was with
    MS SQL.

    OldCFer Guest

  6. #6

    Default Re: Access Driver for CFMX on Linux

    That is a very interesting idea and that just might work. Can Access forms do
    this to remote ODBC connections or does the MySQL DB need to be on the same
    machine? If it will work through ODBC you have made my week!

    skooch Guest

  7. #7

    Default Re: Access Driver for CFMX on Linux

    Nope, your MYSQL DB can be anywhere. Just make sure you have the latest MYSQL
    ODBC Drivers on your Access machine and set up the DSN via the Control panel
    ODBC Data Sources. Then in Access go to File/Get External Data/link tables.
    The
    type of file is ODBC Data sources. Then choose the datasource you set up for
    the
    MYSQL datasource. You should be able to see all of the MYSQL tables. Choose
    the tables you want. The Access forms can use them just like they were Access
    tables.
    If they are the same name and data types Access forms can't tell the
    difference.

    OldCFer Guest

  8. #8

    Default Re: Access Driver for CFMX on Linux

    OldCFer wrote:
    >> I think the only way to connect to MS Access is via a windows box
    because it's
    a file based DB and doesn't listen on a port so the MS Jet engine still
    comes into play.

    Depending on what API you want to use (JDBC or ODBC), there are several
    alternatives.

    Several companies make middleware servers that enable you to use a
    single driver (JDBC or ODBC) to connect to the middleware server. The
    middleware server uses ODBC, JDBC and/or native APIs to connect to the
    data source. For example (where client refers to a database client):

    Client -- JDBC --> Middleware ---- ODBC --> data source
    Server

    Catalog of 200+ ODBC drivers (and ODBC middleware servers):
    [url]http://www.SQLSummit.com/ODBCVend.htm[/url]

    Catalog of 120+ JDBC drivers (and JDBC middleware servers):
    [url]http://www.SQLSummit.com/JDBCVend.htm[/url]

    Catalog of 30+ .NET data providers:
    [url]http://www.SQLSummit.com/DataProv.htm[/url]

    Catalog of OLE DB Providers:
    [url]http://www.SQLSummit.com/oledbVen.htm[/url]

    Catalog of DB2 Extenders:
    [url]http://www.SQLSummit.com/Extenven.htm[/url]

    Catalog of XQuery Engines/Processors:
    [url]http://www.SQLSummit.com/XQueryProv.htm[/url]

    ken_north@compuserve.com Guest

  9. #9

    Default Re: Access Driver for CFMX on Linux

    OldCFer wrote:
    >> I think the only way to connect to MS Access is via a windows box
    because it's
    a file based DB and doesn't listen on a port so the MS Jet engine still
    comes into play.

    Depending on what API you want to use (JDBC or ODBC), there are several
    alternatives.

    Several companies make middleware servers that enable you to use a
    single driver (JDBC or ODBC) to connect to the middleware server. The
    middleware server uses ODBC, JDBC and/or native APIs to connect to the
    data source. For example (where client refers to a database client):

    Client -- JDBC --> Middleware ---- ODBC --> data source
    Server

    Catalog of 200+ ODBC drivers (and ODBC middleware servers):
    [url]http://www.SQLSummit.com/ODBCVend.htm[/url]

    Catalog of 120+ JDBC drivers (and JDBC middleware servers):
    [url]http://www.SQLSummit.com/JDBCVend.htm[/url]

    Catalog of 30+ .NET data providers:
    [url]http://www.SQLSummit.com/DataProv.htm[/url]

    Catalog of OLE DB Providers:
    [url]http://www.SQLSummit.com/oledbVen.htm[/url]

    Catalog of DB2 Extenders:
    [url]http://www.SQLSummit.com/Extenven.htm[/url]

    Catalog of XQuery Engines/Processors:
    [url]http://www.SQLSummit.com/XQueryProv.htm[/url]

    ken_north@compuserve.com Guest

Similar Threads

  1. MS Access on CFMX Linux
    By andrewdixon in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 23rd, 12:58 PM
  2. Installing DB2 JDBC Driver on CFMX 6.1 Standard
    By chuckjody in forum Coldfusion Server Administration
    Replies: 5
    Last Post: March 16th, 07:49 PM
  3. JDBC driver problem w/ CFMX 7
    By Steve Grosz in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 22nd, 05:06 PM
  4. Wireless card driver for Linux
    By Akshat Trivedi in forum Linux / Unix Administration
    Replies: 2
    Last Post: April 20th, 10:19 PM
  5. ATI Radeon 9800 Pro & Linux driver support?
    By ANTant@zimage.com in forum Linux Setup, Configuration & Administration
    Replies: 15
    Last Post: September 15th, 03:09 PM

Bookmarks

Posting Permissions

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