0

So, I realize that there are a lot of questions on here pertaining to this problem, but none seem to be the same as to what I'm dealing with. I had to delete my dataset out of visual studio and bring it back in. After doing so I got the error. I'm using mysql as a backend, so I'm using the dotconnect for mysql extension for visual studio. Everything was working fine until I did this step. Here is my app.config file:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="RMSteel.My.MySettings.RMSteelConnectionString" connectionString="User Id=rmsteel;Password=password;Host=192.168.0.46;Database=RMSteel;Persist Security Info=True"
            providerName="Devart.Data.MySql" />
    </connectionStrings>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>

    </startup>
</configuration>

Whenever I use my connection I use the name RMSteel.My.MySettings.RMSteelConnectionString, since this is auto-generated (I assume by dotconnect). I am fairly far in this project and would like to find a fix using this connection string, so I don't have to rewrite that much. Thanks for any help, and if you'd like me to post more code, I can.

comfroels
  • 109
  • 1
  • 8
  • Like I said as well, this connection string was working fine, until I redid my dataset – comfroels Apr 08 '14 at 17:53
  • Just reading through my files trying to figure this out. Should there be a build option set for the Settings.settings file? – comfroels Apr 08 '14 at 18:17
  • Trying to work this out, in my first form that loads, this works: – comfroels Apr 09 '14 at 14:12
  • `MsgBox(RMSteel.My.Settings.RMSteelConnectionString)` – comfroels Apr 09 '14 at 14:12
  • `Me.EmployeeTableAdapter.Fill(Me.RMSteelDataSet.Employee)` and this doesn't – comfroels Apr 09 '14 at 14:13
  • So, I narrowed it down to a tableadapter issue. When I comment out the tableadapter.fill the form loads and works correctly (it uses a couple queries to log people in). But when the next form loads that has a table adapter it throws the same error. – comfroels Apr 09 '14 at 15:43

0 Answers0