AnsweredAssumed Answered

Can't connect to SQL Server 2008 using it string...

Question asked by Sierra Moveis on Feb 10, 2011
Latest reply on Feb 11, 2011 by Raghavendra Bhagavan.S.M



In an EPDM Add-in I tried to connect to SQL Server 2008 using the following code:


Private Sub ConectaSQLServer()
        'Define variaveis para conexao
        Dim server As String = "serverName"
        Dim userId As String = "userID"
        Dim password As String = "password"
        Dim dataBase As String = "table"


        Dim strConn As String = "Data Source=" + server + ";" + "Initial Catalog=" + dataBase + ";" + _
                                "User ID=" + userId + ";" + "Password=" + password


        sqlConn = New SqlConnection(strConn)


        Catch ex As Exception

        End Try
End Sub


The program was compiled in a computer with Windows XP 32 bits

It program works well in computers with XP 32 bits

But I have one computer with Windows 7 64 bits where it code doesn't work

I get an error message:


System.Data.SqlClient.SqlException (0x80131904):

A network-related or instance-specific error ocurred

while establishing a connection to SQL Server.
The server was not found or was not accessible.


What I have to do to correct this?