# Troubleshooting

# "is not usable for indexed lookups due to unsupported collating sort order SortOrder"

When using some sort of software or you are working on some projects with Microsoft Access, this error may occurs because of the known limitation of [Jackcess ](https://jackcess.sourceforge.io/)library.

Workaround:

- Change the "New database sort order" to "General" (or "General - Legacy").

<div class="separator" id="bkmrk--1" style="clear:both;text-align:center;">[![h8gLW.png](https://i.stack.imgur.com/h8gLW.png)](https://i.stack.imgur.com/h8gLW.png)</div>Reference: [https://stackoverflow.com/questions/27893630/unsupported-collating-sort-order-error-updating-access-database-from-java](https://stackoverflow.com/questions/27893630/unsupported-collating-sort-order-error-updating-access-database-from-java)

[https://stackoverflow.com/questions/31948096/how-to-change-sortorder-to-avoid-unsupported-collating-sort-order-error/31972659#31972659   ](https://stackoverflow.com/questions/31948096/how-to-change-sortorder-to-avoid-unsupported-collating-sort-order-error/31972659#31972659)

# Python Virtual Env - VS Code - .venv Terminal  "Activate.ps1 cannot be loaded"

 This is caused by execution policy of PowerShell.

We can fix it by adding "-ExecutionPolicy Bypass" in settings.json.

Ctrl + Shift + P &gt; type **settings.json** &gt; Add the below lines

```javascript
<span class="hljs-string">"terminal.integrated.profiles.windows"</span>: {
  <span class="hljs-string">"PowerShell"</span>: {
    <span class="hljs-string">"source"</span>: <span class="hljs-string">"PowerShell"</span>,
    <span class="hljs-string">"icon"</span>: <span class="hljs-string">"terminal-powershell"</span>,
    <span class="hljs-string">"args"</span>: [<span class="hljs-string">"-ExecutionPolicy"</span>, <span class="hljs-string">"Bypass"</span>]
  }
},
<span class="hljs-string">"terminal.integrated.defaultProfile.windows"</span>: <span class="hljs-string">"PowerShell"</span>,
```

Restart VS Code

```
<a href="https://www.blogger.com/"><code class="hljs language-javascript">https://stackoverflow.com/questions/56199111/visual-studio-code-cmd-error-cannot-be-loaded-because-running-scripts-is-disabl/67420296#67420296 </code></a>
```

# Ways to test port connections & ports occupied by Windows services

#### Test Port Connection

Powershell

<span style="background-color:rgb(255,164,0);">Host</span> <span style="background-color:rgb(111,168,220);">Port</span>

Test-NetConnection <span style="background-color:rgb(255,164,0);">localhost </span>-Port <span style="background-color:rgb(111,168,220);">9010</span>

<span> </span>- OR -

New-Object System.Net.Sockets.TcpClient("<span style="background-color:rgb(255,164,0);">localhost</span>", <span style="background-color:rgb(111,168,220);">80</span>)

#### Find out the port occupied by which application / service

####  

![ZwVhMj1.png](https://i.imgur.com/ZwVhMj1.png)

1\. Find out the process ID

Netstat -aon | findstr \[port\]

2\. Find the application name by PID

Tasklist | findstr \[pid\]