Page 1 of 1

ODBC Connection with SQL Version

Posted: Tue Dec 02, 2003 12:58 am
by Mike_Pelone
I am trying to use ODBC to connect to a very large ASCII flat file.____When I work my way through the ODBC Text Setup dialog window, and then select _define format_ _ I can see that the program successfully _guesses_ the record layout, field lengths and types. So far _ so good. However, when I click the O.K. button _ I get an error message that says __Failed to Save Attributes of (null) into (null)_._ Is this procedure actually prompting me to save a new file using another file name?____I have reformatted the orginal data file several times using tabs to separate columns and/or commas to separate the columns then tried fixed widths. Nothing seems to work.____Also - when I attempt to create a report all I get is one very long field with all of the individual fields combined_____Any suggestions? I have other large ASCII files that have successfully been connected using ODBC. I am using version 10.01.01 _ when I use the same data files with the Xbase ReportWriter progam (after the original flat files have been converted into DBF files using Excel) there are no problems.____Thanks for any insight on this problem.________Mike P.__Buffalo - NY__

=> ODBC Connection with SQL Version

Posted: Tue Dec 02, 2003 11:14 am
by kfleming
All that I know about the text driver is that when you define a structure for a file, the information gets written to the file SCHEMA.INI that gets placed in the same directory as the file. So something must be happening that prevents that file from being properly created. I tried to search the Microsoft site for an answer but found nothing. Maybe someone else has seen this and knows the answer.____Kathleen__R&R Support