General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
ODBC and Crystal Reports
Hello Guys
What I am trying to do is print out a
text file using Crystal Reports.
First I went into the ODBC Data Source Administrator
selected the System DSN tab and clicked on the Add
button.
I was then presented with a list of ODBC drivers to
choose from, I selected 'Microsoft Text Driver".
I then gave my Data source a name and selected the
directory where the text file is that I want to print.
I then clicked on the Options button and selected *.txt
as my extension.
I then clicked on Define Format and told it to guess
what the columns are and it seamed to figure that one
out correctly.
I then went inside of crystal reports to create a new
report and selected the SQL/ODBC button, it automatically
selected the SQL database and table for me.
I then clicked on the Add button to add that data file
and got the following error message:
ODBC Error [Microsoft][ODBC Text Driver]Invalid string or buffer length.
The version of the Text File Driver is:
3.50.3602.00
And my text file looks as follows:
"Row01Field01","Row01Field02","Row01Field03","Row01Field04","Row01Field05"
"Row02Field01","Row02Field02","Row02Field03","Row02Field04","Row02Field05"
"Row03Field01","Row03Field02","Row03Field03","Row03Field04","Row03Field05"
"Row04Field01","Row04Field02","Row04Field03","Row04Field04","Row04Field05"
"Row05Field01","Row05Field02","Row05Field03","Row05Field04","Row05Field05"
"Row06Field01","Row06Field02","Row06Field03","Row06Field04","Row06Field05"
"Row07Field01","Row07Field02","Row07Field03","Row07Field04","Row07Field05"
"Row08Field01","Row08Field02","Row08Field03","Row08Field04","Row08Field05"
"Row09Field01","Row09Field02","Row09Field03","Row09Field04","Row09Field05"
"Row10Field01","Row10Field02","Row10Field03","Row10Field04","Row10Field05"
Why am I getting the ODBC error, do I have an old version of the text file
driver, or is my data file incorrect????
Thank You
Gary
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only