How many networks does clustering need ?

I know there is a public network for all application communication and one
for hearbeat .
Are there any more ?
Does one connect the hearbeat network to like a local hub for the nodes or
to the same public network ( dont know if im stating this right) ? Whats
best practise to set up the private hearbeat ?But networks, I am assuming you mean network cards on the server. It is
recommend two; one for the Live check and one for public traffic on the node.
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Hassan" wrote:
> I know there is a public network for all application communication and one
> for hearbeat .
> Are there any more ?
> Does one connect the hearbeat network to like a local hub for the nodes or
> to the same public network ( dont know if im stating this right) ? Whats
> best practise to set up the private hearbeat ?
>
>
>

How Many IP(Public & Private) Required for 2 Node Active/Passive Cluster

Hi all,

I have some doubt about the IP Required for configuring cluster(both Window and SQL server)

Details :
-
How Many IP(Public & Private) Required for 2 Node Active/Passive both window and SQL server Cluster ?
IP(Public & Private) Required :

1 : For Window Clustering : 2 node Active/Passive Cluster ? How many ip ?
2 : For Sql Server Clustering : 2 node Active/Passive Cluster ?how many ip ?
3 : Is there any mathematics for that ? How to analyse the IP requirement ?

Thanks

Hi all,

Can u plz.....

sql

How Many IP(Public & Private) Required for 2 Node Active/Passive Cluster

Hi all,

I have some doubt about the IP Required for configuring cluster(both Window and SQL server)

Details :
-
How Many IP(Public & Private) Required for 2 Node Active/Passive both window and SQL server Cluster ?
IP(Public & Private) Required :

1 : For Window Clustering : 2 node Active/Passive Cluster ? How many ip ?
2 : For Sql Server Clustering : 2 node Active/Passive Cluster ?how many ip ?
3 : Is there any mathematics for that ? How to analyse the IP requirement ?

Thanks

Hi all,

Can u plz.....

how make public sql connection

hi,
i want to make a sql connection for a simple application
but i want to use this same connection in the application i have 10 forms in
application so i want in all forms.
after i make setup i can i should change the server name and password.
so if this possible please tell me about this in details.
thanks.
mitesh
This connection works well for me:
Sub InsertData()
Dim oConn As Object
Dim sSQL As String
Application.ScreenUpdating = False
Set wsSheet = ActiveWorkbook.Sheets("Product Tracking")
Set oConn = CreateObject("ADODB.Connection")
oConn.Open = "Provider=sqloledb;" & _
"Data Source=xx.x.xx.xx;" & _
"Initial Catalog=xxx_xxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
sSQL = "INSERT INTO Upload_Specific " & _
"([Location], [Product Type], [Quantity], [Product Name], [Style],
[Features]) " & _
" VALUES ('" & Range("A2").Value & "', '" & Range("B2").Value & "', '" &
Range("C2").Value & "', '" & Range("D2").Value & "', '" & Range("E2").Value
& "', '" & _
Range("F2").Value & "')"
oConn.Execute sSQL
oConn.Close
Set oConn = Nothing
End Sub
HTH
"mitesh" <mitesh@.discussions.microsoft.com> wrote in message
news:F5513C08-228E-4AE5-A5CC-A8AA574DA6DB@.microsoft.com...
> hi,
> i want to make a sql connection for a simple application
> but i want to use this same connection in the application i have 10 forms
> in
> application so i want in all forms.
> after i make setup i can i should change the server name and password.
> so if this possible please tell me about this in details.
> thanks.
> mitesh

how make public sql connection

hi,
i want to make a sql connection for a simple application
but i want to use this same connection in the application i have 10 forms in
application so i want in all forms.
after i make setup i can i should change the server name and password.
so if this possible please tell me about this in details.
thanks.
miteshThis connection works well for me:
Sub InsertData()
Dim oConn As Object
Dim sSQL As String
Application.ScreenUpdating = False
Set wsSheet = ActiveWorkbook.Sheets("Product Tracking")
Set oConn = CreateObject("ADODB.Connection")
oConn.Open = "Provider=sqloledb;" & _
"Data Source=xx.x.xx.xx;" & _
"Initial Catalog=xxx_xxx;" & _
"User Id=xxxx;" & _
"Password=xxxx"
sSQL = "INSERT INTO Upload_Specific " & _
"([Location], [Product Type], [Quantity], [Product Name], &#
91;Style],
[Features]) " & _
" VALUES ('" & Range("A2").Value & "', '" & Range("B2").Value & "', '" &
Range("C2").Value & "', '" & Range("D2").Value & "', '" & Range("E2").Value
& "', '" & _
Range("F2").Value & "')"
oConn.Execute sSQL
oConn.Close
Set oConn = Nothing
End Sub
HTH
"mitesh" <mitesh@.discussions.microsoft.com> wrote in message
news:F5513C08-228E-4AE5-A5CC-A8AA574DA6DB@.microsoft.com...
> hi,
> i want to make a sql connection for a simple application
> but i want to use this same connection in the application i have 10 forms
> in
> application so i want in all forms.
> after i make setup i can i should change the server name and password.
> so if this possible please tell me about this in details.
> thanks.
> mitesh