Oracle/ssrs Guys Evarina Unte Itu Ravalamma (Help Needed)

[cool_dude]

Hello guys,

 

Nenu SSRS Report creare cheyyali with backend as Oracle databse

 

I could connect and run queries in SQLDeveloper(Oracle)

 

But SSRS lo if I am giving the connection using Oracle Client . I am facing with this error

 

ORA-12154: TNS; Could not resolve the Connect identifier specifed

 

So alternative ga ODBC Connection dvara try cheddam anukunna.

 

 I could successfully set up the ODBC connection in  Microsoft ODBC Administrator.

 

 

But when I am trying to point out the ODBC connection in SSRS I am facing with the follwing issue .

 

ERROR[IM03] Specified driver could not be loaded due to system error 126. The specifed module could not be found.(Oracle in OraClient11g_home1, C:\temp\directory\product\11.2.0\client_`\BIN\SQORA32.DLL)

 

Plz babus help amma...

 

 

Thank you

[loveindia]

did u see this man... http://support.microsoft.com/kb/834305

[cool_dude]

Hello bhaiyya...link pani chesthaledhu....Neeku phn calling...no lifting...

[mtkr]

ltt...
did u resolve it!!??

[nenunanu]

nee client machine lo tnsnames.ora check cheyyi

it shud have an entry for the service name as connect identifier

post ur tns here if possible

[cool_dude]

nee client machine lo tnsnames.ora check cheyyi

it shud have an entry for the service name as connect identifier

post ur tns here if possible

 

 

Hello bhaiyya...

 

This is what the tns name connection file I am using

 

CLARITYQ =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = test.medctr.aaa.edu)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CLARITYQ)
   )
  )

[cool_dude]

LTT

[cool_dude]

ltt...
did u resolve it!!??

 

Ledhu bhaiyya inka..Im still trying to find the options.... ;(