SqlConnectionStringBuilder - String was not recognized as a valid Boolean

I am attempting to pass in a connection string to an SqlConnectionStringBuilder object, but I get the error: "String was not recognized as a valid Boolean", at runtime.

Here is the code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace SQLClientProj
{
  class Program
  {
    static void Main(string[] args)
    {
      string cstr = @"Data Source=(local)\SQLEXPRESS;Integrated Security=IIPS;Initial Catalog=Autos";

      SqlConnectionStringBuilder cbuilder = new SqlConnectionStringBuilder(cstr);

      ...

As far as I know, cstr is a string, so why SqlConnectionStringBuilder is complaining about expecting a boolean when it doesn't have a constructor which accepts such a type is beyond my understanding.

Any ideas?

Answers


Integrated Security=IIPS 

needs to be

Integrated Security=true

'IIPS' is not a boolean (true/false)

In a nutshell, the connection string is made up of property-value pairs,and the "Integrated Security" property specified in your string is expected to be true or false.

Look down at the "Integrated Security" section on this page:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx


Need Your Help

Weird y-position offset using custom frag shader (Cocos2d-x)

c++ opengl-es cocos2d-x cocos2d-x-3.0

I'm trying to mask a sprite so I wrote a simple fragment shader that renders only the pixels that are not hidden under another texture (the mask). The problem is that it seems my texture has its

java check if jar was launched from command line or explorer

java user-interface command-line jar

Is there a way to check if the jar was launched from command line via 'java -jar test.jar' or via double click in explorer?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.