Operating system produced by Microsoft. Windows is produced in various desktop and server versions.

learn more… | top users | synonyms

0
votes
1answer
98 views

MySQL installation and data location on Windows

I'm gonna install MySQL 5.5 in a virtual Windows Server. I'd like to have the data in an separate partition (it may be in a different virtual disk) than the system one. I'm considering two options: ...
0
votes
1answer
165 views

Converting dbo file from windows to linux

I have a .dbo file which is created from windows. This file is succesfully reloaded into the mysql database in windows. I need to reload the dbo file into the mysql/mariadb database in linux. How I ...
0
votes
1answer
726 views

How can I enable my-huge file on windows server?

I installed Windows Server 2008 and MySQL 5.5. Now I need configure MySQL for huge InnoDB tables and a lot of connections. I see that on my Windows Server, there is a my-huge file(configs files that ...
0
votes
1answer
1k views

Is there an easy way to debug and find out why a query runs slow?

I'm running onto a weird issue. We've got two db servers, one is development and the other one is production. Both have same specs. VMs (Hyper-V) Windows Server 2008 R2 64 Bit SQL Server 2008 R2 64 ...
0
votes
1answer
83 views

can I copy-paste SQL Server 2005 Express on XP Pro or Vista machine and make it work without installer?

I am having installer problems on several machines trying to install SQL Server Express 2005 Express as well as later versions (but I would be happy with 2005 anyway). However, I do have one machine ...
0
votes
1answer
25 views

Postgresql: When using SSH tunnel, I receive the fe_sendauth: no password supplied error

I am SSH Tunneling to my postgreql server. I have previously successfully configured 9 + win XP dev PCs to connect to this postgresql server, those PCs still connect successfully. I am now setting up ...
0
votes
1answer
21 views

remote connection to mysql

have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db here is my connection string used in PC#2: SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = ...
0
votes
2answers
32 views

mysqldump with automatically generated export name

When I do database dumps through MySQL WorkBench it picks a filename for me which is the current date (YYYMMDD). Now, I want to do this in a batch file since I want to make weekly dumps automatically ...
0
votes
0answers
30 views

How to run different MySQL-statements with parameters in a loop using Powershell 2.0?

I am new to Powershell and would like to do the following in a shell script: 1.) read some filenames out of an file with filenames 2.) execute some SQL-statements for each file read Here's my code: ...
0
votes
1answer
27 views

In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?

In SQL*Plus, I try to run a script that is stored at a certain URL. From where I am currently, I can http(s) connect with the internet only via a proxy. So, if in SQL*Plus, I try ...
0
votes
1answer
47 views

Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine

I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
0
votes
0answers
52 views

PostgreSQL Install Error

When I install the server for the first time, when almost finished it reports: (from log file "%temp%\bitlock_installer1376.txt") Loading additional SQL modules... Executing cscript //NoLogo ...
0
votes
0answers
119 views

High availability PostgreSQL 9.3 server on Windows

I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
0
votes
0answers
51 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
0
votes
1answer
57 views

MySQL connection timeout error retrieving big results

All of the sudden our MySQL 5.6 server (on Windows server) started to give us this error: "Lost connection to server during query". We never had this problem before and we haven't touch MySQL config ...
0
votes
2answers
33 views

Mysql 5.5.25 must be restarted to connect

We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
0
votes
1answer
145 views

oracle XE on windows XP stopped working

I know this will be greeted with derision, but yes I'm running Oracle XE on Windows XP. Long story involving office policies and VMs. Actually it's been working fine for a couple of years, but today ...
0
votes
0answers
34 views

Converting MySQL 5.6.10 - 32 bit to 64 bit version

I am currently using MySQL DB Version 5.6.10 for 32 bit running in 64 bit Window OS.I want to change it to 64 bit without taking any dump..Can anyone help in this?
0
votes
1answer
226 views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
0
votes
0answers
33 views

Retrieving Column comments using MySQL ODBC driver

I am using the following function call to retrieve the REMARKS of a column of my MySQL table. SQLBindCol(st_handle,12, SQL_C_WCHAR,comment,512-1, &l); But comment is always an empty string.All ...
0
votes
0answers
184 views

Create a high availability cluster configuration PostgreSQL for Windows

I want a server to be replicated, here is the scenario: When my primary server goes down or fail I want the secondary or the standby server to take over, I'm using Windows 7 for the primary server, ...
0
votes
1answer
93 views

Windows Service Management Node Won't Start

I'm trying to set up a basic Cluster on my Win7 PC for testing. But I am stuck at the first hurdle. I have installed the Management Node as a Service: ...
0
votes
0answers
170 views

MySQL multi master replication with bi-directional synchronization advice

I need a solution to replicate data between multiple MySQL masters running on different platforms (Windows XP, 7 and Ubuntu Linux). I have found a replication tool (SymmetricDS) which supports this ...
0
votes
0answers
323 views

Oracle XE 11g on Windows 7 64bits

I have a problem with Oracle XE 11g on Windows 7 64. I know that a lot of people have the same problem but I did'nt find a solution for my case. In sqlnet.ora: with SQLNET.AUTHENTICATION_SERVICES = ...
0
votes
0answers
269 views

Export (mysqldump) databases from MySQL version 4.0?

I need to export the schema and data from a MySQL version 4.0.16 DB. I was asked to migrate a database from MySQL version 4.0.16. The database was installed on a Windows XP machine, and I could not ...
0
votes
0answers
293 views

PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”

I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
0
votes
0answers
89 views

Performance of large queries on low bandwidth connections

I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
0
votes
0answers
98 views

mysqlnd: same mysql server and php version, can't connect from Windows

(This question is also in StackOverflow http://stackoverflow.com/questions/16575994/mysqlnd-same-mysql-server-and-php-version-cant-connect-from-windows) I'm migrating mysql functions to mysqli. As ...
0
votes
0answers
18 views

Authenticate Oracle Database with Active Directory Users [duplicate]

I'm trying to connect to Oracle Database 11gR2 with the users from Active Directory. I'm looking at some resources/guidance on how to go about doing this successfully. The link Map Oracle Roles to ...
0
votes
1answer
349 views

I can't install db-mysql in node.js

When I execute this command: npm install db-mysql, I get the following result. What's the solution to this problem? C:\Users\Mouad>npm install db-mysql npm http GET https: ...
0
votes
0answers
523 views

Install PostgreSQL 9.2 on Windows using WIN1252 encoding.

I had installed PostgreSQL 9.2 earlier and it always installed with the encoding being WIN1252 (the default database was WIN1252). I then some time ago reinstalled it with the encoding being UTF8 (I ...
0
votes
0answers
67 views

Long disk queue when no traffic

I got dedicated disk (RAID 10 - 4 SAS disks) for Postgres. I am bit worried as recently, I see under Windows Resource Manager disk queues like 3+ in the mornings (low traffic hours), like every 30-60 ...
0
votes
1answer
1k views

Error when installing Oracle 11.2.0.3 in Windows Server 2008 R2 64 bits

I downloaded Oracle 11.2.0.3 installer: p10404530_112030_MSWIN-x86-64_1of7.zip p10404530_112030_MSWIN-x86-64_2of7.zip p10404530_112030_MSWIN-x86-64_3of7.zip p10404530_112030_MSWIN-x86-64_4of7.zip ...
0
votes
0answers
477 views

How to detect when did ocurre ORA-00604?

Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of ...
-1
votes
2answers
136 views

HP Vertica, can we install it on Windows & the SQL we use for oracle is same for the HP Vertica?

I am new to HP Vertica. I read the installation documentation for the HP Vertica. The documentation is totally based on the *ix environment. So, my question is Can we install HP Vertica on Windows ...
-1
votes
1answer
129 views

Restoring Oracle XE database

I had Oracle 10G XE installed on my Windows machine. The machine got corrupted and I will have to install Oracle again. I did not take a backup in the form of SQL queries. How can I use the old ...
-1
votes
0answers
30 views

the environment variables configuration for ORACLE EXPRESS 11g / windows7 32Bit

I can't connect in Oracle Express 11g (windows7 32-bit) and I think the problem comes from the environment variable ORACLE_SID & ORACLE_HOME , how can I get the database instance to do the right ...
-3
votes
1answer
246 views

Windows Server 2008 R2, Active Directory, and Oracle Database Server

I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server I Want to know how to make the configuration of the following Diagram in this link: ...
-8
votes
3answers
503 views

Wrong Last Modified Date of .ndf file on SQL Server [closed]

I have SQL Server Database and we have many tables. To improve performance, I have created different filegroups with files on different disks just for indexes. I have created new index today in a ...