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

Visual Studio .Net

    Next

  • 1. Error displaying form in designer
    I am having a strange problem (.NET 2002). I have searched the internet and found related problems, but none of the solutions seem to fix the problem that I am having. I created a custom control by deriving from Windows.Forms.ComboBox. I inserted a combo box into my form, and then modified the declaration & initialization of this combo box to use this new control instead of the generic combo box. I rebuilt the project, and when I go into the form designer, all is well (so far). Next, all I did was add a reference to a .NET dll. (which specific DLL does not seem to matter, I've tried several). Then I rebuilt the project. Now, when I go back in to the form designer, I get the error: An error occured while loading the document. Fix the error, and then try loading the document again. The error message follows: Exception from HRESULT: 0x80131019 Can anybody here tell me how to fix this error? This is driving me crazy! Thanks for any assistance you can offer. Jon
  • 2. How to programmatically place add-in toolwindow in same frame as tasks?
    Hello everybody, I'm currently developing an Add-In for VS.Net 2003. I already got beyond all the obstacles like Win32 resource DLL, transparent images, placing the toolbar, etc. Only for placing toolwindows I couldn't find anything. Instead of having toolwindows float initially, I'd like to show them docked initially, in the same frame as the tasks window. Anybody knows how to do that? Thanks, Christoph
  • 3. ARGH. Stop rewriting my markup!
    I'm using VS.NET '03. I go to type a label tag in HTML mode of my ASCX page: <label for="thisitem"> I flip to design mode, then flip back and my tag now looks like this: <LABEL for=thisitem> ARGH! How can I make VS.NET stop doing this? I've looked at all my HTML formatting options and I have everything turned off. Am I missing something? Is this just yet another incredibly annoying MS bug? Is this MS plotting to never allow folks to build standards compliant sites? -Darrel
  • 4. extending a solution item
    Hi all, I'm writing a VS.NET extender in C# and I'm having trouble finding an appropiate guid for solution items to get the IDE call my extender. I've successfully extended other different objects, but can't find a way to extend the files under Solution Items to add a custom property. Anyone knows this guid? Any tips/hints greatly welcomed, Thanks, -Victor.

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

Postby mark.tenholder » Fri, 20 May 2005 03:04:47 GMT

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?


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)



Return to Visual Studio .Net

 

Who is online

Users browsing this forum: No registered users and 83 guest