Using SSRS 2005 With Oracle Database - Please Response

Nov 20, 2007

Will like to get some feedback regarding SSRS 2005 with Oracle Database.
Please advice pros and cons..
Thanks in advance and if anyone in such environment is here please respond.
Seems oracle discoverer is useless

View 9 Replies


ADVERTISEMENT

Need Help With SSRS 2005 Report Using Oracle 9i Db

Jan 18, 2008



We have been, successfully, using SSRS 2005 with SQL databases. Now are trying to do create SSRS 2005 reports using an Oracle database. What components do I need to install on our SSRS 2005 server to successfully render a report, in a web browser, using an Oracle 9i database. Any help would be appreciated.

View 15 Replies View Related

SSRS 2005 Connecting To Oracle Problem

Feb 29, 2008



I'm using Reporting Services 2005 and I can view the report in Visual Studio using the preview tab. After I deploy the report and datasource, when I try to view the report on the report server is says that I must have Oracle Client version 8.xx or higher.

I have the same Oracle Client Version on my local machine and the Report Server with the same DataSource name set up for Oracle on both machines.

Any ideas why this would work on my local machine but not the Report Server?

View 1 Replies View Related

Connecting SSRS With The Oracle Database

Nov 20, 2007

Hi all,
I need to connect with the Oracle Database for the Reports application. But i am unable to do the same. I am getting errors like ORA-12514,ORA-06401 while trying it.
(1) Please tell me about any extra settings need to be done in the listener.ora,tnsnames.ora for getting SSRS connected with the Oracle DB.
(2) Tell me the format of the connection string to be used for the connection with the Oracle database.
(3) Also which datasource has to used.. Oracle / Microsft OLEDB provider for Oracle for the Same.

Please help me with these issues.

With Thanks
M.Mahendra



View 4 Replies View Related

SSRS 2005 Not Closing Open Cusors In Oracle 9i

Aug 16, 2006

The shared data sources in our reports are calling stored procedures in Oracle 9i that return data in out ref cursors. We are creating a bunch of snapshots (about 1400 of them) programatically using the Reporting Services Web Service method CreateReportHistorySnapshot. This works greate but we quickly got the Oracle error "ORA-01000 Maximum open cursors exceeded". The maximum number of cursors is currently set to 1500.

Increasing the number of cursors is not a good idea because we have a subreport that executes an Oracle stored proc for each row in the main report and that would be a cursor for each row which would be about 5500 cursors in additon to the cursors we need for all the other snapshots being produced.

We need to find a way inside of Reporting Services 2005 to explicitly close these open Oracle cursors.

Any ideas out there?

View 2 Replies View Related

Slow Response From SQL 2005

Sep 28, 2007

hi,

I ran into a situation that if I don't use sql server for a while, in MS SQL Server Management Studio, when I run some query again, it takes a long time to respond. I looked into it with Activity Monitor, seems like the query was waiting for something, in the process view tab, it shows that:
WaitType: LATCH_EX
Resource: LOG_MANAGER(112F88C8)
What is the latch-ex? What should I check next to find out the problem?

Thanks.

View 4 Replies View Related

SQL 2005 Client Response With SQL 2000 Server

Oct 10, 2007



I have recently installed SQL 2005 client tools with SQL Server Management Studio and accessing databases on a SQL 2000 server. The response I am getting is extremely slow. Should I go back to SQL 2000 client or are there methods by which I can improve the performance.

Thanks
Sam

View 1 Replies View Related

Extended Login Response To SQLExpress 2005

Jan 14, 2007

I am having an issue with the login time from my program to authenticate through the SQLExpress. I have the latest version and I am using for code this :

Dim cnn As New SqlConnection(Globals.m_con_str)
Dim cmd As New SqlCommand("star_login", cnn)

cnn.Open()

cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@UName", txtUN.Text)
cmd.Parameters.AddWithValue("@PWord", txtPW.Text)

Dim dr As SqlDataReader

dr = cmd.ExecuteReader()
If dr.HasRows Then
While dr.Read()
..........execution of successful login
end while
end if

If cnn.State = ConnectionState.Open Then
cnn.Close()
End If

My issue is this. Once you have done this once speed is good from there on out. After you log out of the program, the login is good. I have tried reindexing because I though this might be the issue but it did nothing.

Any help would be greatly appriciated

View 1 Replies View Related

Copying Database Objects And Data From Oracle 8 To SQL 2005

May 16, 2007

Does anyone know how to copying database objects and data from Oracle 8 to SQL 2005 ?

View 1 Replies View Related

Can Co-installations Of MS SQL 2005 Express And Oracle 10g XE Database Server Interfere With MS SQL?

Feb 24, 2007

Hi -

I may not sound desparate, but I really am. I have spent many days now trying to install and re-install Microsoft SQL 2005 Express. I still cannot connect to the database! I have read this forum and tried various suggestions, like setting the remote connections and TCP/IP + Named Pipes. Still doesnt work!

The environment is Dell Dimension 24000 (I86) with WinXPPro.

Out of desparation, I downloaded and installed Oracle 10g XE. It works just fine !

My question is: Does the Oracle database server interfere with connecting to the Microsoft SQL 2005 Express server ?

Also, I notice that there are an awful lot of questions posted on this Forum concerning just getting your software up and running. Are there that many stupid folks out there like myself, or has this application been released prematurely ?

View 3 Replies View Related

SSRS 2005 Database Setup Error

Sep 26, 2007

Hi,

I am successfully installed SSRS 2005 in my PC winxp sp2.

BUt while trying to configure database (Previous 5 steps are green) i get the following error.

The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services

my database version
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

my reporting services version


ReportingServicesService!resourceutilities!9!9/26/2007-08:57:28:: i INFO: Reporting Services starting SKU: Standard

thank you in advance for any pointers.

regards
sahridhayan

View 1 Replies View Related

Load Severals Table On SQL Sever 2005 With Integrataion Services From Oracle Database

Mar 30, 2007

hello,



I want to load some table fromoracle database:



first : i created a datasource link between sql server and oracle database

second : i maked a flow to load data



Thus simple thing works good for one table...



But my question is how can i do for a group of table



In reality we have 30 table to do and i hear about variable, parameters ....



but i don't understand what it mean !!



so if somebody could explain to me the steps to do !!



View 1 Replies View Related

Error Using Linq Response.BinaryWrite For Images Stored In The Database

Mar 1, 2008

 
 hi i have given you the ado.net code to retrive a image from the database.
I have tried using linq and i am getting a error in
Response.BinaryWrite(rs.image) in LINQ.
so i have used the ado.net which i dont want to use.
can you pls help me how to correct the error.it says cannot convert linq.binary data...
thanks
 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim MyReader As SqlDataReaderDim MySqlConnection As SqlConnection
Dim MySqlCommand As SqlCommandMySqlConnection = New SqlConnection("server=(local)SQLExpress;Integrated Security=SSPI;database=customs")MySqlCommand = New SqlCommand("select * from tbl_temp_importer_owner where TIN=555", MySqlConnection)
 
MySqlConnection.Open()
MyReader = MySqlCommand.ExecuteReader()Do While (MyReader.Read())
Response.ContentType = MyReader.Item("PersonImageType")Response.BinaryWrite(MyReader.Item("PersonImage"))///Error come here in linq
Loop
MySqlConnection.Close()Response.Write("Person info successfully retrieved!")
 
End Sub

View 4 Replies View Related

Oracle 7.3 And SSRS

Oct 31, 2007

I am wokring on HP9000 system which uses Oracle 7.3 version on it. I am creating a Procedure to get the results as a REF cursor as suugested by this articale http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=382454&SiteID=1.

If I select Oracle as a datasource unfortunately I am getting this message " System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" and if I select ODBC as a datasource and trying to connect I am getting this message " ERROR [42000][Oracle][ODBC][Ora]Ora-00900: invalid SQL Statement (SQLORA32.DLL)".

I created this procedure in side a package and I am calling it as Package.ProcedureName

example: "UnAllocatedSSN.UnAllocatedMembersList "


Please help. Deepak

View 4 Replies View Related

SSRS && Oracle

Apr 2, 2008



Is it possible to use SSRS if my backend database server is Oracle server. If possible what will be the settings for data source.

View 1 Replies View Related

SQL 2000 Database Response Hangs After Cluster Failover Only When Active Connections Were Present

Sep 26, 2007

I have a Microsoft Cluster running on Server 2003 Entrprise. SQL 2000 8.00.2039 (SP4). 5gb physical memory installed.

With the databases online we run a test failover from the Cluster administrator. It takes about 30-40 seconds and completes without generating any Server Event log errors nor SQL log errors. Everything looks good from an administrative stand point.

However, when we test with running a series of queries to the databases, then failover, we notice that it can take up to 3 or 4 minutes before some of the databases will respond. Connections are not refused, they just sit there.

How can we troubleshoot this or does anyone have a similiar experience with this scenario?

View 5 Replies View Related

SSRS Oracle Connection

Apr 18, 2007

Hi,



We are trying to change our current SSRS reports to point to an Oracle 10g database. I can connect to the Oracle db from the report server via the ODBC Administrator and also through the BI 2005 studio. The connections work fine. However, when I publish the reports and try to run them from the web I always get a connection error. When I use the oracle connection it acts as if it doesn't see the oracle client and when I use ODBC it throws a werid 114 error.



Is there anything I am missing? I just don't understand why the report will work in BI Studio, but not when it is published (on the same machine)?



Any thoughts?



S

View 1 Replies View Related

SSRS Reports With Oracle DB--some One Plz Help Me.

Nov 21, 2007



Hi Guys,
I am creating SSRS report using Oracle DB. When i run this query in TOAD, it's giving output but when i run this in SSRS to create new dataset then it is giving me ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle).

This is the query iam running.

SELECT ts.transaction_status_desc, COUNT (ut.transaction_id) AS transcount
FROM dsc_transaction_status_vl ts,
dsc_user_transaction ut,
billing_markets bm,
retail_location rl,
cash_register cr
WHERE ts.transaction_status = ut.transaction_status
AND ut.cr_number = cr.cr_number
AND cr.rl_number = rl.rl_number
AND ut.RL_NUMBER = rl.RL_NUMBER
AND rl.bm_code = bm.bm_code
AND (ut.creation_date BETWEEN tartDate AND :EndDate)
AND bm.bm_name IN
(CASE (:Market)
WHEN 'OKC' THEN ('OKLAHOMA CITY' || 'TULSA')
WHEN 'NFL' THEN ( 'DAYTONA'|| 'JACKSONVILL' || 'MELBOURNE'|| 'NORTH FLORIDA'|| 'ORLANDO' || 'WEST FLORIDA' )
WHEN 'LA' THEN ('PAC Los Angeles')
WHEN 'CAR' THEN ('Carolinas')
END
)

I am passing 3 parameters: StartDate, EndDate and Market.
we have 3 markets and each market includes some cities. Cities are in BM_NAME column.
My Question is that
1) How to pass parameters for Oracle using SSRS
2) How to resolve this error: ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle)
3)How can i write Stored Procedure for this query & How to execute SP in SSRS.

Please reply me. Thanks in advance.

Thanks
Santosh

View 11 Replies View Related

Problem Using Oracle Data Source From SSRS

Sep 3, 2007

Hi,
I'm new to SSRS but have a problem connecting to Oracle. I have placed my reports upon a reporting server but the shared data connection isn't working and I'm confused as to why. I have specified the name, connection type as "Oracle", set the correct user id and password for the credentials and the connection string as for example 'Data Source=oracleExample;Unicode="True"'. I also have set the correct entry in the tnsnames.ora file for this datasource, example:
"oracleExample =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 12.23.45.23)(PORT = 3425))
)
(CONNECT_DATA =
(SID = oracle)
)
)"
Unfortunately I receive the following error when trying to connect.
"
An error has occurred during report processing.
Cannot create a connection to data source 'oracleDataSource'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
"
I'm mystified as to what the issue is. Any ideas? Would restarting the report server pick up the tnsnames.ora file? I have this working locally using report designer.
Any help, much appreciated.

View 1 Replies View Related

ODP.Net Vs. Microsoft Oracle Data Provider In SSRS

Oct 9, 2007



Which one is better to use? Is there a significant difference between the two?

Does someone have the directions to add ODP.Net to my database connections list in SSRS?

Thanks

View 1 Replies View Related

Using SSRS With An ODBC Data Source (Oracle RDB)

Feb 12, 2008

I'm attempting to use SSRS (2005) with my Oracle RDB database (old DEC RDB), using an ODBC driver. I am able to create a report, and view data, but I need to add some report parameters to filter the data. When I attempt to use parameters in the query, I either get a syntax error, or a message that my odbc connection cannot use "named" parameters, and that I should use "unnamed" parameters.

Here is a snippet of my sql query:

SELECT Application_Notes.Lease_Application, Application_Notes.Followup_Code,

<...>
FROM
Application_Notes Join

<...>
WHERE
(Application_Notes.Tickler_date >= {ts '2008-02-08 00:00:00'} AND

Application_Notes.Tickler_Date < {ts '2008-02-09 00:00:00'} )


The "Tickler_Date" field is a binary date field. The above syntax is pulled from a Crystal Report, which I am considering moving over to SSRS. Ideally, I would like the user to enter a single RunDate parameter, and have the query do the following:

Where (Application_Notes.Tickler_Date >= @RunDate and
Application_Notes.Tickler_Date < (@RunDate + 1 day) )


If the user has to enter two dates, that will be fine, but I can't seem to get past the errors.


Thanks,


Paul

View 6 Replies View Related

SSRS And Oracle's Star Transformation Query

Apr 30, 2008

So this has got to be considered a major, major flaw in how SSRS interacts with Oracle. I'm using the "Oracle" data provider, but I've also tried using Microsoft's OLE DB data source, and some others, and in no case does SSRS hand off to Oracle a query that does NOT have bind variables. In other words, typically query parameters get passed off to Oracle as bind variables.

The incredibly major problem that this causes is that it disallows Oracle's use of star transformation queries which is the primary method by which to get fast responses to a data warehouse/star schema, in fact a prime authority on this subject (Bert Scalzo, Oracle DBA Guide to Data Warehouse and Star Schemas, p.86 -- obvioulsy not using Oracle 7x was the first) lists it as in effect the #1 consideration.

So what gives? In effect SSRS cannot be used against large scale Oracle data warehouses? I've had success with Business Objects being able to access Oracle star transformations.

So a guess my question is how the heck can use SSRS in a big, Oracle-based data warehouse?


http://www.dba-oracle.com/oracle10g_tuning/t_star_transformations_sql.htm

For star_transformation join plans, the following parameters must also be considered: ... No BIND VARIABLE in SELECT statement

http://www.orafaq.com/usenet/comp.databases.oracle.server/2003/09/28/2305.htm
Star transformation is not supported for tables with any of the following characteristics:
* Queries that contain bind variables

View 1 Replies View Related

Reporting Services :: How To Execute Oracle 12c Procedures From SSRS

Oct 8, 2015

I am trying to generate a report using  SSRS ( SQL server 2012 & Visual studio 2013).  when I try to execute stored procedures I am getting below error. Below are the details of enviroment.

1. SQl serverr 2012
2.Oracle 12c client
3.Oracle Server 12c
4.Visual studio 2013

[code]....

View 3 Replies View Related

List Of Parameters Used Together With Rs: Parameter In SSRS 2000 And SSRS 2005

Apr 24, 2007

Hi,

Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?

Thanks,

View 1 Replies View Related

Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?

Sep 12, 2007

Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?

If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?

I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.

The developer PC is Windows Vista Business.

Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?

Thanks!
-ErikR

View 4 Replies View Related

SSRS 2005 - Migrating SSRS Subscriptions

Oct 25, 2007



Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?

I really appreciate your help on this.

Thanks,
Sam

View 6 Replies View Related

Native Oracle SQL -&&> SQL Server 2005 CE .sdf File -&&> Using Visual Studio 2005?

May 23, 2007

I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as:

select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table

There's also a CASE statement in there with some other data transformations.

Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Server Compact Edition database - within an application that I'm creating in Visual Studio 2005.

For whatever reason, I can't seem to do anything like that in 'bulk' and there aren't any data migration tools that work with anything other than "full" SQL Server versions. My client doesn't support SQL Server, but I can deploy my app with SQL CE. I need a 'local' copy of the database (for several reasons) and just can't seem to figure out how to make this work.

I'm really going nuts. I feel like I'm soooo close when I see the data I want in the table adapter - but I can't seem to actually *move* the data over!!

Can anyone help?

thanks,

Jon

View 6 Replies View Related

Reporting Services 2005 (VS 2005) Using Oracle 10g Stored Procedure

Apr 17, 2008

Hi,
I want to get data from Oracle 10g Stored procedure to Reporting Services 2005. I could pass a SQL text and get a record set, but I want to execute a store proc and get the record set.


1. Add New Data Source
2. Choose Type : Oracle and connection tested OK
3. { call Test_Package.Test_Procedure(?) } is it wrong... how to write???
There is an error in the query. ORA-00911: invalid character


Also make sure that you use the text-based generic query designer (2 panes !) instead of the visual query designer (4 panes) - you can switch between them through an icon on the toolbar in the data view of report designer.
Question : I tried many methods but unable to solve it...

create or replace
PACKAGE Test_Package
AS TYPE Test_Type IS REF CURSOR RETURN Test_Table%ROWTYPE;
END Test_Package;


create or replace PROCEDURE Test_Procedure (
Test_Cursor IN OUT Test_Package.Test_Type,
Test_Parameter IN Test_Table.ID%TYPE
)
AS
BEGIN
OPEN Test_Cursor FOR
SELECT *
FROM Test_Table WHERE Test_Table.ID >= Test_Parameter;
END Test_Procedure;

The below site gave some example but i could not solve it... any suggestions greatly appreciated...

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=357121&SiteID=17


http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/bbc613c4529ed3cd/696624ec4ba70937?q=oracle+stored+procedures

View 1 Replies View Related

How To Copy Table From Oracle Database To Sqlserver Database ?

Jul 20, 2005

Hello,I need to copy a table from an 8i oracle database to a sqlserver 2000 database.Is it possible to use the command "COPY FROM ... TO ..." ?So, what is the correct syntax ?Thanks for your helpCyril

View 1 Replies View Related

Error Importing Data From Oracle Database To An SQL Database

Oct 11, 2005

Hi!

View 36 Replies View Related

How To Genarate Report Using SSRS 2005 And Visual Studio 2005

Apr 17, 2007

Dear All,

I am basically new as far as SQl server 2005 concern.
I want to try out reporting services provided by sql server 2005.
That is make report using sql server 2005 and call that report from web or window application.

Please guide me in doing so or give me some useful link.
Thanks

View 1 Replies View Related

Does SQL 2005 Come With SSIS, SSRS, SSAS, BIDS, VS 2005?

Dec 4, 2007


Hi everybody.

I'm looking to upgrade to SQL Server 2005 (Standard Edition). I'm interested in using SSIS, SSRS and SSAS. I hear that BIDS runs inside of Visual Studio 2005, and comes with the SQL 2005 software. I currently have VS 2003. My question is: Do I need to purchase anything besides SQL Server 2005 Standard, or do I need to buy anything separately, like VS 2005? (if so, which version would you recommend?)

Thank you very much!

- Trevor

View 7 Replies View Related

How To Convert Oracle 8 Database Into SQL Server 7.0 Database

Oct 15, 2001

Ho do I convert Oracle 8 database into SQL server 7.0 database ? Is it possible ? Please let me know at skbhaduri@rediffmail.com

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved