Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSRS2008 connecting to Oracle

2 views
Skip to first unread message

Abba

unread,
Jul 6, 2010, 11:35:51 AM7/6/10
to

Hello,

[SQL2008] & [Oracle 10g]

Iam trying to connect to an Oracle database from SQL2008 Reporting Services
but Iam facing an error. This is what I have done:

- Installed Oracle Client 10g software in the same machine as SSRS2008
- Configured and successfully tested Oracle service name. This is the
snippet from tnsnames.ora:

ORACDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACDB)(PORT = 9644))
)
(CONNECT_DATA =
(SID = WINSYDB)
)
)

- I tested the Oracle service name with username: abba and it worked fine
- I was able to successfully tnsping ORACDB
- Now, I create a SQL2008 Reporting Services project
- Added a test rdl report
- Opened that rdl in Visual Studio editor
- New --> Datasource
- Select 'type' as Oracle
- Click 'edit'
- I give oracdb for 'server name'
- Then supply the same username/password
- When I click 'Test Connection', I get the error 'ORA-12154: TNS: Could not
resolve the connect identifier specified'


Any pointers would be very helpful.

tia,
AbbA


0 new messages