Cannot Connect To Oracle Using SSIS Or Crystal Reports
Oct 9, 2007
I am working with the IT department at a client site trying to hook into Oracle. We are using Windows Server 2003 64-bit, SQL Server 2005 Standard 64-bit, Oracle 10-g 64-bit and Linux Red Hat 64-bit. All service packs are current.
We are working on a data warehouse project where we need to import Oracle information periodically throughout the day and integrate it in a central location with data already residing in SQL Server. This is the first time I have tried to pull data from Oracle. The databases in Oracle and SQL Server that we are pulling data from are third party application databases.
My client cannot connect to Oracle using Crystal ODBC connections. When we use either the .NETor OLEDB connections, we get the "client tools need to be installed" message. We do have the client tools installed on the WIndows Server that SQL Server is installed on. We can connect to Oracle from this locattion using Aqua Data Studio and SQL *PLUS. I checked and there is only one tnsnames.ora file on the server. I used the name from there to try to connect using SSIS. Still no luck.
I did see somewhere that there is a possible issue with 64-bit installations. We really need to get this connection working.
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID. I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data: 1 - 50 60 - 80 150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
I've made connections in SSIS to Oracle before by setting up TNS but this latest connection is different.
I've been give an SSL cert that I had to import into the Oracle Wallet Manager and to get connected in 'Oracle SQL Developer' I had to choose connectionType = advanced and drop the following line in the JDBC URL section
I'm having an issue connecting to an Oracle database using Visual Studio 2013 - Business Intelligence tools.I am running Windows 7 (64-bit), Visual Studio 2013, and have SQL 2012 Enterprise (64-bit) on my local machine. I downloaded the MS Connectors v2.0 for Oracle found here. But when I try to add a new connection either through the connection manager or inserting a Data Flow Task and looking for the Oracle connections in the "Other Sources" or "Other Destinations" - neither option is available.I have the 32-bit Oracle client installed, the tnsnames.ora file has been created and I can connect to the Oracle DB through PL/SQL.I see Microsoft Connector for Oracle by Attunity 2.0 in my Programs list - installed for this file: Attunity SSISOra Adapters SetupX64.msi. don't know what else to try to get the connections available.
A long shot but someone may have experienced same problem. We are using Crystal Info to run reports against a SQL 7 database. Reports that usually take 1 or 2 minutes to run are taking up to 15 minutes to run. The database is fine ie you run the query through the query analyser and it runs in 1 or 2 minutes. Any ideas... I've spoken to Seagate but not making much progress. Thanks in advance..
I'm new to SQL but have quite happily been using Crystal Reports without it until now.
I am creating a letter template and it has the name at the top then the address
<name>
<address1> <address2> <address3> <address4>
There is always an address 1, but maybe not a 3 or a 4, and aparently we dont want any line gaps to show, so I figured i should use an isnull to eliminate the line and to move the other address line up?
Hi, I'm very new to SQL Server, I'm coming from an Oracle background. I've set up a server with windows authentication but I'm having no luck connectiong to it with Crystal Reports XI. Can anybody go through the basics with me? Regards Sean
Hi,I'm semi-new to crystal reports & sql server and what i want is toextract data from a sql server file. I've been able to connect to sqlserver directly and get the info. i need but is there a way to just openthe data file (in crystal reports) without making a server connection?TIA
Has anyone had any luck getting Crystal Reports 8.5 to work with theSql Server 2000?I keep getting a "Unable to open Database" error. I've tried openingwith either the .Connect property and the LogOnServer method and getthe same message from either approach.I am using the OCX control.Does this version work with Ms Sql?Any thoughts and suggestions would be most appreciated.Thanks.-Dave
I exported a column of type float to SQL Server using DTS. In Crystalreports, it 'sees' the column as a string! Is 'float' the best type touse? Must I create a formula field in CR to 'correct' for this?
I am just exploring options for setting up online databases to permit input by clients and output in the form of Crystal reports. Am I barking up the wrong tree or on the right track?
I want to know which would be the best for reporting in either of the above two. I am working on with SSRS but don't have any idea about crystal reports. So you all please suggest the best one would be for me espcially for web based reporting.
I showed my boss the functionality of ad hoc reporting in SRSS and he likes it. He asked me if we could completely move away from Crystal Reports (CR) to SRSS.
Does anyone have any issues with SRSS that didnt exist in CR.
One question i have is programmability capabilities. Some time back i had to make a very complex report in CR. I create a table in the dataset. Designed the report to pull data from that table and the table was being populated through some VB.NET code. So the users will open a GUI and hit RUN, which is when i will populate the table and show the report. You can assume that populating the table required complex programming and couldnt have been done through user defined functions in a report.
I dont suppose stuff like this can be done in SRSS?
i have a problem in crystal report, i want to dispaly data from MYSql data base to crystal report through my application I have'nt work on crystall report before this please help me..... thanks in advance
I have been tapped to help with fixing a reporting tool. We have a Sql Server database/crystal reports(10) setup. I havent had the chance to look at the tables in the DB yet, but I was told that aggregate tables were used. In my past experience with crystal reports, we used database views to feed crystal reports (in Oracle). I was thinking that I could somehow use views instead of tables and then try to re-index the base tables and compile satitics (if theres such a thing with Sql Server). I was also going to look into bottlenecking and locking (table locking as opposed to row or page locking for the lookup tables...to reduce overhead on the main tables) but, I'm not sure if it'll make a difference since this is just a demo server with no major traffic hitting it yet.
The question is, does anyone have any experience with crystal reports running slow with Sql Server, what should I look out for??
I am new in Crystal reports so please help me on this one.
I have to create a report that will bring back the TOP 20 customers per Sales Rep. My SQL stored procedure needs a parameter @SalesRep to execute. My stored procedure links between 2 tables. How do I get this stored procedure executed in Crysal Reports to give me results. The SP works fine.
I have been trying to create an application for Pocket PC. I want to provide some report writer to the database in SQL Server CE. But, whenI select smart device application, the Crystal Report component is not available in the Tool Box. Even when I try to add the component, Crystal Report viewer component is not seen. How can I add Crystal Reports in my application? Can anybody help me?
I've been able to insert a graph in my reports which automatically allow drill down (into the graph). This has stopped working on new reports and I can't see why, or how to allow drill down (in graphs) again. Anyone help? I'm using Crystal Developer Ver9.2. Thanks
I have created a "read only" login on the SQL 2005 database server with rights to the public role with grant connection rights. When I use the "read only" username in Crystal Reports, the database does not show in the dropdown box. When I give "read only" sysadmin rights, all databases appear. I do not want "read only" to have sysadmin rights, is there another way around this that would truly give "read only" read-only rights?
Crystal reports to Reporting Services Is there any way I can convert Crystal reports to Reporting Services instead of creating reports again in Reporting Services?
I came across a website that claimed "There are approximately 116 functions in Crystal Reports that do not have a direct equivalent in VB.NET or Reporting Services (SSRS)." Does anyone know what these functions are?
I have been evaluating the Microsoft SQL Server Everywhere Edition and have been trying to create a Crystal Report from it. When creating the connection from Crystal I have selected the OLE DB provider supplied by Microsoft with the product and then been presented with the 'Data Source' screen. On entering the path to my .sdf file I get an error reading :-
Opening a database as read only requires a temp path to be specified. [,,,Db name,,]
Can you tell me what is required to be entered here?
Also - I only have the Express Edition of SQL Server 2005 which won't open an Anywhere Edition database - is there a way of getting the mobile tools for use on the desktop?