Re: Oracle connection problems (MS SQL Reporting Services)



On 28 Aug 2006 10:25:31 -0700, "calgarydatagrl@xxxxxxxxx"
<calgarydatagrl@xxxxxxxxx> wrote:

I am building reports for a migration project on an Oracle 10g database

server. I have built all my reports with text queries in Visual Studio

.NET and setup my data source connections there, and all the reports
work great when I preview them there. Once I upload them to Reporting
Services, I get the following error:

An error has occurred during report processing.
Cannot create a connection to data source 'ISRVTST1'.
For more information about this error navigate to the report
server on the local server machine, or enable remote errors


I don't know what is different... everything is setup the same. Am I
missing something I should be doing? I have set it up as an Oracle
connection type, just like in Visual Studio.

I'm not sure why this qualifies as an Oracle problem instead of a
Microsoft problem.
I don't see any Oracle error message, so there is also nothing to work
on.

--
Sybrand Bakker, Senior Oracle DBA
.



Relevant Pages

  • Oracle Security Advisory: Run any OS Command via unauthorized Oracle Reports
    ... Red-Database-Security GmbH - Oracle Security Advisory ... Run any OS Command via unauthorized Oracle Reports ... Oracle Reports, a component of the Oracle Application Server, is used by Oracle ... Oracle Reports starts reports executables from any directory ...
    (Bugtraq)
  • Re: ORA-03114 Not Connected To Oracle problem.
    ... >Terminal Services and all the sessions are handled by one server. ... >and only one connection to Oracle will fail. ... Likely this is a result from shared pool ...
    (comp.databases.oracle.server)
  • Re: Xvfb X-server emulator and Oracle 11i reports server
    ... > The reports server for Oracle 11i requires an Xserver to write to for the ... > production of bitmap reports. ... > Oracle support are not too helpful regarding this error, ...
    (comp.unix.solaris)
  • Re: Oracle connection Fails
    ... That should show you what's attempting to be sent to the server. ... to connect to the oracle database by using Oracle data provider ... from Our main server i am getting an exception. ... Connection conn, IntPtr opsErrCtx, Object src) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IDbCommand, Oracle, Select query
    ... My mission is to execute a sql statement in vb.net and retrive the data ... Using connection As New SqlConnection ... "An error has occurred while establishing a connection to the server. ... I am running a oracle server with a database I am trying to access. ...
    (microsoft.public.dotnet.general)