new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Map One generic Input column to multiple Destination column Hi, You can use "Copy Column" transformation component to copy one input column to multiple output columns. If you have to perform some computing between original and new columns, you can use "Derive Column" transformation. Jean-Pierre Riehl http://blog.djeepy1.net http://www.bewise.fr Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 2
    - How to determine if the logged on user is a member of an active directory security group? Moved to Security... Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 3
    - SQL 2005 RS Configuration Tool - Encryption Key Error Dz0001, You said you uninstalled and installed again SQL 2005 Reporting Services and you did not backup the key before uninstallation. I have two questions: 1. Are you trying to use the old catalog (which was not removed during uninstall) with the new installation of Reporting Services 2. What version of SQL 2005 Reporting Services you are using Is SP2 or earlier Mihaela Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 4
    - Error Connecting to Remote Server Using Microsoft SQL Server Management Studio Express This support article might give you some more info.. http://support.microsoft.com/kb/914277 By default, SQL 2005 servers are configured to not allow remote connections through TCP/IP. This is a security measure. You will want to ensure that the remote SQL Server you are trying to connect to is configured to allow remote connections. Hopefully this helps, if not, please post back with more info. -Steve Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 5
    - parameterize SSIS package to identify a source file location If my understanding is correct; you wan to change the path of the flat file connection manager dynamically. If that is the case, you can use package configuration to set it at run time. You could also look at the /set switch of the DTExec utility. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 6
    - Create Table within an IF statement causes error This is usually caused because you have ran a CREATE TABLE statement in a previous development iteration. Try appending this to the end of your code: Code Snippet go drop table #DontWork The temp table stays in scope after you run through one time so the next time through you get the error. Try hiliting the code I've given you and execute just the DROP TABLE. Then un-hilite the code and rerun query. It should run correctly once you have dropped the table. OK, I'm all wet... Hang on. You can alter it: Code Snippet create table #what (one int) alter table #what add two int alter table #what drop column one select * from #what go drop table #what /* two ----------- */ Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 7
    - Strange Behaviour Sort and Merge Join SQL collations sort differently than windows collations; SSIS uses windows collations, while SQL server uses both SQL and windows collations. What you're observing is that a hyphen in a SQL collation (e.g. SQL_Latin1_General_CPI_CI_AS) sorts differently than a hyphen in a windows collation. There is no bug. There are three options. 1. Use an ORDER BY COLLATE clause with a windows collation, leaving the table as is. 2. Define the sorting column with a windows collation, not the older incompatible SQL collation. 3. Define the sorting column with nvarchar character type rather than a varchar character type. Here's are examples of the three options for matching SSIS sort order (Windows) with SQL server's sort order (SQL or Windows). Code Snippet IF OBJECT_ID ( '[dbo].[table_2]' ) IS NOT NULL DROP TABLE [dbo] . [table_2] go CREATE TABLE [dbo] . [table_2] ( [test] [varchar] ( 50 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) INSERT INTO table_2 VALUES ( '1-1.00.00.00' ) INSERT INTO table_2 VALUES ( '1000' ) INSERT INTO table_2 VALUES ( '2000' ) SELECT test FROM dbo . table_2 ORDER BY test -- collates by column collation of SQL_Latin1_General_CP1_CI_AS /* 1-1.00.00.00 1000 2000 */ -- Option 1: Use a Windows collation in an ordered select statement , leaving the table as is SELECT test FROM dbo . table_2 ORDER BY test COLLATE Latin1_General_CI_AS /* 1000 1-1.00.00.00 2000 */ -- Option 2: Define the table with a Windows collation IF OBJECT_ID ( '[dbo].[table_2]' ) IS NOT NULL DROP TABLE [dbo] . [table_2] go CREATE TABLE [dbo] . [table_2] ( [test] [varchar] ( 50 ) COLLATE Latin1_General_CI_AS NULL ) INSERT INTO table_2 VALUES ( '1-1.00.00.00' ) INSERT INTO table_2 VALUES ( '1000' ) INSERT INTO table_2 VALUES ( '2000' ) SELECT test FROM dbo . table_2 ORDER BY test /* 1000 1-1.00.00.00 2000 */ -- Option 3: Define table with nvarchar character types IF OBJECT_ID ( '[dbo].[table_2]' ) IS NOT NULL DROP TABLE [dbo] . [table_2] go CREATE TABLE [dbo] . [table_2] ( [test] [nvarchar] ( 50 ) NULL ) INSERT INTO table_2 VALUES ( '1-1.00.00.00' ) INSERT INTO table_2 VALUES ( '1000' ) INSERT INTO table_2 VALUES ( '2000' ) SELECT test FROM dbo . table_2 ORDER BY test /* 1000 1-1.00.00.00 2000 */ Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 8
    - Server Agent Jobs: Script job as create to file... Hello, There is not a straight-forward answer to your question, however here are some items you may find helpful: THE SQL Server SMO Library can be used to script Agent Jobs (which is the API that SSMS is using) MSDB is the containing database for the jobs and their tables/views My guess is there is that when you call the SMO Script() method of the job object it is polling the system tables and then generating the appropriate TSQL Scripts. Hope this helps, Derek Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 9
    - comparing two fields If you are using SQL 2005, try a EXCEPT JOIN. Something like: SELECT Block_Code, Zip FROM BLKPTS_ADDXY EXCEPT SELECT Block_Code, Zip FROM allblkzips Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 10
    - Transaction Question SQL Server only physically supports a single transaction. Named transactions are only useful for marking the transaction log. If you are trying to just roll back the stuff in the dynamic SQL, then you need to change the code to: save tran T2 raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return Save tran lets you roll back part of a transaction Also: Consider getting rid of the double quotes as that is not standard and not a good practice. Just double up quotes in the dynamic SQL: 'save tran T2 raiserror( '' inside proc'', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return' Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 11
    - Cannot connect to 2000 from 2005 via linked server To make sure I understand, you got box A running Win2K3 SP1 that has a SQL2K5 instance (inst1) and a SQL2K instance (inst2). You've got another box B that has a SQLK2K5 instance (inst3). Inst1 has linked server entries for inst2 and inst3. Inst3 has linked server entries for inst1. The problem is that from inst1 connecting to inst3 isn't working. What is the OS of box B It sounds like you may have a firewall running on box B preventing connectivity. Also, is the TCP protocol enabled on inst3 Here's a link to a bunch of connectivity troubleshooting tips: http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx Hope this helps, Vaughn Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 12
    - Cube processes OK but no rows appear in the browser Hello! In the calculations tab of the cube editor(in SSAS2005) , check that you have this statement; CALCULATE; HTH Thomas Ivarsson Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 13
    - Is there Limitations to Importing data to SQL Server Express Hi Bill, SOL Server express is an evaluation copy. You need the full version. Please see this thread......... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=157773&SiteID=1 Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 14
    - Multi-database Multi-server I think your are fine. RS report can access tables from multiple databases at once or you will also be able to write a report that aims one database, but it changes depending on, for example, user preference. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 15
    - DB does not autogrow I saw exactly the same problem years ago with a large DB. The problem is that the SQL statement that is causing the Auto grow is timing out, so the grow rolls back ! Next statement does the same thing. Never keep the default 10%, always set to some size that can be acheived in under 10 seconds. I use 100Mb on data and 10mb on transaction. You should not really be relying on auto-grow, a DBA should monitor it and manually grow during off-peak time. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 16
    - Want Text box font to be inherited from list Hello, Not sure if this will help, but every report in srs is an xml file, right click on the rdl file and click view code (xml) You can use CSS (cascading style sheet) with xml, an example is: An xml file w/out css: http://www.w3schools.com/xml/cd_catalog.xml The CSS: http://www.w3schools.com/xml/cd_catalog.txt An xml file w/ css: http://www.w3schools.com/xml/cd_catalog_with_css.xml Taken from: http://www.w3schools.com/xml/xml_display.asp Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
- Next
  - 1
    - copying tables DTS vs SSIS - speed!!! Use the "Table or view - fast load" option in your OLE DB Destinations. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 2
    - using historical attributes with SCD transform on a table with a PK You're going to need more fields in that table to make it work... Where is your current record indicator (either start and end date fields or a current indicator field) And ID shouldn't be the PK of the table as that is the business key, designed not to change. You should have a separate PK field in that table -- either an (gasp!) identity field, or a self-generated surrogate key field. This allows for the business key to never change (it shouldn't!), but still allows for new records to be inserted because the business key isn't part of the table's primary key constraint. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 3
    - How to validate the parameter values? There is no way to validate and inform the user if the parameter value is not in a given range. Though you can restrict the values that user can select for the parameter by providing pre-defined available values to the parameter, either from query or non-queried. Shyam Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 4
    - How do I go about placing photographs in SQL? Not sure if this is the best place for the question, but check into the VARBINARY(MAX) datatype for image storage. Simone Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 5
    - Average of children Give me the SQL script that generate your tables to understand more exactly what you pretend! regards! Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 6
    - Query Time Limit? It prevents query from executing based on the cost rather than controlling resources. BOL 'If you specify a nonzero, nonnegative value, the query governor disallows execution of any query that has an estimated cost exceeding that value. Specifying 0 (the default) for this option turns off the query governor, and all queries are allowed to run indefinitely. "Query cost" refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 7
    - Personal Web Developer Kit SQL Error In the default installation, SQL Server installs with very tight security. Please refer to these articles for help in setting the correct configuration parameters. Configuration - Configure SQL Server 2005 to allow remote connections http://support.microsoft.com/default.aspx scid=kb;EN-US;914277 http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuration -Connect to SQL Express from "downlevel clients" http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx Configuration -Connect to SQL Express and ��Stay Connected�� http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html Configuration - Guideline for Connectivity Question Posting http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=362498&SiteID=1 Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 8
    - SQL Server - using a cursor to find and sum login/logout times You can do this without a cursor, but this method does require that you don't have bad data. Let me explain... If EVERY login has a corresponding logout and the date/times match up nicely, you can use set based operations to perform this query. What I present below will create a table variable to store your data. If this method works for you, simply remove the @Temp variable and change the subsequent query to pull the data from your table. -- Setting up some sample data. Declare @Temp Table(UserAction VarChar(20), UserName VarChar(20), ActionTime DateTime) Insert Into @Temp Values('login', 'user1', '2007-02-15 10:21:35.590') Insert Into @Temp Values('login', 'user2', '2007-02-15 10:21:36.100') Insert Into @Temp Values('logout','user1', '2007-02-15 10:22:45.100') Insert Into @Temp Values('login', 'user3', '2007-02-15 10:23:23.100') Insert Into @Temp Values('logout','user2', '2007-02-15 10:27:54.436') Insert Into @Temp Values('logout','user3', '2007-02-15 10:30:03.237') -- Actual query would begin here. Declare @Actions Table(RowId Integer Identity(1,1) Primary Key Clustered, UserAction VarChar(20), UserName VarChar(20), ActionTime DateTime) Insert Into @Actions (UserAction, UserName, ActionTime) Select UserAction, UserName, ActionTime From @Temp Order By UserName, ActionTime Select A.UserName, B.ActionTime - A.ActionTime From @Actions As A Inner Join @Actions As B On A.UserName = B.UserName And A.RowId = B.RowId - 1 And A.UserAction = 'Login' And B.UserAction = 'Logout' Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 9
    - Query performance problems with join on UDF-based computed column By default, the engine does not know anything about the udf (i.e. has no statistics). So, bad plan can be generated. To avoid this, I suggest that you create your udf with schemabinding and persist your computed column. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 10
    - Pointers to the best documentation on star joins and the optimiser The star query optimization in SQL Server is index based optimization. The following resource will tell you basic of the query optimization for the star queries, and also how to figure out whether the final query plan benefits from the star join optimization. Chapter 14 and looking for 'star queries'. http://www.microsoft.com/technet/prodtechnol/sql/70/reskit/default.mspx mfr=true http://blogs.msdn.com/sqlqueryprocessing/archive/2007/04/09/how-to-check-whether-the-final-query-plan-is-optimized-for-star-join.aspx In order to understand the spool issue further, if possible, please post the statistics XML you got from the query plan with eager spool. Usually, that would be caused by an underestimation of the cardinalities and the optimizer believes store the data in tempdb and reuse it later is a cheaper solution. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 11
    - Multiple Select statements + Stored Procedure At a time you can only bind one resultset. if you need both the resultset on your page, you need to have 2 datagrid view. If you use dataset, grid1.DataSource = dataset.Tables[0]; grid2.DataSource = dataset.Tables[1]; If you use datareader, grid1.DataSource = datareader; datareader.NextResultSet(); grid2.DataSource = datareader; Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 12
    - hidden views when u export view from one database to another the view is created as table in the target database. To migrate view , create script of the view and run that script in Target DB... ... do not select view in Export wizards only select tables... if you are getting View1 already exists then :- Check in Tables there will be a table called View1 , first drop that and run the script for view1 to create... Madhu Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 13
    - Login Failed for <domain name>\<Machine Name> Use a Service account for your report server web identity and app pool in form <domain> \username make sure this user is an admin on DB and on the web server and is also a Member of the IIS_WPG group in the web server gatharia Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 14
    - adding client server aliases Unfortunately, as you noticed, the functionality to import a list is missing. If you think it would be a useful addition, please let your wishes/needs be known at: Suggestions for SQL Server http://connect.microsoft.com/sqlserver Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 15
    - Profiler trace bind variables As I indicated in your previous thread, Profiler will provide you the opportunity to log the entire SQL statement, replacing the parameters with the values. For @parameter1 = 25, @parameter2 = 3; insert into x values ( 25, 3 ) etc. And I still think you are 'barking up the wrong tree' to seriously be considering Profiler as a Auditing tool. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software
  - 16
    - aspnet_wp.exe crashing intermittently After so many attempts, the problem came out to be with spoolsv.exe. This is the windows print spooler service. As soon as a print command is given from any application, the spoolsv.exe used to consume a part of the non-paged pool of Kernel Memory. But the real culprit I think is the HP TCP/IP Port, which is configured for the HP Printer. The problem was found out by adding the pooled and non-pooled columns in the windows task manager. As soon as the print is spooled the non paged pool is consumed and is not released. And goes on accumulating until it reaches near to 253 MB and ultimately the scenario happens. There is a bug in MS Winsock Library, which might be causing the HP Driver to show this kind of behaviour. Anyway the problem is temporarily solved by restarting the Print Spooler Service. Tag: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software

JCNET

re: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software

From my desktop the report accessing an Oracle 9i db with no problem.

I've deployed other reports accesing sql server with no problem.

Now I deploy the report and try to access my Oracle source and get:

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

On the server in question, I know they've installed the oracle client. I can access the db from sql plus with no problem.

As the user that I access ssrs credentials, i remote login and am able to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN

i've confirmed my database is in tnsnames and it works from sqlplus.

Top