I am trying to access a database that is going to be located on a remote server, but i have no idea how to do it.
i tried this commands so far but they don't work:
Dim oSqlConn As New SqlConnection oSqlConn.ConnectionString = "Network Library=DBMSSOCN;" & _ "Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=mySQLServerDBName;" & _ "User ID=myUsername;" & _ "Password=myPassword" oSqlConn.Open()
Can anybody point me in the right direction please?
Thanks in advance