Tag Info

New answers tagged

0

Based on the current release driver release compatibility matrix, found here, if you want to support Netezza NPS v6.0, v6.1, and v7.2 with the same ODBC driver, you should pick the most recent patch of the 7.1 ODBC driver. If you don't need to have the same driver support all three server levels, then you would likely be better off going with the most ...


0

Make sure PostgreSQL Server is allowed through the firewall: On the server machine, go to Control Panel > System and Security > Windows Firewall > Allow an app through Windows Firewall Scroll through Allowed apps and features, make sure 'PostgreSQL Server' is checked.


1

STEP 01 : Open Windows CLI as Administrator and Shutdown MySQL net stop mysql STEP 02 : Copy the Data to D:\ProgramData\Data xcopy /s C:\ProgramData\MySQL\MySQL Server 5.6\data D:\ProgramData\Data STEP 03 : Create or edit C:\ProgramData\MySQL\MySQL Server 5.6\my.ini Add this to the my.ini [mysqld] datadir = D:/ProgramData/Data STEP 04 : Startup ...


3

Install the psql client (I believe it's in the pgAdminIII install). Add it to your PATH. Put the following in %appdata%\postgresql\pgpass.conf (you may need to create that file): hostname:port:database:username:password In cmd: psql -c "\copy (select * from foo) to 'someLocalFile.txt';" then someLocalFile.txt will be a tab-delimited representation of ...


1

The best way to copy a result set into a file is through COPY. i.e.: COPY (SELECT ...) TO 'filename.csv'; To load the data, you can use the FROM clause. This command is Operating System agnostic, as it is a plain formatted text file.


0

I agree with Jithin R and ensuring the SQL Server "service" account (what you have set in the services.msc for the login as, and ensuring it has at least MODIFY or FULL permissions at the NTFS folder level where the MDF and LDF files are created when they code dynamically creates the DB). It sure sounds like an NTFS permission issue with whatever security ...


1

You need a recent CU for TLS1.2. See https://support.microsoft.com/en-us/kb/3052404: Cumulative Update 8 for SQL Server 2014 Cumulative Update 1 for SQL Server 2014 SP1 Cumulative Update 6 for SQL Server 2012 SP2 Cumulative Update 7 for SQL Server 2014 After enabling only TLS 1.2 you will possibly encounter two errors: SQL Server 2014 Agent will not ...


1

I've written the following script to install an en_us dictionary on Ubuntu 14.04 running PostgreSQL 9.4. It should be fairly easy to modify for most situations. #!/bin/bash cd /usr/share/postgresql/9.4/tsearch_data wget http://src.chromium.org/svn/trunk/deps/third_party/hunspell_dictionaries/en_US.dic wget ...



Top 50 recent answers are included