Professional Web Applications Themes

Disk or network error- Access DB - Coldfusion Database Access

Hi, This app was working okay until friday. The server guys applied some Windows Server 2000 patches over the weekend and then I am getting this error while trying to run a query, [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Disk or network error. 9 : <CFQUERY NAME="Entity" DATASOURCE="Contracts"> 10 : SELECT EntityId, 11 : [ENTITY NAME] as Entity, -------------------------------------------------------------------------------- SQL SELECT EntityId, [ENTITY NAME] as Entity, DBA FROM [ENTITY ADDRESS INFO] ORDER BY [ENTITY NAME] DATASOURCE Contracts VENDORERRORCODE -1022 SQLSTATE HY000 Can anybody help? Thanks VJ...

  1. #1

    Default Disk or network error- Access DB

    Hi,
    This app was working okay until friday. The server guys applied some Windows
    Server 2000 patches over the weekend and then I am getting this error while
    trying to run a query,

    [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
    Access Driver] Disk or network error.
    9 : <CFQUERY NAME="Entity" DATASOURCE="Contracts">
    10 : SELECT EntityId,
    11 : [ENTITY NAME] as Entity,

    --------------------------------------------------------------------------------

    SQL SELECT EntityId, [ENTITY NAME] as Entity, DBA FROM [ENTITY ADDRESS
    INFO] ORDER BY [ENTITY NAME]
    DATASOURCE Contracts
    VENDORERRORCODE -1022
    SQLSTATE HY000


    Can anybody help?

    Thanks
    VJ

    VJIN Guest

  2. #2

    Default Re: Disk or network error- Access DB

    VJ - it sounds as though either the network mapping/share to the MDB file has gone or the permissions have been mucked up.

    Jon
    Jon Guest

  3. #3

    Default Re: Disk or network error- Access DB

    Is this a network or local drive. If network this may help:

    Open Control Panel -> Settings -> Administrative Settings -> Services


    Right click on Coldfusion Application Server and select Properties.


    Second tab in "Log On", choose the second radio button and change the user to
    one with access rights.


    Make sure that the user you selected as the one with the access rights exists
    on the mapped server

    cfdoogan Guest

  4. #4

    Default Re: Disk or network error- Access DB

    Thanks Jon and doogan. The problem occured due to some network permissions
    being messed up. The Access DB is itself on another server (A). CF server
    connects to this m/c and able to verify the datasource. The Entity table that I
    was tring to query is a linked table which is located on another m/c (B). CF
    server was not able to see this m/c. Everything works okay if I copied the
    table on to server A. The network guys are working on this and will hopefully
    fix it. Thanks very much for your inputs.

    VJ

    VJIN Guest

Similar Threads

  1. any way to write to the disk on local network?
    By Vahan Babakhanian in forum ASP Components
    Replies: 2
    Last Post: April 6th, 09:30 PM
  2. Replies: 0
    Last Post: February 17th, 01:21 AM
  3. Disk or Network Error
    By J Cramer in forum ASP Database
    Replies: 0
    Last Post: December 22nd, 05:41 PM
  4. Replies: 0
    Last Post: July 10th, 12:55 PM
  5. Replies: 0
    Last Post: July 4th, 08:06 AM

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