Questions tagged [windows-10]
The windows-10 tag has no usage guidance.
22
questions with no upvoted or accepted answers
2
votes
0
answers
375
views
All but one of my SQL Server 2017 databases are GONE after Windows 10 nightly update failure
EDIT: Restored to a restore point from three days ago, prior to a "Critical Update", and the databases are back.
This is, I believe, the culprit update: September 10, 2019-KB4514601 Cumulative Update ...
- 435
2
votes
1
answer
856
views
Connection's MAC address randomly changes on Windows 10, then stops
Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications).
We do ...
- 1,342
1
vote
0
answers
33
views
Postgres - now to optimise a table for high frequency INSERTs?
I need to load data into a table as fast as possible. So far I've done the following.
Create the table UNLOGGED
Removed all indexes
Removed all triggers
Created the table in a tablespace on a SSD ...
- 1,065
1
vote
0
answers
376
views
SQL Server Management Studio compatible with Windows 10 32 bit
I'm running a VM with Windows 10 32 bit OS and I need to install SQL Server Management Studio.
The OS on my VM
OS Name: Microsoft Windows 10 Pro
OS Version: 10.0.19044 ...
- 159
1
vote
0
answers
1k
views
PostgreSQL: "PANIC: out of memory"
Got an error while running an application connected to a PostgreSQL DB (10.12). All the connections got disconnected, looking through the server logs, I found the below.
TopMemoryContext: 292488 ...
- 121
1
vote
0
answers
1k
views
ODBC from Win10 32bit client only connects using IP address, but not using hostname
I'm experiencing a pretty strange problem.
We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM.
Our ...
- 11
1
vote
0
answers
67
views
Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database
I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
- 11
1
vote
0
answers
680
views
PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709
The server itself runs fine with
pg_ctl -D <datadir> start
But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs")
...
- 121
1
vote
0
answers
772
views
How to run Oracle Client 10g from non Administrator account?
Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
- 11
1
vote
0
answers
119
views
How do install and configure Grid Infastructure on Windows>
I'm studying for the 1Z0-062 exam with John Watson's exam guide and I'm trying to install Grid Infrastructure alongside my Dbhome.
The book seems to run an installer that displays a configuration ...
- 11
1
vote
1
answer
444
views
SQL server memory pressure
First observed few months ago at end-user's laptop (rather slow i3 CPU, 4GB RAM, SSD) with SQL 2014 Express. The problem persists with SQL 2019, even with clean Windows 10 1903 installation.
The ...
- 111
0
votes
0
answers
58
views
What to do about "unable to write inside temp environment variable path" on Windows 10 for PostgreSQL
I get this error message when I try to install PostgreSQL on my Windows machine.
I tried all the provided solutions for solving this issue. I have uninstalled my McAfee antivirus as I wasn't using it ...
0
votes
0
answers
85
views
MariaDB ODBC connector connects to all databases indiscriminately
This is connector 3.3.4 (64-bit). OS is W10.
mariadb --version gives
"mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for Win64 (AMD64), source revision ..."
I wanted to set up an ODBC connector ...
- 111
0
votes
3
answers
277
views
Why PHPmyAdmin works on Windows 10 and not Windows 11?
I'm running Windows 11 and tried to install XAMPP on this machine. It installed Apache correctly, but when going to mySQL this appears:
I tried everything I found online to fix this problem in order ...
- 1
0
votes
1
answer
647
views
Failed to open file error 13 on Windows 10, mysql source command
Before this, I executed -u root -p command and it went through, but trying source always gives me this error. I tried running terminal as administrator, moving the source file location, and setting ...
0
votes
1
answer
168
views
MariaDB: How to install a second instance using MSI-Installer
I would like to install a second instance of MariaDB with MSI-Installer (Windows 10). The first instance is on drive C. When I want to install the second instance on drive D using MSI-Installer the ...
- 257
0
votes
0
answers
485
views
How can Postgres clusters be managed on a Windows EnterpriseDB of Postgres?
To clarify, I am using plain Postgres as packaged by EnterpriseDB (with StackBuilder), not EDB Postgres Advanced Server.
I'm familiar with using pg_lsclusters, pg_dropcluster, and pg_createcluster on ...
- 133
0
votes
0
answers
2k
views
Postgres is extremely slow through localhost, for any command
Postgres 13 in my Windows 10 machine is extremely slow. Even with Postgres shell, every single command needs 22 seconds to be executed. Either it is a single query in a nearly zero-rows DB, or a ...
0
votes
0
answers
148
views
What is the alternative of PL/Java for PostgreSQL 11 and 12?
Understand from: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/user-guide/11/EDB_Postgres_Advanced_Server_Guide.1.80.html
that PL/Java is deprecated in Advanced ...
- 1
0
votes
0
answers
476
views
Import table data using multiple sql file in psql
Local Machine(l1):
Windows 10
psql
Remote Machine(R1):
linux
EDB(postgres)
On my local I have 1000+ sql script containing insert statement . psql is also installed locally .
I need to run this sql ...
- 25
0
votes
0
answers
3k
views
Failed to add 'Admin user' to %2% user group in Oracle 19C Windows 10 installation
Oracle 19c installation fails with this error message.
I am trying to set up oracle for my 'Existing Local User' account
Installation logs tries to add Admin user to all groups and fails .it says ...
- 11
0
votes
0
answers
169
views
Sybase 8 to Sybase 16 migration in Windows 10 OS
Currently we are using Sybase 16 db in our project. But there are few Sybase 8 db's (that clients are using in market) that needs to converted to Sybase 16 for any patch testing. I used to use the ...
- 1