Click here to Skip to main content
15,920,596 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Registering an exe as a service. [modified] Pin
draghu20-May-09 20:01
draghu20-May-09 20:01 
GeneralRe: Registering an exe as a service. Pin
Dave Kreskowiak27-May-09 1:36
mveDave Kreskowiak27-May-09 1:36 
GeneralRe: Registering an exe as a service. Pin
draghu27-May-09 2:41
draghu27-May-09 2:41 
GeneralRe: Registering an exe as a service. Pin
draghu26-May-09 23:36
draghu26-May-09 23:36 
GeneralRe: Registering an exe as a service. Pin
Dave Kreskowiak27-May-09 1:33
mveDave Kreskowiak27-May-09 1:33 
GeneralRe: Registering an exe as a service. Pin
draghu27-May-09 2:43
draghu27-May-09 2:43 
GeneralRe: Registering an exe as a service. Pin
Dave Kreskowiak27-May-09 11:58
mveDave Kreskowiak27-May-09 11:58 
QuestionServer Connectivity if no server exist Pin
pdnet18-May-09 3:57
pdnet18-May-09 3:57 
Hi All,
I am using vb.net 3.5 and Sql Server 2005

There is no problem with connection if Server Name and Database Name Exist.
But the Error occurs when Try to connect the server which is not available. then my application goes hang. It is continue Searching.
I'm using :

Public Sub ConnectConfig(ByVal DSource As String, Optional ByVal Uid As String = "", _
Optional ByVal Pwd As String = "", _
Optional ByVal InCat As String = "", _
Optional ByVal AuthType As String = "")

Dim ConnString As String = ""

If FrmConfigSetup.cbAuth.SelectedIndex = 0 Then
ConnString = "Data Source=" & DSource & ";Initial Catalog=" & InCat & ";Integrated Security=True;Timeout=60;" & ""
Else
ConnString = "Data Source=" & DSource & ";Initial Catalog=" & InCat & ";Uid=" & Uid & ";Pwd=" & Pwd & ";Timeout=60;"
End If

SQLConn = New SqlClient.SqlConnection(ConnString)

If SQLConn.State = ConnectionState.Open Then
SQLConn.Close()
SQLConn.Open()
Else
SQLConn.Open()
End If
End Sub

when it'sTrying to open the connection then goes hang.

So, What can I do , please help me.

Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)

AnswerRe: Server Connectivity if no server exist Pin
Dave Kreskowiak18-May-09 8:54
mveDave Kreskowiak18-May-09 8:54 
AnswerRe: Server Connectivity if no server exist Pin
Samir Ibrahim19-May-09 4:35
Samir Ibrahim19-May-09 4:35 
QuestionExcel column formatting issue, format style changed when formatted again with the same style Pin
BREdwards18-May-09 3:36
BREdwards18-May-09 3:36 
AnswerRe: Excel column formatting issue, format style changed when formatted again with the same style Pin
Johan Hakkesteegt19-May-09 3:06
Johan Hakkesteegt19-May-09 3:06 
QuestionCompare 2 Excel Sheets Pin
vijay248218-May-09 3:25
vijay248218-May-09 3:25 
AnswerRe: Compare 2 Excel Sheets Pin
dan!sh 18-May-09 4:08
professional dan!sh 18-May-09 4:08 
QuestionHow to merge columns Pin
Pankaj Garg18-May-09 0:20
Pankaj Garg18-May-09 0:20 
AnswerRe: How to merge columns Pin
Dave Kreskowiak18-May-09 1:52
mveDave Kreskowiak18-May-09 1:52 
QuestionBackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa17-May-09 23:38
Sonhospa17-May-09 23:38 
AnswerRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak18-May-09 4:06
mveDave Kreskowiak18-May-09 4:06 
QuestionRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 9:11
Sonhospa18-May-09 9:11 
AnswerRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak18-May-09 10:01
mveDave Kreskowiak18-May-09 10:01 
NewsRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 10:12
Sonhospa18-May-09 10:12 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak18-May-09 13:13
mveDave Kreskowiak18-May-09 13:13 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 20:14
Sonhospa18-May-09 20:14 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak19-May-09 17:14
mveDave Kreskowiak19-May-09 17:14 
NewsRe: BackgroundWorkers 'RunWorkerCompleted' not fired - Resolved Pin
Sonhospa18-May-09 10:53
Sonhospa18-May-09 10:53 

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.