Oracle datasource RS report

Question

Oracle datasource RS report

Jon-315724

Grasshopper

Points: 18
More actions
March 31, 2006 at 11:20 am

#189941

I've used RS since it was originally released in Beta. I don't consider myself an export but I've worked with it so much to create some advanced reports. We moved a specific database to oracle now...I want to create an RS report using the Oracle OLE db provider. But when I test the connection string I get:

---------------------------
Microsoft Data Link Error
---------------------------
Test connection failed because of an error in initializing provider. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
---------------------------
OK
---------------------------
Whats the dilly? ive never dealt with oracle before so I dont know what this means.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

What values did you use in your connection?

After selecting the Oracle Ole DB driver, you should be presented with a second tab on the dialog asking for a servername, username and password. I've found here that the 'servername' is not the name of the machine that the oracle is on, it's the oracle service name that was set up when the oracle instance was installed. So if my machine is called steves_laptop but I used orcl as my oracle instance name (which is the default btw), the name entered in the box should be orcl not steves_laptop. Obviously you need to have a valid uid/pwd as well.

Cheers,

Steve.

Syed Asim Rizvi Ten Centuries Points: 1162 More actions · Answer 2

I have same situation.

Steve, you are right we have to use DB Instance name and I used that and therefore successfully created DataSource and test it.

But when I tried this DataSource to create DataSet, I get this error:

A connection cannot be made to the database.

Set and test the connection string.

Unable to find an entry point named OCIEnvCreate in DLL oci.dll.

What I end up doing is using "OLEDB Provider for ODBC" instead of "OLEDB Provider for Oracle".

But I have to have OLEDB for Oracle and because of this error I'm nowhere. I'm using SSRS 2000.

Any help will be appreciated.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

I haven't seen this before but it almost sounds like a version imcompatability issue - if it can't find the entry point (ie the method/function) in the dll it's trying to use to communicate then you definitely have issues.

Sorry I can't help more - all I can suggest is to see if you can determine i) what version of Oracle you're running andd then ii) what version(s) this driver supports.

Steve.