Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC and Crystal Reports
Message
From
25/06/2001 13:08:32
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
ODBC and Crystal Reports
Miscellaneous
Thread ID:
00523056
Message ID:
00523056
Views:
36
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
Map
View

Click here to load this message in the networking platform