Professional Web Applications Themes

How best to connect MS Access and Solaris CF 6.1? - Coldfusion Database Access

I've got a request to connect my Solaris ColdFusionMX 6.1 server to an MS Access database. But apparently MS Access just talks ODBC and I see no ODBC drivers in the Solaris server. Do I need to buy third party drivers? Should I try the JDBC/ODBC bridge?...

  1. #1

    Default How best to connect MS Access and Solaris CF 6.1?

    I've got a request to connect my Solaris ColdFusionMX 6.1 server to an MS
    Access database. But apparently MS Access just talks ODBC and I see no ODBC
    drivers in the Solaris server. Do I need to buy third party drivers? Should I
    try the JDBC/ODBC bridge?



    jperegrino Guest

  2. #2

    Default Re: How best to connect MS Access and Solaris CF 6.1?

    I believe you can just use the access w/ Unicode pure Java driver and
    read/write an access file.

    --
    Tom Jordahl
    Macromedia Server Development


    Tom Jordahl Guest

  3. #3

    Default Re: How best to connect MS Access and Solaris CF 6.1?

    I don't think you can do this. Access is a Windows file based DB that you have
    to connect to via the MS Jet engine.
    Since neither one of these is compatible with Unix, I don't know of a way to
    make it work. Access doesn't listen
    on an IP port like the "major" databases, as a means of connecting. There may
    be some third party solutions,
    but I'm not aware of them, or their reliability.


    OldCFer Guest

Similar Threads

  1. Internet Access through PC installed Solaris 8
    By zamaron in forum Linux / Unix Administration
    Replies: 2
    Last Post: September 1st, 11:22 AM
  2. How to use “RDS.Connect” to connect to a MS Access database?
    By hannaman@msn.com in forum ASP Database
    Replies: 0
    Last Post: August 2nd, 11:09 PM
  3. DB2 Connect CPU and Memory requirements for Solaris
    By Srihari Mupparaju in forum IBM DB2
    Replies: 0
    Last Post: July 21st, 08:52 PM
  4. NFS - Access rights - solaris --linux
    By udo konstantin in forum Sun Solaris
    Replies: 3
    Last Post: June 30th, 11:09 AM
  5. Replies: 0
    Last Post: June 25th, 04:33 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139