Contents tagged with SQL Server Reporting Services

• SQL Server Reporting Services Data Source Connecting String for Oracle Database

  Tags: Oracle, connection string, SSRS, SQL Server Reporting Services

  Sunday, May 13, 2018 2:06:31 PM

  No Comments

  Type:  OLE DB

  Connection String: Provider= ORAOLEDB.Oracle; Data Source=<MyOracleDataseName> more

• SQL Server Reporting Services Error: The 'ORAOLEDB.Oracle' provider is not registered on the local machine.

  Tags: SQL Server Reporting Services, error, OLEDB, registration, ORAOLEDB.Oracle, registered

  Sunday, May 13, 2018 2:04:22 PM

  No Comments

  Open a command prompt in administrator mode

  cd \oracle\product\11.2.0\client_64\BIN

  c:\Windows\system32\regsvr32.exe OraOLEDB11.dll

  source: https://stackoverflow.com/questions/12903366/ … more