Click here to Skip to main content
15,890,399 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionhow to edit string using .net with c# Pin
sugunavathysubramanian18-Apr-08 22:31
sugunavathysubramanian18-Apr-08 22:31 
AnswerRe: how to edit string using .net with c# Pin
Krazy Programmer19-Apr-08 0:21
Krazy Programmer19-Apr-08 0:21 
QuestionAccess label inside usercontrol on button click Pin
Niya18-Apr-08 22:18
Niya18-Apr-08 22:18 
GeneralPopup should not be blocked........ Pin
Deepak Nigam18-Apr-08 22:16
Deepak Nigam18-Apr-08 22:16 
GeneralRe: Popup should not be blocked........ Pin
Krazy Programmer19-Apr-08 0:19
Krazy Programmer19-Apr-08 0:19 
GeneralRe: Popup should not be blocked........ Pin
Deepak Nigam19-Apr-08 0:59
Deepak Nigam19-Apr-08 0:59 
GeneralRe: Popup should not be blocked........ Pin
varun.g19-Apr-08 0:56
varun.g19-Apr-08 0:56 
Questioncan login to remote sql server using SQL server managment Studio Express Pin
Meax18-Apr-08 22:12
Meax18-Apr-08 22:12 
but when i try to fetch records from remote sql server using those detail in connection string, i am getting this error

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)

This is the code i am using to connect to "Login" table in my database.

Private Sub GetAll()<br />
        Dim MyConnection As SqlConnection<br />
        Dim MyCommand As SqlDataAdapter<br />
<br />
        MyConnection = New SqlConnection("server=XXX.X.XXX.X;uid=X;pwd=X;database=X")<br />
<br />
        MyCommand = New SqlDataAdapter("select UserName, Password from Login", MyConnection)<br />
<br />
        ds = New DataSet<br />
<br />
        MyCommand.Fill(ds)<br />
<br />
        DataList1.DataSource = ds<br />
<br />
        DataList1.DataBind()<br />
    End Sub<br />


When this page is run, i want all the user's UserName and Password to be dispalyed.

However, i am getting the above mentioned error.

what could be the problem?
AnswerRe: can login to remote sql server using SQL server managment Studio Express Pin
Krazy Programmer19-Apr-08 0:19
Krazy Programmer19-Apr-08 0:19 
GeneralRe: can login to remote sql server using SQL server managment Studio Express Pin
Meax19-Apr-08 5:36
Meax19-Apr-08 5:36 
AnswerRe: can login to remote sql server using SQL server managment Studio Express Pin
~V~19-Apr-08 0:37
~V~19-Apr-08 0:37 
GeneralRe: can login to remote sql server using SQL server managment Studio Express Pin
Krazy Programmer19-Apr-08 0:38
Krazy Programmer19-Apr-08 0:38 
GeneralRe: can login to remote sql server using SQL server managment Studio Express Pin
Meax19-Apr-08 5:40
Meax19-Apr-08 5:40 
GeneralRe: can login to remote sql server using SQL server managment Studio Express Pin
Krazy Programmer19-Apr-08 6:32
Krazy Programmer19-Apr-08 6:32 
Questionhow to use tollbar Pin
sugunavathysubramanian18-Apr-08 21:56
sugunavathysubramanian18-Apr-08 21:56 
Answer[Message Deleted] Pin
vikramkharbanda19-Apr-08 0:32
vikramkharbanda19-Apr-08 0:32 
GeneralRe: how to use tollbar Pin
sugunavathysubramanian19-Apr-08 0:39
sugunavathysubramanian19-Apr-08 0:39 
GeneralRe: how to use tollbar Pin
vikramkharbanda19-Apr-08 0:47
vikramkharbanda19-Apr-08 0:47 
GeneralRe: how to use tollbar Pin
sugunavathysubramanian19-Apr-08 1:02
sugunavathysubramanian19-Apr-08 1:02 
GeneralColour change in gridview Pin
jeffrey kalampukattussery18-Apr-08 21:33
jeffrey kalampukattussery18-Apr-08 21:33 
GeneralRe: Colour change in gridview Pin
SekharOne18-Apr-08 23:15
SekharOne18-Apr-08 23:15 
Questionpattern for large master/detail hierarchies Pin
Member 420625118-Apr-08 21:16
Member 420625118-Apr-08 21:16 
QuestionIntroduction to WEB SERVICE??? Pin
Karan_TN18-Apr-08 20:36
Karan_TN18-Apr-08 20:36 
GeneralFckeditor query Pin
shiabcd18-Apr-08 20:24
shiabcd18-Apr-08 20:24 
QuestionHow to call Procedures from other forms in asp.net ? Pin
SekharOne18-Apr-08 20:22
SekharOne18-Apr-08 20:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.