Create DSN In system DSN .filename is static

Posted on 2009-02-19
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

    Have you tried the ENGLISH Driver....?
    LVL 100

    Accepted Solution

    Is this in the Crystal interface or are you building the ODBC connection in Windows?

    LVL 4

    Assisted Solution

    Use Microsoft Text Driver instead of
    Driver da Microsoft para arquivos texto.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    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…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now