I have a couple of questions re: my initial question...
Is the MERANT text driver included with CFMX or has "it" been removed also?
All of the text files we are accessing require this driver.
> There's a really straightforward solution that gives you full power of
dynamic connection strings in CFMX.
I looked into the threads on this discussion and it appears that this is
being addressed by using MSAccess as a proxy connection. My concern with
this is historically Access tends to be "leaky" with large files and many of
the files being accessed are large (up to 500MB). So we are trying to avoid
this method.
The text files are also have fixed length fields (no delimiter) which are
defined in the QETXT.ini file found in the directory.
Thanks for any help.
Rick
-----Original Message-----
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 9:05 PM
To: CF-Talk
Subject: RE: connectString workaround?
Richard,
Please search the archives. This question comes up a lot and in fact
examples were just posted within the last two days, along with a large
discussion. There's a really straightforward solution that gives you full
power of dynamic connection strings in CFMX.
Good luck,
Sam
-----------------------------------------------
Blog: http://www.rewindlife.com <http://www.rewindlife.com>
Charts: http://www.blinex.com/products/charting
<http://www.blinex.com/products/charting>
-----------------------------------------------
> -----Original Message-----
> From: Richard Castrios [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 5:23 PM
> To: CF-Talk
> Subject: RE: connectString workaround?
>
> Thanks!
>
>
> Could you give an example of how to approach this using
> dynamic data sources?
>
> Rick
>
> -----Original Message-----
> From: Ben Forta [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 3:41 PM
> To: CF-Talk
> Subject: RE: connectString workaround?
>
> If you have text files then you should still be able to use
> the ODBC text driver, specify the directory, and use the
> JDBC-ODBC connector to use it in CF. The "table" is the file
> name. I have not tried this with CFMX, but I think it should work.
>
> --- Ben
>
> -----Original Message-----
> From: Richard Castrios [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 25, 2003 3:25 PM
> To: CF-Talk
> Subject: connectString workaround?
>
> Hi,
>
> I am trying to find a workaround for the (deprecated from
> CFMX) connectString attribute in CFQUERY. Has anyone been
> able to get around this new limitation. We were previously
> using the MERANT text driver in ver.
> 5
> that allowed us to read a .txt file into a query while
> getting the schema information from the QETxt.ini file in the
> same directory. We need the dsn'less connection because we
> have hundreds of potential text files that can be accessed
> dynamically from the client. See code sample below.
>
> thanks
>
> Rick
>
> <cfquery
> name="QueryMyFile"
> dbtype="dynamic"
> connectstring="DRIVER={MERANT 3.70 ColdFusion OEM 32-BIT
> TextFile (*.*)}; SERVER=local);
> UID=user;PWD=;DBQ=#fName#.txt;DB=#fDir#;APP=;WSID="
> blockfactor="50"
> >
> SELECT '#trim(Col_desc_NameArray[iCol])#' as CountBy,
> count(distinct #trim(arrColNames[iCol])#) as CountD,
>
> count(#trim(arrColNames[iCol])#) as CountResult FROM #myfile#
> </cfquery>
>
> _____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
