I am trying to create a new Data Source Name in Coldfusion MX7.
The database file is located unfortunately located on another computer and whenever I enter the UNC "\\MyAppServer\Database\ABC.MDB", I get an error.
I also tried a mapped drive like X drive pointing to \\MyAppServer\Database, but the result was the same.
Of course when I copied the database from \\MyAppServer\Database to a Local folder where CF resides, then no problem creating DSN name.
I like to know if I must have the data file on the local computer where CF MX7 resides in order to create a DSN.