Create DSN In system DSN .filename is static

Posted on 2009-02-19
Medium Priority
Last Modified: 2012-05-06
I want to change the data source location of the existing crystal report where the data source is text file.I have two data source file one in old report which now needs to point to new text file. i tried to create DSN connection following these steps:
"      Select Data Sources in the Control Panel Administrative Tools.
"      Select System DSN in the ODBC Data Source Administrator.
"      Click on Add.
"      Select Driver da Microsoft para arquivos texto (*.txt; *.csv)
"      Click Finish.
"      Enter Data Source Name as File Access Driver in the ODBC Text Setup.
"      Uncheck the Use Current Directory check box. Browse through Select Directory button and point to the folder of the Sample_File.txt file.
"      Click on Options. And then Click on Define format.
"      Select the file in the Tables section in the Define Text Format window.
"      Click on Guess in Columns section.
"      Click Ok to close all the windows.
- When i hit ok then it gives me error as "failed to save table attributes table attributes of null into  null."
Can anyone provide me the solution to it ASAP.

Question by:baralp
LVL 17

Assisted Solution

MIKE earned 150 total points
ID: 23686927
Have you tried the ENGLISH Driver....?
LVL 101

Accepted Solution

mlmcc earned 300 total points
ID: 23687209
Is this in the Crystal interface or are you building the ODBC connection in Windows?


Assisted Solution

spangdelta earned 300 total points
ID: 23694926
Use Microsoft Text Driver instead of
Driver da Microsoft para arquivos texto.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question