Unable to find connection 'MyConnName' for object 'Web.config' in Table Adapter configure Properties

Question

I want to change the query in table adapter but it's not opening & throwing an error "Configure table Adapter Failed" & in property of connectionString it says "Unable to find connection 'ConnStringName' for object 'Web.config'. The connection string could not be found in application settings, or the data provider associated with the connection string could not be loaded"

the same solution is showing connectionstring & opening the configure at another system but not at mine. — ksrds, Oct 18 '16 at 07:06
If the following solutions didn't work, this is another solution that might be helpful https://stackoverflow.com/a/53578441/2946329 — Salah Akbari, Dec 06 '18 at 06:24

score 12 · Accepted Answer · answered Sep 21 '17 at 21:15

I have been looking for a solution for this problem for a long time. Thankfully I found a solution that worked for me.

Close the dataset window with the error.
Right click the dataset in the solution explorer.
Select “Open with…” from the context menu.
Select “Source Code (Text) Editor” from the list and press the “OK” button.

Near the top of the file, you’ll see a element with several elements within it. Most datasets should only have one element. If you are having trouble like I’ve described above, you’ll have at least two and one will be incorrect. Delete it or otherwise fix it, save the file and reopen normally.

This is the page where I found it out. See the complete answer here

Thanks for your good answer. In addition we need to modify the DefaultConnectionIndex to be 0 — Mohammad Aldefrawy, Sep 14 '22 at 20:40

score 1 · Answer 2 · answered Sep 14 '22 at 20:38

I faced the same problem which is actually a nightmare and triyed Lorena solution and it was not enough to solve the problem. The missing part is to modify the Dataset using the XML editor changing the DefaultConnectionIndex to be 0 like this:

<DataSource DefaultConnectionIndex="0" 
FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, 
Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas- 
microsoft-com:xml-msdatasource">

thanks to Don who pointed this https://social.msdn.microsoft.com/Forums/windows/en-US/08a48cad-619d-4421-b584-f2b5550ba6c5/dataset-designer-quotunable-to-find-connection-myconn-mysettings1-for-object-mysettingsquot?forum=winformsdatacontrols

Alex Pashkin · Answer 3 · 2016-10-18T09:25:28.740

0

Seems like there no ConnStringName parameter in connectionString section of Web.config

<connectionStrings> 
    <add name="ConnStringName" providerName="" connectionString=""/>
</connectionStrings>

Updated: The problem is in missing reference to System.Data.OracleClient. To solve this just add reference on missing provider.

edited Oct 18 '16 at 09:25

answered Oct 18 '16 at 07:05

Alex Pashkin

301
4
15

I Have made the connectionstring like below.... same solution is working nicely at another system. ` ` But still I am not able to do. – ksrds Oct 18 '16 at 07:48
Have you added OracleClient reference to project? – Alex Pashkin Oct 18 '16 at 07:57
If problem is not in connection string, possible problem is missing reference to System.Data.OracleClient – Alex Pashkin Oct 18 '16 at 07:58
System.Data.OracleClient it was already present in the provider name in the webconfig file & as a reference in the solution too, but still I am unable to get the connection in any of the table adapter. – ksrds Oct 18 '16 at 10:39
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/126039/discussion-between-ksrds-and--). – ksrds Oct 18 '16 at 18:07

score 0 · Answer 4 · answered Apr 30 '20 at 08:17

Well Same problem I faced in Windows Forms, I just opened Settings.settings file, found the "ConnectionString" and repaired it. (As you click in Value field of ConnectionString a button [...] appears in last of Value field click it and repair/test your connection again, in my case I re-entered password again.) . Hope This Helps.!

score 0 · Answer 5 · answered Jul 05 '22 at 16:56

0

ConnStringName is case-sensitive.

answered Jul 05 '22 at 16:56

Jeff

1

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 06 '22 at 03:07

Unable to find connection 'MyConnName' for object 'Web.config' in Table Adapter configure Properties

5 Answers5

Linked