Ask a Question related to Coldfusion Database Access, Design and Development.
-
ChuckWWW #1
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
-
Connecting to MS Access Datasource
not working for me, I have the same exact issue. -
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.... -
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... -
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... -
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>.... -
JMGibson3 #2
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



Reply With Quote

