SSRS 2014 - ODBC coonection with Teradata

Avinash Pentyala 1

Dear Team,

need you inputs, how to create New Shared ODBC connection between Teradata and SSRS 2014.

SSRS 2014 is running in windows server and Teradata drivers was installed. able to ping the TD port but not able to create ODBC connection using username and pwd.

Please share any reference URL or Steps

Olaf Helper 45,286 Reputation points

2021-06-28T07:15:06.083+00:00

not able to create ODBC connection using username and pwd.

Not able means what in detail? Do you get an error message or what happens? You have to provide more details about the issue, otherwiese we can not assist.

1 answer

Joyzhao-MSFT 15,596 Reputation points

2021-06-28T08:25:30.707+00:00

Hi @Avinash Pentyala ,
I am not familiar with Teradata, I hope the following links are helpful to you.
To connect to an ODBC data source.
SQL Server 2012 Reporting Services and Teradata Database.
Best Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Avinash Pentyala 1 Reputation point

2021-06-28T08:52:21.4+00:00

Hi,

@Olaf Helper @Joyzhao-MSFT Thank you for you reply.

I was create a New shared data source connection for TERADATA using ODBC and I was calling this connection into multiple SSRS reports.

ODBC test connection is failed with below error

**The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details ?
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified**

Connection String : Dsn=Development;uid=TD_SSRS;persist security info=True

IDevelopment is DSN, I have tried with USER anD SYSTEM DSN

Note : odbc connection is working in Report Builder but team has use one shared connection for all reports.

Joyzhao-MSFT 15,596 Reputation points

2021-06-30T06:18:10.087+00:00

You could check the link string of the data source through the following link: Create data connection strings-Report Builder & SSRS
When you select data source type ODBC, you are selecting a Reporting Services data processing extension that extends the .NET Framework Data Provider for ODBC. This data processing extension is natively compiled for and runs on x86 and x64 platforms. Use this extension to connect to and retrieve data from any data source that has an ODBC provider. Although a data provider may support previewing a report on your report authoring client, not all ODBC data providers are designed to support reports published on a report server.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSRS 2014 - ODBC coonection with Teradata

1 answer

Your answer