Need Help connection String

[Justnew]

Hei All

Can some body help me here: I have a database name Customers, I a
trying to connect to SQL server through vb.net using asp.net webform.
I want to connect to the server programatically this is my connectio
string:

Private strsql As String
Private strconnection As String = "data source=localhos t;initia
catalog=Custome rs;integrated security=SSPI;p ersist securit
info=False;work station id=localhost;pa cket size=4096"

Public Function newCustomer(ByV al Fornavn As String, ByVal Etternav
As String, ByVal Adresse As String, ByVal PostNr As String, ByVa
PostSted As String, ByVal Telefon As String, ByVal Epost As String
ByVal Kjønn As String) As String
strsql = "exec NyKunde '" & Fornavn & "','" & Etternavn & "','
& Adresse & "','" & PostNr & "','" & PostSted & "','" & Telefon & "','
& Epost & "','" & Kjønn & "'"
Dim conn As SqlConnection = New SqlConnection(s trconnection)
conn.Open()
Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Try
com.ExecuteNonQ uery()
Catch e As SqlException
MsgBox(strsql)
MsgBox(e.ToStri ng)
Throw (e)
Finally
conn.Close()

End Try

End Function

I have use this same method with Windows application, but this does no
seems to work on web application

when I run this application I am getting the following error
Server Error in '/Customers' Application.
--------------------------------------------------------------------------------

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution o
the current web request. Please review the stack trace for mor
information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: SQL Server doe
not exist or access denied.

Source Error:
Line 13:
Line 14: Dim conn As SqlConnection = Ne
SqlConnection(s trconnection)
Line 15: conn.Open()
Line 16: Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Line 17:
Source File: c:\inetpub\wwwr oot\Customers\d b.vb Line: 15

Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionStrin
options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Customers.db.Re gNyKunde(String Fornavn, String Etternavn, Strin
Adresse, String PostNr, String PostSted, String Telefon, String Epost
String Kjønn) in c:\inetpub\wwwr oot\Customers\d b.vb:15
Customers.WebFo rm1.leggtilKund e() i
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :57
Customers.WebFo rm1.btnsubmit_C lick(Object sender, EventArgs e) i
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :62
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St rin
eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandle
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain(

Justne
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message346156.htm

[Mark Fitzpatrick]

Don't use localhost. Try using (local) instead keeping the paranthases ().

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"Justnew" <Ju************ @mail.mcse.ms> wrote in message
news:Ju******** ****@mail.mcse. ms...

Hei All

Can some body help me here: I have a database name Customers, I am
trying to connect to SQL server through vb.net using asp.net webform.
I want to connect to the server programatically this is my connection
string:

Private strsql As String
Private strconnection As String = "data source=localhos t;initial
catalog=Custome rs;integrated security=SSPI;p ersist security
info=False;work station id=localhost;pa cket size=4096"

Public Function newCustomer(ByV al Fornavn As String, ByVal Etternavn
As String, ByVal Adresse As String, ByVal PostNr As String, ByVal
PostSted As String, ByVal Telefon As String, ByVal Epost As String,
ByVal Kjønn As String) As String
strsql = "exec NyKunde '" & Fornavn & "','" & Etternavn & "','"
& Adresse & "','" & PostNr & "','" & PostSted & "','" & Telefon & "','"
& Epost & "','" & Kjønn & "'"
Dim conn As SqlConnection = New SqlConnection(s trconnection)
conn.Open()
Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Try
com.ExecuteNonQ uery()
Catch e As SqlException
MsgBox(strsql)
MsgBox(e.ToStri ng)
Throw (e)
Finally
conn.Close()

End Try

End Function

I have use this same method with Windows application, but this does not
seems to work on web application

when I run this application I am getting the following error
Server Error in '/Customers' Application.
-------------------------------------------------------------------------- ------
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: SQL Server does
not exist or access denied.

Source Error:
Line 13:
Line 14: Dim conn As SqlConnection = New
SqlConnection(s trconnection)
Line 15: conn.Open()
Line 16: Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Line 17:
Source File: c:\inetpub\wwwr oot\Customers\d b.vb Line: 15

Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Customers.db.Re gNyKunde(String Fornavn, String Etternavn, String
Adresse, String PostNr, String PostSted, String Telefon, String Epost,
String Kjønn) in c:\inetpub\wwwr oot\Customers\d b.vb:15
Customers.WebFo rm1.leggtilKund e() in
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :57
Customers.WebFo rm1.btnsubmit_C lick(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :62
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o
stBackEvent(Str ing eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()
Justnew
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message346156.html

[Michael Ramey]

try this connectionstrin g

"SERVER=localho st;DATABASE=Cus tomers;Integrat ed Security=SSPI;p ersist
security info=False;pack et size=4096"

Also, where is the SQL Server you are trying to connect to?

I hope it is local on the machine you are running this code from
"localhost" , and I hope it doesn't have an instance name. If it is local,
open the Service Manager in your system tray, and replace localhost with
whatever is says in the "Server" field

HTH,
--Michael

"Justnew" <Ju************ @mail.mcse.ms> wrote in message
news:Ju******** ****@mail.mcse. ms...

Hei All

Can some body help me here: I have a database name Customers, I am
trying to connect to SQL server through vb.net using asp.net webform.
I want to connect to the server programatically this is my connection
string:

Private strsql As String
Private strconnection As String = "data source=localhos t;initial
catalog=Custome rs;integrated security=SSPI;p ersist security
info=False;work station id=localhost;pa cket size=4096"

Public Function newCustomer(ByV al Fornavn As String, ByVal Etternavn
As String, ByVal Adresse As String, ByVal PostNr As String, ByVal
PostSted As String, ByVal Telefon As String, ByVal Epost As String,
ByVal Kjønn As String) As String
strsql = "exec NyKunde '" & Fornavn & "','" & Etternavn & "','"
& Adresse & "','" & PostNr & "','" & PostSted & "','" & Telefon & "','"
& Epost & "','" & Kjønn & "'"
Dim conn As SqlConnection = New SqlConnection(s trconnection)
conn.Open()
Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Try
com.ExecuteNonQ uery()
Catch e As SqlException
MsgBox(strsql)
MsgBox(e.ToStri ng)
Throw (e)
Finally
conn.Close()

End Try

End Function

I have use this same method with Windows application, but this does not
seems to work on web application

when I run this application I am getting the following error
Server Error in '/Customers' Application.
-------------------------------------------------------------------------- ------
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: SQL Server does
not exist or access denied.

Source Error:
Line 13:
Line 14: Dim conn As SqlConnection = New
SqlConnection(s trconnection)
Line 15: conn.Open()
Line 16: Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Line 17:
Source File: c:\inetpub\wwwr oot\Customers\d b.vb Line: 15

Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Customers.db.Re gNyKunde(String Fornavn, String Etternavn, String
Adresse, String PostNr, String PostSted, String Telefon, String Epost,
String Kjønn) in c:\inetpub\wwwr oot\Customers\d b.vb:15
Customers.WebFo rm1.leggtilKund e() in
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :57
Customers.WebFo rm1.btnsubmit_C lick(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :62
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o
stBackEvent(Str ing eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain()
Justnew
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message346156.html

[Justnew]

Thank you for the reply I have replace the instance name as exactly a
it is in the service manager, now when I tried to run the applicatio
this error Iam receiving. I have used mix mode in the authention

Server Error in '/Customers' Application.
--------------------------------------------------------------------------------

Login failed for user 'NT AUTHORITY\NETWO RK SERVICE'.
Description: An unhandled exception occurred during the execution o
the current web request. Please review the stack trace for mor
information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: Login failed fo
user 'NT AUTHORITY\NETWO RK SERVICE'.

Source Error:
Line 13:
Line 14: Dim conn As SqlConnection = Ne
SqlConnection(s trconnection)
Line 15: conn.Open()
Line 16: Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Line 17:
Source File: c:\inetpub\wwwr oot\Customers\d b.vb Line: 15

Stack Trace:
[SqlException: Login failed for user 'NT AUTHORITY\NETWO RK SERVICE'.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionStrin
options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Customers.db.Re gNyKunde(String Fornavn, String Etternavn, Strin
Adresse, String PostNr, String PostSted, String Telefon, String Epost
String Kjønn) in c:\inetpub\wwwr oot\Customers\d b.vb:15
Customers.WebFo rm1.leggtilKund e() i
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :57
Customers.WebFo rm1.btnsubmit_C lick(Object sender, EventArgs e) i
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :62
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St rin
eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandle
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
System.Web.UI.P age.ProcessRequ estMain


Michael Ramey wrote:

*try this connectionstrin g

"SERVER=localho st;DATABASE=Cus tomers;Integrat e
Security=SSPI;p ersist
security info=False;pack et size=4096"

Also, where is the SQL Server you are trying to connect to?

I hope it is local on the machine you are running this code from
"localhost" , and I hope it doesn't have an instance name. If it i
local,
open the Service Manager in your system tray, and replace localhos
with
whatever is says in the "Server" field

HTH,
--Michael

"Justnew" <Ju************ @mail.mcse.ms> wrote in message
news:Ju******** ****@mail.mcse. ms...

Hei All

Can some body help me here: I have a database name Customers, I am
trying to connect to SQL server through vb.net using asp.ne

webform.

I want to connect to the server programatically this is m

connection

string:

Private strsql As String
Private strconnection As String = "data source=localhos t;initial
catalog=Custome rs;integrated security=SSPI;p ersist security
info=False;work station id=localhost;pa cket size=4096"

Public Function newCustomer(ByV al Fornavn As String, ByVa

Etternavn

As String, ByVal Adresse As String, ByVal PostNr As String, ByVal
PostSted As String, ByVal Telefon As String, ByVal Epost A

String,

ByVal Kjønn As String) As String
strsql = "exec NyKunde '" & Fornavn & "','" & Etternavn & "','"
& Adresse & "','" & PostNr & "','" & PostSted & "','" & Telefon

"','"

& Epost & "','" & Kjønn & "'"
Dim conn As SqlConnection = New SqlConnection(s trconnection)
conn.Open()
Dim com As SqlCommand = New SqlCommand(strs ql, conn)
Try
com.ExecuteNonQ uery()
Catch e As SqlException
MsgBox(strsql)
MsgBox(e.ToStri ng)
Throw (e)
Finally
conn.Close()

End Try

End Function

I have use this same method with Windows application, but this doe

not

seems to work on web application

when I run this application I am getting the following error
Server Error in '/Customers' Application.

--------------------------------------------------------------------------
------

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution

of

the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Sql Client.SqlExcep tion: SQL Server

does

not exist or access denied.

Source Error:
Line 13:
Line 14: Dim conn As SqlConnection = New
SqlConnection(s trconnection)
Line 15: conn.Open()
Line 16: Dim com As SqlCommand = New SqlCommand(strs ql,

conn)

Line 17:
Source File: c:\inetpub\wwwr oot\Customers\d b.vb Line: 15

Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction )

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString

options, Boolean& isInTransaction )
System.Data.Sql Client.SqlConne ction.Open()
Customers.db.Re gNyKunde(String Fornavn, String Etternavn, String
Adresse, String PostNr, String PostSted, String Telefon, String

Epost,

String Kjønn) in c:\inetpub\wwwr oot\Customers\d b.vb:15
Customers.WebFo rm1.leggtilKund e() in
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :57
Customers.WebFo rm1.btnsubmit_C lick(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\Customers\W ebForm1.aspx.vb :62
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e)

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP o
stBackEvent(Str ing

eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument)
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection

postData)

System.Web.UI.P age.ProcessRequ estMain()
Justnew

------------------------------------------------------------------------

Posted via http://www.mcse.ms

------------------------------------------------------------------------

View this thread: http://www.mcse.ms/message346156.html
*

Justnew
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message346156.html