In that case, you don't want a real DSN to it but just a dynamic connection.
Besides, someone else asked about the HOW, not just WHY (sorry if I'm
encouraging the repurposement of your thread).
Sam
-----------------------------------------------
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
-----------------------------------------------
> -----Original Message-----
> From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 24, 2003 12:05 PM
> 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]
