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.
but I get the error attached. why?
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=CBRHKMA;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";" ... s = "delete from [ODBC;Description=TEST;DRIVER=SQL Server;" _ & "SERVER=PC336_W7_HKMA;Trusted_Connection=Yes;" _ & "DATABASE=CBRHKMA].T41 " _ & "where [Reporting Date]=convert(datetime,'" & Mid(strLine, pos0, 8) & "',112)" ...
Join the community of 500,000 technology professionals and ask your questions.