Hi,

I would like to report an anoying little bug. I've just spent 1 hour spotting the differences and finaly came up with the answer. I should have seen it earlier but was completely blinded by the fact that I wanted to see the problem in the connectionstring. The problem however was in a missing 'provider' attribute in the Domain tag.

The unclear exception 'Object reference not set to an instance of an object' mislead me completely.

Causes exception:

<domain name="Default" upgradeMode="Recreate"
        connectionString="Data Source=DIARTIS-SQL1\SQL2008;Initial Catalog=PaulsDB02;Persist Security Info=True;User ID=klib;Password=xxxxxxxxxxx;MultipleActiveResultSets=True" >

Runs fine:

<domain name="Default" upgradeMode="Recreate" provider="sqlserver"
        connectionString="Data Source=DIARTIS-SQL1\SQL2008;Initial Catalog=PaulsDB02;Persist Security Info=True;User ID=klib;Password=xxxxxxxxxxx;MultipleActiveResultSets=True" >

Regards Paul Sinnema Diartis AG

Updated at 08.06.2010 7:42:24

Bump

Updated at 20.06.2010 6:38:08

Hi,

Just noticed that the examples that are generated in the App.config and Web.config files for a new project also miss the provider. That's how the error was created in the first place (I took the example for 'sqlserver' and did not use the ConnectionUrl but changed it to ConnectionString). Aha, I probably don't need the provider when I use a ConnectionUrl? That would explain the confusion I guess.

Regards Paul Sinnema Diartis AG

This thread was imported from our support forum. The original discussion may contain more detailed answer.