Coldfusion Database File Location

Sorry forgot Are these Domain Member servers or are they just Workgroup servers?

To experts,
Sorry for the late reply. It has been hetic since I posted my question.

RickEpnet & ansudhindra:
--------------------------------------------
This folder as you see in the attached, I am currently logged in as domain administrator on the CF server and I can view/change/delete anything in the PO2000 folder that contains PO2000.MDB.
FYI, This CF server used to be part of old domain. Recently I disjoined it from old domain and joined it  to the new domain. The ACCESS database file "PO2000.MDB" is located on the new Domain Controller. The domain administrator has full access/control on the \\XXX\External\PO2000 folder.

agx_:, Here is the error message
----------------------------------------------
Connection verification failed for data source: PO2K
com.inzoom.adojni.ComException: Not a valid file name.
The root cause was that: com.inzoom.adojni.ComException: Not a valid file name. in Microsoft JET Database Engine code=0 Type=1

CF-Error-and-UNC-Path.doc

ansudhindra:
-------------------------------------------------
I just created driver letter W mapped to \\XXX\External.
I entered W:\PO2000\po2000.mdb into CF and received the following error. Please see attachment for screenshots.

Connection verification failed for data source: PO2K
com.inzoom.adojni.ComException: 'W:\PO2000\po2000.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:\PO2000\po2000.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

CF-Error-and-UNC-Path2.doc

ansudhindra:
-------------------------------
I tried \\192.168.1.9\External\PO2000\PO2000.MDB as seen in the attached, but I get the follwing error.

Connection verification failed for data source: PO2K
com.inzoom.adojni.ComException: Not a valid file name.
The root cause was that: com.inzoom.adojni.ComException: Not a valid file name. in Microsoft JET Database Engine code=0 Type=1


CF-Error-and-UNC-Path3.doc

ansudhindra: _agx_:
------------------------
Since your suggestion about going to services.msc and change LOG ON information, I think I know where it went wrong.

Like I mentioned, this CF / W2003 App Server used to belong to old domain. We installed a new Domain, so I joined it to the new domain. While setting up a new domain (W2011SBS), I had to created a differnet administrive account callid "PSIADMIN" instead of traditional admin account name "ADMINISTRATOR" in W2003 server.
That said, I think CF was still using old local admin account called "administrator" which does not exist on new domain controller.

As you see in the attached, I changed user name and password on all 4 CF related services and restart, I could not even load CF Administrative screen to go to CF Admin Menu. So, I switched it back to "Log on as Local System Account".

Tonight should I try to create a local account called "PSIADMIN" and assign the same password and leave CF related services Login on properties as "Log on as Local System Account" and try to see if CF accesses the folder that has MDB?



CF-Error-and-UNC-Path4.doc

_agx_:
--------------------
yes administrator was the main admin account on CF server running W2003 Server.

Regarding "check the interact with desktop box" I am afraid to make any changes to these existing CF services anymore. We are running mission critial web-based applications off this CF server and I can't afford to make changes that would impact the operation of these existing systems.

So What I am going to try is to create a new local account in compmgmt.msc of CF server and log back in using that new account (which is identical to domain admin account username/pwd).

Understood.  (Hopefully you have DEV or QA box you can test things on first?)

Thank you for your assistance. As you suspected, I tlhink it is a permission issue. As I indicated, this computer running W2003 Server used to be a part of one domain, but now on another domain (W2008 Server). When I log in to this computer, it uses a different administrative login name and I believe that is where the confusion comes from.
  All the local database files are running fine.
  Since this is a production server, I can't afford to mess with it, so what I decided to do is to setup  COLDFUSION server on another server running Windows 2003 with the same adminitrative account username and password as in Windows 2008 Server domain.

Thank you all.