SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Error:

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'

Continue reading SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Determine DLLs hosted by Process

tasklist /m /fi "IMAGENAME eq wmiprvse.exe"

/M     [module]         Lists all tasks currently using the given
exe/dll name. If the module name is not
specified all loaded modules are displayed.

/FI    filter           Displays a set of tasks that match a
given criteria specified by the filter.

If you want DLL's hosted by any/all processes, remove the /FI filter parameter. In the example, we list dll's in use by the WMIPRVSE services.

Another example might be;

tasklist /m /fi "IMAGENAME eq cmd.exe"

You can filter on many different items, such as PID. Below we list dll's used by the SYSTEM process.

tasklist /m /fi "pid eq 4"

UDP Client Testing

There are many applications that use UDP ports in operation. When firewalls are in place, it can be difficult to determine if the problem connecting is due to the firewall, or simply the application.

The attached files can help with this.

udpserv.ps1 is a quick PowerShell script that will listen on a defined port for incoming UDP data and display the received data on the screen.

To use the udpserv.ps1 script;

  •  Change $port = 2020 to the port you want to test.
  • Open a PowerShell window.
  • Change to script download location
  • Execute script by typing ".\udpserv.ps1" and process enter. The script will block until complete.

The client script udpclient.ps1 will connect to the defined port on the defined server and will send 10 lines indicating the iteration of the UDP test.

To use the udpclient.ps1 script;

  • Change the $IP = "10.0.0.1" line to match the IP of the system running udpserv.ps1.
  • Change the [int] $Port = 2020 to match the port specified in the udpserv.ps1 script above.
  • Open a PowerShell window.
  • Change to script download location
  • Execute script by typing ".\udpclient.ps1" and process enter.

You can download the udptest.zip file which contains the client and server scripts.

WordPress Error Table ‘alertadigital.wp_wc_follow_users’ doesn’t exist

If you receive an error message like

Apache — Redirect all HTTP requests to HTTPS

This post describes the process of forcing all HTTP traffic to HTTPs.

If we all lived in a perfect world, there would be no need for security. However, we don't, so there is.

One way you can help increase the security of your site and therefore your data, is to only implement ssl protocol in the server, or to block non ssl traffic via the firewall.

Continue reading Apache — Redirect all HTTP requests to HTTPS