ODBC Connection with SQL Version
Posted: Tue Dec 02, 2003 12:58 am
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__