Simple db-problem

[Lasse Edsvik]

Hello

Anyone know why i get:

Exception Details: System.ArgumentException: Format of the initialization
string does not conform to specification starting at index 0.

Line 14: OleDbConnection conn = new OleDbConnection("ConnectionString");


Web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Data Source=127.0.0.1,1433;Network
Library=DBMSSOCN;Initial Catalog=northwind;User ID=sa;Password="/>
</appSettings>
<system.web>
</system.web>
</configuration>


code:

using System;

using System.Data;

using System.Data.OleDb;

namespace dbtest

{

/// <summary>

/// Summary description for WebForm1.

/// </summary>

public class WebForm1 : System.Web.UI.Page

{

private void Page_Load(object sender, System.EventArgs e)

{

OleDbConnection conn = new OleDbConnection("ConnectionString");

OleDbCommand cmd = new OleDbCommand("SalesByCategory",conn);

cmd.CommandType = CommandType.StoredProcedure;

// do stuff

conn.Close();

// Put user code to initialize the page here

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}


/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

}

}

 

[Hans Kesting]

Hello

Anyone know why i get:

Exception Details: System.ArgumentException: Format of the
initialization string does not conform to specification starting at
index 0.

Line 14: OleDbConnection conn = new
OleDbConnection("ConnectionString");

You supply the string "ConnectionString" as connection string, and that is
*not* the correct format
You want this:
OleDbConnection conn = new OleDbConnection(
ConfigurationSettings.AppSettings["ConnectionString"]);

By the way, you seem to connect to SqlServer. There are specific classes
tuned for SqlServer! (SqlConnection, SqlCommand etc)

Hans Kesting

 

[Lasse Edsvik]

Hans,

Ok, i'll try with sqlclasses, but i still get same error


and when i type ConfigurationSettings i dont get any methods or properties.
whats missing?

Hello

Anyone know why i get:

Exception Details: System.ArgumentException: Format of the
initialization string does not conform to specification starting at
index 0.

Line 14: OleDbConnection conn = new
OleDbConnection("ConnectionString");

You supply the string "ConnectionString" as connection string, and that is
*not* the correct format
You want this:
OleDbConnection conn = new OleDbConnection(
ConfigurationSettings.AppSettings["ConnectionString"]);

By the way, you seem to connect to SqlServer. There are specific classes
tuned for SqlServer! (SqlConnection, SqlCommand etc)

Hans Kesting

Web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Data
Source=127.0.0.1,1433;Network Library=DBMSSOCN;Initial
Catalog=northwind;User ID=sa;Password="/> </appSettings>
<system.web>
</system.web>
</configuration>


code:

using System;

using System.Data;

using System.Data.OleDb;

namespace dbtest

{

/// <summary>

/// Summary description for WebForm1.

/// </summary>

public class WebForm1 : System.Web.UI.Page

{

private void Page_Load(object sender, System.EventArgs e)

{

OleDbConnection conn = new OleDbConnection("ConnectionString");

OleDbCommand cmd = new OleDbCommand("SalesByCategory",conn);

cmd.CommandType = CommandType.StoredProcedure;

// do stuff

conn.Close();

// Put user code to initialize the page here

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}


/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

}

}

 

[Hans Kesting]

Hans,

Ok, i'll try with sqlclasses, but i still get same error


and when i type ConfigurationSettings i dont get any methods or
properties. whats missing?

add this to the top of the class file:
using System.Configuration;

then it should work

Hans Kesting

Hello

Anyone know why i get:

Exception Details: System.ArgumentException: Format of the
initialization string does not conform to specification starting at
index 0.

Line 14: OleDbConnection conn = new
OleDbConnection("ConnectionString");

You supply the string "ConnectionString" as connection string, and
that is *not* the correct format
You want this:
OleDbConnection conn = new OleDbConnection(
ConfigurationSettings.AppSettings["ConnectionString"]);

By the way, you seem to connect to SqlServer. There are specific
classes tuned for SqlServer! (SqlConnection, SqlCommand etc)

Hans Kesting

 

[Hans Kesting]

add this to the top of the class file:
using System.Configuration;

then it should work

Hans Kesting

Just an additional note: when you use the sql-specific classes, you need
to change the connection string! Look up the SqlConnection.ConnectionString
property in MSDN: (watch out for wrap)
http://msdn.microsoft.com/library/d...ntsqlconnectionclassconnectionstringtopic.asp

Hans Kesting