Troubleshooting

• "is not usable for indexed lookups due to unsupported collating sort order SortOrder"
• Python Virtual Env - VS Code - .venv Terminal "Activate.ps1 cannot be loaded"
• Ways to test port connections & ports occupied by Windows services

"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 library.

Workaround: 

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

Reference: 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

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 > type settings.json > Add the below lines

"terminal.integrated.profiles.windows": {
  "PowerShell": {
    "source": "PowerShell",
    "icon": "terminal-powershell",
    "args": ["-ExecutionPolicy", "Bypass"]
  }
},
"terminal.integrated.defaultProfile.windows": "PowerShell",

Restart VS Code

https://stackoverflow.com/questions/56199111/visual-studio-code-cmd-error-cannot-be-loaded-because-running-scripts-is-disabl/67420296#67420296 

Ways to test port connections & ports occupied by Windows services

Test Port Connection

Powershell

Host Port

 

Test-NetConnection localhost -Port 9010 

    - OR -

New-Object System.Net.Sockets.TcpClient("localhost", 80)

 

Find out the port occupied by which application / service

 

 

1. Find out the process ID

Netstat -aon | findstr [port]

 

2. Find the application name by PID

Tasklist | findstr [pid]