Simple db-problem

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
}
}Lasse Edsvik wrote:
> 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,
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?
"Hans Kesting" <news.2.hansdk@.spamgourmet.com> wrote in message
news:uXjIzVWoEHA.3556@.TK2MSFTNGP10.phx.gbl...
> Lasse Edsvik wrote:
> 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 wrote:
> 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
> "Hans Kesting" <news.2.hansdk@.spamgourmet.com> wrote in message
> news:uXjIzVWoEHA.3556@.TK2MSFTNGP10.phx.gbl...
Hans Kesting wrote:
> Lasse Edsvik wrote:
> 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...stringtopic.asp
Hans Kesting