Questions tagged [windows-10]

The tag has no usage guidance.

22 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
384 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 ...
Tim's user avatar
  • 545
2 votes
1 answer
904 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 ...
GSerg's user avatar
  • 1,352
1 vote
0 answers
51 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 ...
ConanTheGerbil's user avatar
1 vote
0 answers
513 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 ...
sergiom's user avatar
  • 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 ...
ChrisMM's user avatar
  • 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 ...
user3744122's user avatar
1 vote
0 answers
74 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 ...
Ejaz Sarwar's user avatar
1 vote
0 answers
709 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") ...
Gunnar's user avatar
  • 121
1 vote
0 answers
824 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 ...
Mayank's user avatar
  • 11
1 vote
0 answers
132 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 ...
user124864's user avatar
1 vote
1 answer
479 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 ...
Jan Zahradník's user avatar
0 votes
0 answers
205 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 ...
Hamza Farooq's user avatar
0 votes
0 answers
138 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 ...
mike rodent's user avatar
0 votes
3 answers
389 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 ...
Johann's user avatar
  • 1
0 votes
1 answer
1k 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 ...
Justin Kim's user avatar
0 votes
1 answer
274 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 ...
giordano's user avatar
  • 257
0 votes
0 answers
606 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 ...
Lee Hachadoorian's user avatar
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 ...
george lal's user avatar
0 votes
0 answers
159 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 ...
Jacky's user avatar
  • 1
0 votes
0 answers
511 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 ...
user236778's user avatar
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 ...
Aegon's user avatar
  • 11
0 votes
0 answers
176 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 ...
MgmtTech's user avatar