Disk or network error- Access DB

Question

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

Anonymous · Accepted Answer

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

cfdoogan · Answer

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded