I have created an SSIS package to transfer data from MySQL to PostgreSQL, and it is working fine on my local system. However, when I try to deploy the package to a SQL Server and schedule a job, it fails to establish a connection with the PostgreSQL…
Please, help, Does "EnableBulkLoad" parameter (maybe under a different name) exist for ODBC PostgreSQL driver?
Watched ODBC driver(version 11.0) from https://www.postgresql.org/ftp/odbc/versions/src/ and can't find in docs about this…
I'm making a Flask application that is using sqlalchemy as a layer between the application and a postgres database. Currently I'm using a 'config.py' file that fetches the sensible connection info from system variables. But my IT admin says it's not…
I'm trying to connect oracle to postgreSQL via db link. Is there any option to disable AutoCommit in Postgresql ODBC?
odbc.ini looks like
[PG]
Description = PG
Driver = /usr/lib64/psqlodbc.so
ServerName = xxxxx
Username = authenticator
Password =…
Command
update invoice set unpaid = unpaid - 123
where regexp_replace(invocienumber, '-.*', '', 'g') ='12345'
returning *
updates all invoices whose number start with 12345.
How to fix this so than only one invoice is updated and get back…
Is it possible to create a DBLink from Oracle 11G which is running on AIX 7.1 to PostgreSQL? I couldn't find postgresql-odbc for AIX.
Oracle 11G - AIX 7.1
PostgreSQL 9.3.5 - Linux
Thanks for advance.
Sometimes strange duplicate key error
duplicate key value violates unique constraint "session_pkey"
Key (workplace)=(WIN-N9BSKUNKBC8 ) already exists.
Occurs in script:
delete from session where workplace='WIN-N9BSKUNKBC8' ;
INSERT INTO session…
recently we have upgraded our postgres db to version 13.1.
after that we are facing strange behaviour with Connection Strings
with PostgresSql 12.3 below command used to connect successfully to DB with out prompting for password
**postgres=#…
Already asked the question here but it was falsely marked as closed.
I use psqlODBC and PowerQuery to load data from a PostgreSQL (12.4) to Microsoft Excel. Recently I am having performance issues I cannot explain. Some of the functions take…
I have the following query:
SELECT "factures"."id"
FROM "factures"
WHERE ( "factures"."id" NOT IN (SELECT DISTINCT( "echeances"."facture_id" )
FROM "echeances"
WHERE …
During the PSQL.exe launch I am asked for my account password. After providing the password the tool just closes with no error message or indication of what went wrong.
My account has full admin privileges and regardless of if I run the tool with…
Using old Postgres server
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit
Server has symlinks server.crt and server.key in data directory /var/lib/postgresql/9.1./main and ssl=true in…
Visual FoxPro application calls Postgres psqlodbc driver 9.3.0400
Both are 32 bit application running in Windows 7 x64
This call causes Buffer Ovverrun exception in psqlodbc35w.dll with stack trace below.
How to fix the issue ? psqlodbc is open…
select room_id,count (distinct(patient_id)) as patient_id
from patient_flow where time='CURRENT_TIME';
I need the number of patients ids with corresponding room_ids at the current time.
id | patient_id | room_id | …