Stack Overflow
Stack Overflow

Questions tagged [psqlodbc]

Open Database Connectivity middleware for PostgreSQL

Open Database Connectivity middleware for PostgreSQL

33 questions
12
votes
7 answers

Error when trying to migrate postgresql db to mysql with workbench

I am trying to migrate a postgresql database to mysql following this tutorial: http://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql-workbench-migration-wizard/ I am experiencing this error when I try to…
Brooks Fiala
  • 121
  • 1
  • 3
4
votes
5 answers

Connecting MS Access to PostgreSQL Server

I'm having trouble with connecting to our postgres server. I was given the code used to connect ms access to our SQL Server. It shall be DSN-less, I have installed an ODBC-driver and now I'm stuck finding the correct connection string to write in…
Puddingloeffel
  • 163
  • 2
  • 9
3
votes
1 answer

How to connect to PostgreSQL running in Docker container from local R?

I have a local Docker container running PostgreSQL. I want to be able to connect to and interact with this database from R running on my host machine (Mac OS). I can connect using pgadmin4 via the following address http://0.0.0.0:5434/browser/ then…
Camrin Braun
  • 51
  • 6
2
votes
1 answer

How to convert text number to integer type in psql query

I'm trying to run a query as such select * from mytable where to_number(minutesintext, '9999') >= 10; expected result: col1 | col2 | col3 | minutesintext ------------------------------------- a | b | c | 11 f | g | e | 98 But I'm…
Syabster
  • 99
  • 2
  • 9
2
votes
0 answers

How to use special charactes in psqlodbc driver password

In Postgres psqlodbc driver using special characters in connection string password like sqlstringconnect('DRIVER={PostgreSQL Unicode};PWD=pü') or in url encoded form sqlstringconnect('DRIVER={PostgreSQL Unicode};PWD=p%C3%BC') throws password…
Andrus
  • 26,339
  • 60
  • 204
  • 378
2
votes
0 answers

pyodbc connection issue with psqlodbc driver on osx

I'm trying to connect to my local postgres database via pyodbc(i'd like to use MySQL workbench to import/view a postgres schema eventually), and I can't seem to get anything to find my psqlodbc driver. I've brew install psqlodbc, and I have the…
heliotrope
  • 349
  • 2
  • 17
2
votes
1 answer

column values as column names in thepsql query

Based on this I have a table which has values which will be the column names of the PostgreSQL query result. id col1 col2 ---------------------- 0 name ax 0 name2 bx 0 name3 cx 1 name dx 1 name2 ex 1 …
user6145033
1
vote
1 answer

PostgreSQL ODBC (psqlodbc) Statement Timeout on ODBC Connection

I'm accessing a Postgres database via an ODBC connection string in an old program (HotDocs Document Assembly). This is the only way to access databases in HotDocs I keep getting an error with a query I'm running that takes more than 30 seconds to…
user2437443
  • 2,067
  • 4
  • 23
  • 38
1
vote
1 answer

Using PostgreSQL comments as descriptions in dbt docs

We've been adding comments to the columns in postgres as column descriptions. Similarly, there are descriptions in dbt that can be written. How would I go about writing SQL to automatically setting the same descriptions in postgres into dbt docs?
Mark
  • 105
  • 1
  • 5
1
vote
2 answers

Compiling psqlODBC on CENTOS 7 gives me errors in connection.c - undeclared identifiers

So i'm stuck again. What I want to do: access a postgreSQL database via database link from Oracle (12.1 - yes, I know it's old ...). Oracle is running on Centos 7. Initially I did a yum -y install postgresql-odbc yum -y install unixODBC and was…
sers
  • 3,139
  • 3
  • 20
  • 28
1
vote
1 answer

How to find biggest files in cluster

Postgres 13 cluster in Debian Linux server contains 30 databases. Databases contain number of schemas. How to find biggest files which occupy most space in disk ? I tried select relname::char(25), …
Andrus
  • 26,339
  • 60
  • 204
  • 378
1
vote
0 answers

Connect using PostgreSQL ODBC without driver installed

I tried to connect using PostgreSQL ODBC(psqlODBC 12.0) without the driver installed on Windows x64. I placed all the files below in a directory. They were extracted from a MSI…
Wakusei
  • 146
  • 3
  • 12
1
vote
2 answers

HSTMT, UCHAR, SDWORD meaning in ODBC Log

I have the following lines in my ODBC Log : (Scenario: pgAdmin4, using PostgreSQL server through ODBC32 in another application named System Administration) System Admi 6a0-6f8 ENTER SQLExecDirect HSTMT 0x00630718 UCHAR…
Anu Shibin Joseph Raj
  • 777
  • 10
  • 27
1
vote
0 answers

PSQL ODBC driver converts fixed point to floating point values on Windows 7 Enterprise PCs

Background We have a legacy windows application (developed in Clarion) that uses PostgreSQL 9.3 as the backend database. The application uses PostgreSQL ODBC 32-bit Driver(Unicode) 9.03.04 to interact with the database. All the users of the…
gowthamnvv
  • 279
  • 2
  • 6
1
vote
1 answer

Yocto recipe for the PostgreSQL ODBC and ARM platform

I'm trying to write BitBake unixodbc, postgresql, and psqlodbc recipes for ARM platform, to integrate with Yocto Project. First of all, I wrote custom BitBake recipes for unixodbc and postgresql. These recipes build and package libs and bins for the…
aicastell
  • 2,182
  • 2
  • 21
  • 33
1
2 3