[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

VB.NET - Unable to find connection

Posted on 2008-10-08
2
Medium Priority
?
1,647 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:Jorge Paulino
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 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Suggested Courses

590 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