Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub A() Call oAppend(Now, "yet more", 45) End Sub Public Sub oAppend(ByVal oDate As Date, ByVal oText As String, ByVal oNumber As Single) Dim oSQL As String On Error GoTo EH Set con = New ADODB.Connection con.Open "Provider=SQLOLEDB;Data Source=196.220.411.247,1235;Network Library=DBMSSOCN;Initial Catalog=test;User ID=nmomashhjjk;Password=nnnmmm222;" Set cmd = New ADODB.Command 'Check last ID --------------------------- Dim oSQL_lastID As String oSQL_lastID = "SELECT MAX(ID) FROM Table1" Dim Last_ID_Recordset As Variant Dim Last_ID_Integer As Integer Dim Next_ID_Recordset As Variant Dim Next_ID_Integer As Integer Dim intID As String With cmd .CommandText = oSQL_lastID .CommandType = adCmdText .ActiveConnection = con '.Execute Last_ID_Recordset = .Execute() 'this line returns a recordset Last_ID_Integer = Last_ID_Recordset(0) End With
Join the community of 500,000 technology professionals and ask your questions.