This is a little bit different issue, however. You don't actually read the schema.ini directly. When a file is accessed as a dsn, a schema.ini in the same directory "automagically" defines the text field names, types, positions, and lengths. There is some information about how this works here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp I believe Marlon hit it on the head. I didn't realize that is no longer available. Thanks, ~Dave On 7/18/05, Jake McKee <[EMAIL PROTECTED]> wrote: > Yep! I lifted the technique from Ray Camden. I really dig it, but am > probably going to work on moving some or all of the values to XML. The > .ini scheme works wonderfully if you have a) only English or b) only > yes/no type values...since the .ini files can't deal with unicode, for > instance. > > Jake > > Joe Kelly wrote: > > >Dave, > >Look at GetProfileString() and SetProfileString() > >Jake McKee uses .ini files on his BlogFusion. Just found that out on > >his Dev Blog. > >Thanks, > >Joe Kelly > > > >On 7/18/05, Dave Shuck <[EMAIL PROTECTED]> wrote: > > > > > >>Many moons ago, former coworker and DFWCFUGger Seth Bienek showed me a > >>way to access a fixed-length text file as a DSN using a schema.ini > >>file, but apparently that information has long since left my brain. > >>Does anyone have an example of this being done, or possibly remember > >>what parameters to give <cfquery> to make the connection? I think I > >>have the configuration of the schema.ini right, but am coming up short > >>on the connection itself. > >> > >>Thanks, > >> > >>~Dave > >>---------------------------------------------------------- > >>To post, send email to [email protected] > >>To unsubscribe: > >> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > >>To subscribe: > >> http://www.dfwcfug.org/form_MemberRegistration.cfm > >> > >> > >> > >> > >> > > > > > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
