How best to connect MS Access and Solaris CF 6.1?

Ask a Question related to Coldfusion Database Access, Design and Development.

  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. Similar Questions and Discussions

    1. Internet Access through PC installed Solaris 8
      All, I would really be thankful, if any one provides me the details for configuring internet access through my home computer freshly installed...
    2. How to use “RDS.Connect” to connect to a MS Access database?
      The example I am working from uses the following code which does not work: RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial ...
    3. DB2 Connect CPU and Memory requirements for Solaris
      Does anyone know of a white paper or some kind of stats on how much memory and CPU (%) is needed to Run a DB2 Connect EE server with thousands of...
    4. NFS - Access rights - solaris --linux
      Hi all, in a given environment I had at least one sun sparc with solaris 9. I want to share via nfs a part of my second disk. This is slice 1....
    5. I am trying to make the swith but sun and their OS is not making it easy. (I cant even connect to the internet with solaris)
      william.quiter@sylvania.com (Hank) wrote in message news:<7e15f9e1.0306012204.2fc5dbfc@posting.google.com>... See ...
  3. #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

  4. #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

Posting Permissions

  • You may not post new threads
  • You may 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