CF MX Access datasource UNC network link possible?

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

  1. #1

    Default CF MX Access datasource UNC network link possible?

    I've tried both mapping a drive on the server and using a UNC link, but my
    Access Unicode datasource won't work with files on another server. I have the
    domain "logon" account rights embedded in the CF application service, so that
    should be set.

    If I use a network drive I get this error:
    Connection verification failed for data source: 00aaatest
    com.inzoom.adojni.ComException: 'w:\data\404.mdb' is not a valid path. Make
    sure that the path name is spelled correctly and that you are connected to the
    server on which the file resides.
    The root cause was that: com.inzoom.adojni.ComException: 'w:\data\404.mdb' is
    not a valid path. Make sure that the path name is spelled correctly and that
    you are connected to the server on which the file resides. in Microsoft JET
    Database Engine code=0 Type=1

    If I use a UNC link I get this error:
    Connection verification failed for data source: aaatest
    com.inzoom.adojni.ComException: '\\\prism2\premierWWW\data\404.mdb' is not a
    valid path. Make sure that the path name is spelled correctly and that you are
    connected to the server on which the file resides.
    The root cause was that: com.inzoom.adojni.ComException:
    '\\\prism2\premierWWW\data\404.mdb' is not a valid path. Make sure that the
    path name is spelled correctly and that you are connected to the server on
    which the file resides. in Microsoft JET Database Engine code=0 Type=1

    Should I be embedding a username/pw in the ColdFusion username and ColdFusion
    password boxes under advanced settings? I tried domain credentials, but this
    didn't work either. :(

    thanks for any suggestions!

    Chuck



    ChuckWWW Guest

  2. Similar Questions and Discussions

    1. Connecting to MS Access Datasource
      not working for me, I have the same exact issue.
    2. Can't set up access datasource
      After some struggle, I managed to upgrade my development latop from MX 6.1 to 7.0. I set up SQL databases as datasources with no problems....
    3. Cannot Create MS Access Datasource
      I have seen this problem posted on google groups but really no definitive answer. Machine Specifications: Windows Server 2003 Macromedia...
    4. Cannot add new Access datasource
      hi, I?m using CF 6.1, when I try to add a new Microsoft Access datasource from the CF admin I get the following error: The ColdFusion MX ODBC...
    5. Accessing a datasource at a network location
      Julie, I believe you've run into a permissions problem. Your web application is most likely running under the local account IUSR_<machinename>....
  3. #2

    Default Re: CF MX Access datasource UNC network link possible?

    Don't know about the Map drive, looks ok to me (except missing
    prism2\premier\www, but perhaps that was included in the map to w:). At any
    rate we shouldn't be using map drives, right?

    For the UNC, the answer is the design bug (feature?) of the administrator
    adding an extra \ for you so you wind up with 3. Doesn't make any sense to me,
    but that's the way it is. Only use one up front slash for UNC's.

    JMGibson3 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