[thelist] ColdFusion: ODBC over mapped drives

[Morgan Kelsey]

Minh,


> Dear evolt,
> We're editing an ODBC datasource where the database file is located on a
> mapped drive. The CF Administrator does not show the mapped drive, so we
are
> unable to select that file. We were able to set the ODBC DSN connection to
> the .MDB file through the Windows 2000 ODBC control panel, but when we
> access the CF page, we get this error:
>
> Error Diagnostic Information
> ODBC Error Code = S1009 (Invalid argument value)
>
<snip />

> We did a search on the archives and renamed the service account to a
domain
> account that is a local administrator on both the cold fusion server and
the
> server where the .MDB file is located.  That should resolve the concerns
> about the cold fusion service account running under localMachine.
>
</snip>

i had similiar issues dealing with a foxpro database that resides on a
separate machine.
i worked around it by making a local DB, containing remote views of the DB
on the other machine.
i then changed the ODBC settings to point to the local DB, and found i could
access it in CF.


hth,

nagrom