We are using some Access 2k Databases with tables linked to CSV files.
We are doing this because some of our data used in our coldfusion pages is automatically dumped from an AIX system via FTP to our coldfusion server. Unfortunately, our AIX box can only dump to CSV files.
So, we have created a DB with the aforementioned linked table. This has been running great for the last few months.
Yesterday, we started building a new application that also uses FTP'd files from this AIX box.
If I go into the CF admin tool, verify all connections and then go into App #1 we are able to access all data - including the linked CSV file - just fine. Go into App #2 - we can access all Access tables fine, but not the linked CSV file.
If we verify again and reverse the process, App #2 first, we can get into the CSV table just fine, but not in App #1.
Is there a setting in the coldfusion server application that will allow us to increase the number of open threads for linked tables like this?
I know some of you are already asking, why don't we just import the data into the access db and then upload. One of these data dumps is done on a daily basis, the other is done weekly - far too much uploading and downloading for our users preferences.
Suggestions are greatly appreciated!
We are doing this because some of our data used in our coldfusion pages is automatically dumped from an AIX system via FTP to our coldfusion server. Unfortunately, our AIX box can only dump to CSV files.
So, we have created a DB with the aforementioned linked table. This has been running great for the last few months.
Yesterday, we started building a new application that also uses FTP'd files from this AIX box.
If I go into the CF admin tool, verify all connections and then go into App #1 we are able to access all data - including the linked CSV file - just fine. Go into App #2 - we can access all Access tables fine, but not the linked CSV file.
If we verify again and reverse the process, App #2 first, we can get into the CSV table just fine, but not in App #1.
Is there a setting in the coldfusion server application that will allow us to increase the number of open threads for linked tables like this?
I know some of you are already asking, why don't we just import the data into the access db and then upload. One of these data dumps is done on a daily basis, the other is done weekly - far too much uploading and downloading for our users preferences.
Suggestions are greatly appreciated!