Logon ID & Password for Text Files

Question

Logon ID & Password for Text Files

RONALD BEAUMAN 81

What is the method for specifying a logon ID and a password for a text file using the Microsoft Text Driver?

Tianyu Sun-MSFT 34,306 Reputation points Microsoft External Staff

2023-08-21T06:37:03.22+00:00

Hi @RONALD BEAUMAN ,

Welcome to Microsoft Q&A forum.

What kind of programming language are you using? C#? And what type of project are you using? Are you looking for a C# method?
RONALD BEAUMAN 81 Reputation points

2023-08-21T19:11:51.67+00:00

I am using C# in Visual Studio 2022. I am developing reports using Crystal Reports for Visual Studio. I am using the MS Text driver. I would like to use .CSV files a data source. I can design the reports with no problem. However, when I execute the report I get a logon failure notice. I need to know how to handle the user ID and password requirements for .CSV files. I posted this question on the SAP Crystal Reports forum with no response.

1 answer

Your answer

Tianyu Sun-MSFT 34,306 Reputation points Microsoft External Staff

2023-08-21T06:37:03.22+00:00

Hi @RONALD BEAUMAN ,

Welcome to Microsoft Q&A forum.

What kind of programming language are you using? C#? And what type of project are you using? Are you looking for a C# method?
RONALD BEAUMAN 81 Reputation points

2023-08-21T19:11:51.67+00:00

I am using C# in Visual Studio 2022. I am developing reports using Crystal Reports for Visual Studio. I am using the MS Text driver. I would like to use .CSV files a data source. I can design the reports with no problem. However, when I execute the report I get a logon failure notice. I need to know how to handle the user ID and password requirements for .CSV files. I posted this question on the SAP Crystal Reports forum with no response.

Answer 1

Hi @RONALD BEAUMAN if you're experiencing logon failures with the Microsoft Text Driver, please follow these steps: 1. Configure the Connection:

a. In the Crystal Reports designer, go to the Database menu and select "Database Expert."

b. In the "Database Expert" window, select "Create New Connection."

c. Choose "Access/Excel (DAO)" as your data source.

d. Click "Build" to configure the connection.

Specify the CSV File:

a. In the "Connection Info" dialog, choose "Microsoft Text Driver (*.txt, *.csv)" as the ODBC driver.

b. Enter the path to your CSV file in the "Database Name" field.

c. If your CSV file requires a User ID and Password, enter them in the respective fields. If not, leave these fields blank.

d. Click "Finish" to complete the connection configuration.

Verify the Data Source:

a. Back in the "Database Expert" window, you should see your CSV file listed as a table.

b. Drag and drop the fields from the CSV file into your report as needed.

Save and Run:

a. Save your Crystal Report.

b. Try running the report. It should use the configured connection details, including the User ID and Password if required.

If you're still encountering logon failures, ensure that the credentials and file paths are correct, and you have the necessary permissions to access the CSV file.

Share via

Logon ID & Password for Text Files

1 answer

Your answer