Solved

VB.NET - Unable to find connection

Posted on 2008-10-08
2
1,396 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now