tags:

views:

23

answers:

1
Q: 

Oracle Database with SSRS reports

Using SSRS with Oracle DB is not orthodox, but still i am forced to use it. So, while i am working on my reports, if another collegue of mine tries to do a query on the same database, an error occurs, on the TNS Listener. When i check the number of sessions active or inactive, they are in the limit secified. After i close and reopen the SSRS project from Visual Studio it works and also it reduces the number of sessions.

Is there a way to make oracle accept more sessions? or any other solution?

PS: Oracle version 10g, Visual Studio version 2005

A: 

I am using SSRS 2005 to report off Oracle 10g, and I haven't seen this issue. How is your colleague querying the database, and what drivers are you using?

Mark Bannister  2010-10-12 10:24:26
I think it says that TNS could not be found, or something similar, the problem is that it's not from tnsnames.ora config file, that is okay, the problem is from the many simultaneous connections that SSRS opens when editing a report. I tried increasing the maximum sessions number and the maximum processes number, maybe that would give me a resolution. i only have about 50 sessions so it might be from this, or it just might be from the oracle server configuration. we both have oracle 10g client on our machines...
GxG  2010-10-12 10:57:20

related questions

What is the best way to do unit testing for ASP.NET 2.0 web pages?
TestDriven.NET is not running my SetUp methods for MbUnit
Automated release script and Visual Studio Setup projects
Setup Visual Studio 2005 to print line numbers
What is the best way to deploy a VB.NET application?
How do you pack a visual studio c++ project for release?
How to set up unit testing for Visual Studio C++
How can I create Debian install packages in Windows for a Visual Studio project?
Plugin for Visual Studio to Mimic Eclipse's "Open Type" or "Open Resource" Keyboard Access
How to generate getters and setters in Visual Studio?
Do you have any recommended add-ons/plugins for Microsoft Visual Studio?
What is keyboard shortcut to view all open documents in Visual Studio 2008
Visual Studio 2008 debugger already attached work-around
Add Custom Tag to Visual Studio Validation
ASP.NET MVC Without Visual Studio
Are Multiple DataContext classes ever appropriate?
Folders or Projects in a Visual Studio Solution?
What's a good book for learning ASP?
Integrating Visual Studio Test Project with Cruise Control
.Net XML comment into API Documentation
Visual Studio Setup Project - Per User Registry Settings
.NET Testing Framework Advice
Automatically update version number
Build for Windows NT 4.0 using Visual Studio 2005?
ASP.NET, Visual Studio and Subversion - how to integrate?