Solved

VB.NET - Unable to find connection

Posted on 2008-10-08
2
1,453 Views
Last Modified: 2013-11-26
I get "Unable to find connection 'TMMConnectionString' for object 'MySettings'.
 The connection string could not be found in application settings, or the data provider
 associated with the connection string could not be loaded. "

I've looked at the .xsd file in the XML Editor, and I have the code snippet attached here  I only have this one connection string.  When I run the program, everything works just fine!  But when I try to update the queries or add any columns, etc. in the .xsd DataSet Designer, I get the error.  I've also attached the screenshot of the error.  Any ideas?
<Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="TMMConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="TMMConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TMM.My.MySettings.GlobalReference.Default.TMMConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>

Open in new window

screenshot.gif
0
Comment
Question by:redmission
2 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 22685875
That are the configurations for the dataset and how about the configurations for the MySettings ? Check the app.config file in the connectionStrings if you have that one.
0
 
LVL 1

Accepted Solution

by:
k3m earned 500 total points
ID: 22687574
If you right click on blue bar of OLP_LCTNS and select configure. Select previous then previous you should see the dropdown for the connection string.

Or
right click on blue bar of OLP_LCTNS and select view code which will display the .xsd file change or add the connection string

<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="myConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="myConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.myConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB.NET 2008 Populate DataModel with DataTable 44 31
VB.Net - TypeInitializer Error 25 28
How do you do a one to many list in .NET CORE? 2 28
SQL LINE CONTINUATION ISSUE 12 33
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question