Data Connection Problem: Modify Connection Disabled & Cannot View Stored Proc

Similar Threads:

1.Server Explorer Data Connection Problem: Cannot Modify Connection

After adding a data connection to the VS.NET 2003 Server Explorer I am
unable to modify the connection. If I right-click on the data
connection the Modify Connection option is disabled.

Also I am unable to view or execute any stored procedures. I can see
the stored procedure and view a list of the parameters but
double-clicking does not display the procedure's code.  With tables I
am able to retrieve data but not make any changes.

These problems occur with any type of data connection. I have tried
both SQL Server and Oracle. I have also tried both with and without XP
SP2 installed on the machine. Has anyone else run into this problem? If
so, what is the fix?

2.global connection or seperate connections for each stored proc cal

Hi I seem to recall reading that it can be a bit risky using just 1 global data connection in the global.aspx file, instead of multiple connections, but can not recall why. Also is there a lot of overhead with multiple connections?  I did a search but did not find anything. Thanks. 
-- 
Paul G
Software engineer.

3.view connection pool/open or used connections?

Hi,

I had an error concerning the connection-pool: "Timeout expired.  The
timeout period elapsed prior to obtaining a connection from the pool.  This
may have occurred because all pooled connections were in use and max pool
size was reached." (in VB.NET).

I was already able to solve the problem, because I didn't know before I have
to close the SqlDataReader also.

But I saw in some forums terms like 'the performance monitor' whcih can be
used to see the connection pool or the connections that are used.
Unfortunately I wasn't able to find this 'monitor'. Can anybody tell me
where to find it or something liek that? so I will be able to see if I'm
using too many connections or having still some connections open.

I'm using VB.NET (2003), with an MSDE database and Sql Server.

Thanks in advance,

Pieter

4.Get return values from a stored proc inside a stored proc

Hi everyone,
Can someone show me how to obtain values returned from a called stored proc 
inside a calling  stored proc. For example:
StoredProc1
========
CREATE PROCEDURE StoredProc1(@keyID Int) AS
SELECT value1, value2, value3
FROM Table1
WHERE id = @keyID 
GO

StoredProc2
========
CREATE PROCEDURE StoredProc2() AS
...
EXEC StoredProc1 @keyID = 1

I need to obtain value1, value2 and value3 from the StoredProc1.

Any suggestion is greatly appreciated.
Calvin

5.How to modify connection string at runtime for strongly typed data

Hi,

I have been struggling for the past couple of days with this problem and I 
don't know how to go about fixing it.  I hope somebody can help.

I have a Windows application (C#) where I have a few datasets holding quite 
a number of tables.  These datasets were created visually by drag and drop 
and the process created as many TableAdapters as there are tables.  These 
datasets are in their own VS 2005 project for reuseability purpose.  My Main 
Win application has properties setup including sql connections strings.  All 
are fine for design time and testing.  But at runtime, I need to modify the 
connection string based on the user, environment etc.  I need to make this 
strongly typed autogenerated dataset to receive a custom connection string 
(which also need to be created at runtime) from my Application.

Is there some sample code out there (preferably in C#) to achieve this? I 
have seen a few posts and blogs that suggest some solutions. But they don't 
seem to work for me.

Babu.

-- 
BabuMan

6. Can not modify data connection properties

7. VS.NET->Server Explorer->Data Connection->Add Connection

8. Leftover Connections in Connection Pool (connection leak)