which could then be manipulated by other people over a period of time. At
the time of writing there was no way to do it in MX that appeared to work.
So we have a bank of datasources setup in CF which is then monitored by
other code and matched up with ODBC datasources via CFRegistry
Much much easier (and secure) than installing MS Office on the server (which
has the added problem of being really locked down) and trying to use COM
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 17:05
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?
-----Original Message-----
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 8:34 AM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?
You can do dynamic ODBC connections in MX by creating a datasource to an
empty Access database and use that as a proxy, specifying the real
connection string in the FROM clause of your query.
<cfquery name="excelData" datasource="proxy">
SELECT Salesperson, SalesAmount
FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] </cfquery>
HTH,
Sam
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]