MySQL & .NET: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0

Question

I wanted to use SubSonic as it said it would be easy to use and a time saver.

After 3 hours trying to get the connection string for MySQL right I'm about to give up on it.

Building configuration from C:\Documents and Settings\user\My Documents\Visual Studio 2

008\Projects\ConfigurationItems\ConfigurationItemsMVC\Web.config
Adding connection to MySqlDataProvider
ERROR: Trying to execute generate
Error Message: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.

I can't shift this: Error Message: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.

I get it every time I try and run subsonic.exe /generate

IT ALL LOOKED SO EASY!!!

Here is my Web.Config

<!-- connectionString="Persist Security Info=False;database=config;server=localhost;user id=config;Password=config" -->
  <connectionStrings>
    <remove name="ConfigConnectString"/>
    <add name="ConfigConnectString" connectionString="Persist Security Info=False;database=config;server=localhost;user id=userid;Password=password" providerName="MySql.Data.MySqlClient"
      />
    </connectionStrings>

  <SubSonicService defaultProvider="ConfigDatabase">
      <providers>
        <add type="SubSonic.MySqlDataProvider, SubSonic" 
             name="MySqlDataProvider" 
             generatedNamespace="Config" 
             connectionStringName="ConfigConnectString" 
             />

      </providers>
  </SubSonicService>

I've tried a few things:

Specifying path to webconfig using /config on the external tool path.
Downgrading from the 6.0 .NET MySQL connector to the latest 5.2 version in line with samples.
Adding MySQL.Data as a reference direct from the SubSonic folder to the DLL in there.
Trying various formats for the connection string, based off http://www.connectionstrings.com/mysql#28

( other connection string: "Server=localhost;Database=config;Uid=user;Pwd=password;"- also "blah" / "anything" throws the same error...)

No joy! Very close to giving up on SubSonic. Please help if you can!

Btw I am using Subsonic 2.2

leonigmig · Accepted Answer · 2009-04-30 12:25:18Z

7

I'm an idiot:

 <SubSonicService defaultProvider="ConfigDatabase">

Should be:

 <SubSonicService defaultProvider="MySqlDataProvider">

Doh!

answered Apr 30, 2009 at 12:25

leonigmig

2,7463 gold badges25 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

leppie · Accepted Answer · 2009-04-30 11:35:13Z

1

I guess it expects a '{0}' somewhere, as that is the error you get when you forget (IIRC).

answered Apr 30, 2009 at 11:35

leppie

118k18 gold badges201 silver badges300 bronze badges

3 Comments

leonigmig Over a year ago

do you mean the string '{0}', within the connection string?

leppie Over a year ago

Yes, you are probably supplying it, or it is looking for that.

leonigmig Over a year ago

I had fudged the default provider class - I suppose that was changing the format of the string somewhere down the line and not providing a '{0}' under the bonnet somewhere!

MONET · Accepted Answer · 2011-06-29 06:39:16Z

1

Check this Blog for More Information about Format Of the Initialization string

http://menononnet.wordpress.com/2008/02/23/format-of-the-initialization-string-does-not-conform-to-specification-starting-at-index-0/

answered Jun 29, 2011 at 6:39

MONET

111 bronze badge

Collectives™ on Stack Overflow

MySQL & .NET: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related