Yeap, this way works for Excel files too.
But as you noticed, you will need ColdFusion ODBC Agent installed on
server. You should install it so CF can access this ODBC socket datasource.
Or, as Mark Smyth suggest, you might wanna look at a JDBC Driver for Excel.
--
Fabio Terracini
Duncan wr
hough
painful do work well with Excel via ODBC
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: 06 May 2005 08:47
To: CF-Talk
Subject: Re: Excel sheet datasource in CFMX7
It won't work by going in to CFAdmin, hitting Datasources, setting the New
Datas
It won't work by going in to CFAdmin, hitting Datasources, setting the New
Datasource Type popup to ODBC and configuring it with the DSN of your
OS-based ODBC DSN?
I guess I hadn't considered that the ODBC connector from within CFAdmin was
dependent on the ODBC agent... if you've tried it and i
Ok I get where you are coming from and I would think that if the CF
ODBC agent was installed and running it would probably work.
Unfortunately this server doesnt have the CF odbc agent. Any other
ways around this without installing the odbc agent?
On 5/6/05, Jared Rypka-Hauer - CMG, LLC <[EMAI
After setting up the OS-based ODBC datasource, you WILL need to go into CF
Admin and create a CFMX DSN that points to your ODBC DSN by name, and supply
the appropriate (if necessary) credentials.
That is, you create an ODBC DSN via the Windows Control Panel and after that
a CF Administrator DSN
.
Haven't tried this for excel files but have had success with access
databases via this method.
- Original Message -
From: "Duncan" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Friday, May 06, 2005 12:50 PM
Subject: Excel sheet datasource in CFMX7
> I had a d
I had a datasource set up in cf 4.5 for an ms excel sheet and it was
very straight forward.. In CF 7 it doesnt have excel sheet defined
readily, and the other option requires JDBC class paths and things.
Can someone give me the settings etc I need for the class path - or is
there a better way to d
7 matches
Mail list logo