VS 2003 to VS 2005 problems

[Roy Gourgi]

Hi,

I just installed VS 2005 Express with SQL Server and when I try to run the
code that was working with VS 2003 is no longer working. Is it not backward
compatible. What has changed. Below is my code.

TIA
Roy

using System;

using System.Data;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN=900;

int lnBN1=188;

string strConnection = "Server=(local) ;Integrated
Security=yes;da tabase=royDB";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0, @par1)
";

SqlCommand cmd = new SqlCommand(strI nsert , conn);

SqlParameter parameter1 = new SqlParameter("@ par0",SqlDbType .Int,32);

SqlParameter parameter2 = new SqlParameter("@ par1",SqlDbType .Int,32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}

[Nicholas Paldino [.NET/C# MVP]]

Roy,

"not working" isn't really an apt description of the problem. Is it a
runtime error, a compilation error?

Some more insight would be greatly appreciated.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:S1******** ***********@wag ner.videotron.n et...

Hi,

I just installed VS 2005 Express with SQL Server and when I try to run the
code that was working with VS 2003 is no longer working. Is it not
backward compatible. What has changed. Below is my code.

TIA
Roy

using System;

using System.Data;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN=900;

int lnBN1=188;

string strConnection = "Server=(local) ;Integrated
Security=yes;da tabase=royDB";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0,
@par1) ";

SqlCommand cmd = new SqlCommand(strI nsert , conn);

SqlParameter parameter1 = new SqlParameter("@ par0",SqlDbType .Int,32);

SqlParameter parameter2 = new SqlParameter("@ par1",SqlDbType .Int,32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}

[Roy Gourgi]

Hi Nicholas,

Sorry about not being more specific. It's not a compile time error, as I
have it compiles without errors. It is a runtime error "SqlExcepti on was
unhandled" and the details are:

System.Data.Sql Client.SqlExcep tion was unhandled
Message="An error has occurred while establishing a connection to the
server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=2
Server=""
State=0
StackTrace:
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)
at System.Data.Sql Client.TdsParse r.Connect(Boole an&
useFailoverPart ner, Boolean& failoverDemandD one, String host, String
failoverPartner , String protocol, SqlInternalConn ectionTds connHandler,
Int64 timerExpire, Boolean encrypt, Boolean trustServerCert , Boolean
integratedSecur ity, SqlConnection owningObject, Boolean aliasLookup)
at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance)
at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance)
at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)
at
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Open()
at testing.Class1. Main(String[] args) in
D:\CSRBC\SQLSam ple\SQLSample\C lass1.cs:line 39
at System.AppDomai n.nExecuteAssem bly(Assembly assembly, String[]
args)
at System.AppDomai n.ExecuteAssemb ly(String assemblyFile, Evidence
assemblySecurit y, String[] args)
at Microsoft.Visua lStudio.Hosting Process.HostPro c.RunUsersAssem bly()
at System.Threadin g.ThreadHelper. ThreadStart_Con text(Object state)
at System.Threadin g.ExecutionCont ext.Run(Executi onContext
executionContex t, ContextCallback callback, Object state)
at System.Threadin g.ThreadHelper. ThreadStart()


Thanks
Roy

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:S1******** ***********@wag ner.videotron.n et...

Hi,

I just installed VS 2005 Express with SQL Server and when I try to run the
code that was working with VS 2003 is no longer working. Is it not
backward compatible. What has changed. Below is my code.

TIA
Roy

using System;

using System.Data;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN=900;

int lnBN1=188;

string strConnection = "Server=(local) ;Integrated
Security=yes;da tabase=royDB";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0,
@par1) ";

SqlCommand cmd = new SqlCommand(strI nsert , conn);

SqlParameter parameter1 = new SqlParameter("@ par0",SqlDbType .Int,32);

SqlParameter parameter2 = new SqlParameter("@ par1",SqlDbType .Int,32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}

[Thomas P. Skinner [MVP]]

You need to enable named pipes. Go to SQL Server 2005 Configuration Manager
and under protocols enable named pipes. That should fix the problem.

Tom Skinner [C# MVP]

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:Iw******** ***********@wag ner.videotron.n et...

Hi Nicholas,

Sorry about not being more specific. It's not a compile time error, as I
have it compiles without errors. It is a runtime error "SqlExcepti on was
unhandled" and the details are:

System.Data.Sql Client.SqlExcep tion was unhandled
Message="An error has occurred while establishing a connection to the
server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=2
Server=""
State=0
StackTrace:
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)
at System.Data.Sql Client.TdsParse r.Connect(Boole an&
useFailoverPart ner, Boolean& failoverDemandD one, String host, String
failoverPartner , String protocol, SqlInternalConn ectionTds connHandler,
Int64 timerExpire, Boolean encrypt, Boolean trustServerCert , Boolean
integratedSecur ity, SqlConnection owningObject, Boolean aliasLookup)
at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance)
at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserI nstance)
at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)
at
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Open()
at testing.Class1. Main(String[] args) in
D:\CSRBC\SQLSam ple\SQLSample\C lass1.cs:line 39
at System.AppDomai n.nExecuteAssem bly(Assembly assembly, String[]
args)
at System.AppDomai n.ExecuteAssemb ly(String assemblyFile, Evidence
assemblySecurit y, String[] args)
at Microsoft.Visua lStudio.Hosting Process.HostPro c.RunUsersAssem bly()
at System.Threadin g.ThreadHelper. ThreadStart_Con text(Object state)
at System.Threadin g.ExecutionCont ext.Run(Executi onContext
executionContex t, ContextCallback callback, Object state)
at System.Threadin g.ThreadHelper. ThreadStart()


Thanks
Roy

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:S1******** ***********@wag ner.videotron.n et...

Hi,

I just installed VS 2005 Express with SQL Server and when I try to run
the code that was working with VS 2003 is no longer working. Is it not
backward compatible. What has changed. Below is my code.

TIA
Roy

using System;

using System.Data;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN=900;

int lnBN1=188;

string strConnection = "Server=(local) ;Integrated
Security=yes;da tabase=royDB";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0,
@par1) ";

SqlCommand cmd = new SqlCommand(strI nsert , conn);

SqlParameter parameter1 = new SqlParameter("@ par0",SqlDbType .Int,32);

SqlParameter parameter2 = new SqlParameter("@ par1",SqlDbType .Int,32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}

[Roy Gourgi]

Hi Tom,

It didn't work?

Roy

"Thomas P. Skinner [MVP]" <to*@bu.edu> wrote in message
news:eY******** ******@TK2MSFTN GP15.phx.gbl...

You need to enable named pipes. Go to SQL Server 2005 Configuration
Manager and under protocols enable named pipes. That should fix the
problem.

Tom Skinner [C# MVP]

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:Iw******** ***********@wag ner.videotron.n et...

Hi Nicholas,

Sorry about not being more specific. It's not a compile time error, as I
have it compiles without errors. It is a runtime error "SqlExcepti on was
unhandled" and the details are:

System.Data.Sql Client.SqlExcep tion was unhandled
Message="An error has occurred while establishing a connection to the
server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does not allow
remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=20
LineNumber=0
Number=2
Server=""
State=0
StackTrace:
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection )
at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj)
at System.Data.Sql Client.TdsParse r.Connect(Boole an&
useFailoverPart ner, Boolean& failoverDemandD one, String host, String
failoverPartner , String protocol, SqlInternalConn ectionTds connHandler,
Int64 timerExpire, Boolean encrypt, Boolean trustServerCert , Boolean
integratedSecur ity, SqlConnection owningObject, Boolean aliasLookup)
at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance)
at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserI nstance)
at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options)
at
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Sql Client.SqlConne ction.Open()
at testing.Class1. Main(String[] args) in
D:\CSRBC\SQLSam ple\SQLSample\C lass1.cs:line 39
at System.AppDomai n.nExecuteAssem bly(Assembly assembly, String[]
args)
at System.AppDomai n.ExecuteAssemb ly(String assemblyFile, Evidence
assemblySecurit y, String[] args)
at
Microsoft.Visua lStudio.Hosting Process.HostPro c.RunUsersAssem bly()
at System.Threadin g.ThreadHelper. ThreadStart_Con text(Object state)
at System.Threadin g.ExecutionCont ext.Run(Executi onContext
executionContex t, ContextCallback callback, Object state)
at System.Threadin g.ThreadHelper. ThreadStart()


Thanks
Roy

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:S1******** ***********@wag ner.videotron.n et...

Hi,

I just installed VS 2005 Express with SQL Server and when I try to run
the code that was working with VS 2003 is no longer working. Is it not
backward compatible. What has changed. Below is my code.

TIA
Roy

using System;

using System.Data;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN=900;

int lnBN1=188;

string strConnection = "Server=(local) ;Integrated
Security=yes;da tabase=royDB";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0,
@par1) ";

SqlCommand cmd = new SqlCommand(strI nsert , conn);

SqlParameter parameter1 = new SqlParameter("@ par0",SqlDbType .Int,32);

SqlParameter parameter2 = new SqlParameter("@ par1",SqlDbType .Int,32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}

[Roy Gourgi]

Ok I no longer get the runtime error with this connection string but it
still does not insert a record in my database. Here is the code.

using System;

using System.Data;

using System.Data.Com mon;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN = 900;

int lnBN1 = 188;

string strConnection = @"Data
Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\royDB.m df;Integrated
Security=True;C onnect Timeout=30;User Instance=True";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0, @par1)
";

SqlCommand cmd = new SqlCommand(strI nsert, conn);

SqlParameter parameter1 = new SqlParameter("@ par0", SqlDbType.Int, 32);

SqlParameter parameter2 = new SqlParameter("@ par1", SqlDbType.Int, 32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}

"Roy Gourgi" <ro***@videotro n.ca> wrote in message
news:S1******** ***********@wag ner.videotron.n et...

Hi,

I just installed VS 2005 Express with SQL Server and when I try to run the
code that was working with VS 2003 is no longer working. Is it not
backward compatible. What has changed. Below is my code.

TIA
Roy

using System;

using System.Data;

using System.Data.Sql Client;

using System.Data.Sql Types;

using System.Text;

namespace testing

{

class Class1

{

[STAThread]

static void Main(string[] args)

{

int lnSOBN=900;

int lnBN1=188;

string strConnection = "Server=(local) ;Integrated
Security=yes;da tabase=royDB";

SqlConnection conn = new SqlConnection(s trConnection);

string strInsert = "INSERT INTO [tblRoy ] (SOBN, BN1) VALUES (@par0,
@par1) ";

SqlCommand cmd = new SqlCommand(strI nsert , conn);

SqlParameter parameter1 = new SqlParameter("@ par0",SqlDbType .Int,32);

SqlParameter parameter2 = new SqlParameter("@ par1",SqlDbType .Int,32);

parameter1.Valu e = lnSOBN;

parameter2.Valu e = lnBN1;

cmd.Parameters. Add(parameter1) ;

cmd.Parameters. Add(parameter2) ;

cmd.Connection. Open();

cmd.ExecuteNonQ uery();

cmd.Connection. Close();

}

}

}