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").
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]