Microsoft Text Driver

[MikeLF]

I am migrating a ColFusion 4.5 application that uses the Microsoft Text Driver
to access a csv file. Which a driver could I use in Cold Fusion MX 6.?, I
don?t see any driver for text files.

Thanks,

[paross1]

I would imagine that you would create an ODBC data source using the Microsoft
Text Driver via the ODBC Data Source Administrator, then use ODBC socket in the
ColdFusion administrator to add your data source by selecting your ODBC DSN
from the drop down list.

Phil

[mxstu]

I haven't tried it but I think you can use "ODBC Socket". You would first need
to create a regular system ODBC DSN. Then log into the CF Administrator, select
ODBC Socket and chose the ODBC DSN you just created.

Btw, you can also query CSV files using a regular Microsoft Access Datasource.

[bigbrain28]

The following assumes you are serving from Windows, and that you have access to
these administative tools:
First, on the server where CFMX lives open the ODBC Data Source Administrator
and add an ODBC Text Driver to the SYSTEM DSN list and point it at your text
file, or at least to the correct directory, and be sure your .txt extention is
on the list of extentions for that dsn.
Then when you add the Datasource in CFMX admin, choose ODBC Socket as driver
type, and on the next screen you will see your named DSN on the drop down list
for ODBC DSN. Path to the text file and you should have a successful linkage.

[paross1]

Don't you just love it when three people post essentially the exact same answer!

:D Phil

[mxstu]

"Great minds think alike" .... but some of them are a little slower with the reply button than others ;-)

[MikeLF]

I could create the datasource but now I get the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver]
Text file specification field separator matches decimal separator or text
delimiter.

My decimal separator is a comma. Obviously that will match the csv files?
separator. Any ideas?

[MikeLF]

I was reading numbers as characters to avoid the conflict but it doesn?t seem to work. I guess I?ll have to change the separator.

Thanks you all for your help on the odbc connection to text files.