Search Discussions

3,520 discussions - 10,967 posts

  • I'm getting a bunch of compiler warnings when I compile the latest psqlodbc sources from CVS. I spent some time cleaning those up. I also got access to a report of a Coverity scan over psqlodbc ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 8, 2013 at 6:25 pm
    Jan 11, 2013 at 3:40 am
  • I have an MS Access app which connects to a PostgreSQL back end. I recently migrated the back end to PostgreSQL 9.x and upgraded the drivers on the Access client machine (Windows XP) from 8.x to ...
    Dave ManginelliDave Manginelli
    Dec 11, 2012 at 3:10 pm
    Dec 11, 2012 at 3:10 pm
  • Hello. I have a big data table. This table consist of 30 columns and 1000000 rows. I want to understand why the select of 100000 records in the psqlODBC performed 60 seconds. When i do this with ...
    Копыченко ПавелКопыченко Павел
    Dec 6, 2012 at 6:09 pm
    Dec 10, 2012 at 4:31 pm
  • Was a solution found to this? I have the same problem on a Windows 8 64 bit system. Identical symptoms.
    Tom EvansTom Evans
    Nov 17, 2012 at 7:52 pm
    Nov 20, 2012 at 11:06 pm
  • Hi Hiroshi and Petr (and others monitoring this thread), I appear have a similar problem to Petr. Details: Running Windows 8 64 bit Trying to connection to remote PostgreSQL database requiring SSL ...
    Tom EvansTom Evans
    Nov 17, 2012 at 2:17 pm
    Nov 17, 2012 at 2:17 pm
  • i try to use ODBC in centos 6.3 x64 and postgresql 9.1.3 . as soon as I remember ,odbc.ini and odbcinst.ini are created when I use unixodbc . how ever when I follow these steps ...
    Maziar NavahanMaziar Navahan
    Nov 12, 2012 at 9:55 am
    Nov 12, 2012 at 9:55 am
  • Hi! On an 8.4 installation, I have a table with a bytea column. In some rows, the value of this column has length 0. When I query that table with a normal SELECT, using the ODBC driver from C#, I get ...
    Nils GöscheNils Gösche
    Oct 29, 2012 at 5:58 pm
    Oct 30, 2012 at 2:18 pm
  • One of the employees here is having trouble connecting to a postgreSQL server, so while looking for the problem I opened Windows 7 control panel administrative tools Data Sources (ODBC) Drivers (tab) ...
    Fred ParkinsonFred Parkinson
    Oct 29, 2012 at 5:50 pm
    Oct 29, 2012 at 6:32 pm
  • At first week, I can `t even compile. But now I compiled it without errors. Then I built the installer. But during installation there is an error. Library not loaded. I want to get a full cycle from ...
    Копыченко ПавелКопыченко Павел
    Oct 15, 2012 at 2:04 pm
    Oct 16, 2012 at 11:56 pm
  • When I try to create a DSN with either PostgreSQL ANSI(x64) or PostgreSQL Unicode(x64) and click the "Finish" button, I get the error message "ODBC Administrator has stopped working". If I click on ...
    Edwin GrubbsEdwin Grubbs
    Oct 15, 2012 at 2:26 am
    Oct 16, 2012 at 10:05 pm
  • Hi Копыченко-san. sorry late reaction. Here is explanation of the build method. http://psqlodbc.projects.postgresql.org/win32-compilation.html however, VS2012 is referred to by the reason Microsoft ...
    Hiroshi SaitoHiroshi Saito
    Oct 14, 2012 at 6:52 am
    Oct 14, 2012 at 1:46 pm
  • I tried reporting this bug once before, but I hadn't subscribed to the pgsql-odbc list at that time and I think my emails must be permanently stuck in a spam filter limbo. Summary: When selecting a ...
    Daniel HomerickDaniel Homerick
    Oct 10, 2012 at 3:17 pm
    Oct 10, 2012 at 3:17 pm
  • Hi, I don't see the option to specify application name in the list at http://psqlodbc.projects.postgresql.org/config-opt.html. Is this something that will eventually be possible? Thanks, George
    George WeaverGeorge Weaver
    Sep 24, 2012 at 7:15 pm
    Sep 25, 2012 at 1:35 pm
  • Hello, I’m unable to make a connection using 64bit ODBC driver together with SSL. When I turn off SSL it works fine using 64bit version. When I use 32 bit ODBC with SSL it works fine as well. The ...
    Petr PateraPetr Patera
    Sep 11, 2012 at 11:00 am
    Sep 12, 2012 at 3:08 pm
  • Mandi! Hiroshi Saito In chel di` si favelave... As for 09.01.0100, driver works but if i try to open ODBC property windows i got a window, roughly translated from italian: odbcad23.exe - Damaged ...
    Marco GaiarinMarco Gaiarin
    Sep 7, 2012 at 1:17 pm
    Sep 10, 2012 at 1:01 pm
  • Hi, (2012/08/31 20:21), Boszormenyi Zoltan wrote: Does the DriverManager call both SQLError() and SQLGetDiagRec()? Could you send me (loop part of) the Mylog output? regards, Hiroshi Inoue
    Hiroshi InoueHiroshi Inoue
    Sep 1, 2012 at 9:20 am
    Sep 9, 2012 at 7:56 am
  • We are pleased to announce the release of psqlODBC 09.01.0200. For details of the changes in this release, please see the notes at: http://psqlodbc.projects.postgresql.org/release.html With this ...
    Hiroshi SaitoHiroshi Saito
    Aug 20, 2012 at 4:05 am
    Aug 27, 2012 at 6:22 pm
  • ODBC issue report from -bugs -------- Original Message -------- Subject: [BUGS] Small bug in psqlodbc-09.01 prevents interoperability with LISTSERV Date: Sat, 4 Aug 2012 15:43:58 +0000 From: Eric ...
    Craig RingerCraig Ringer
    Aug 8, 2012 at 1:16 am
    Aug 14, 2012 at 12:59 pm
  • Hi, I would like to report what seems like a problem with the driver. It doesn't seem possible to override the default user name for authentication by GSSAPI. I'm using a map in pg_ident.conf since ...
    John SlatteryJohn Slattery
    Aug 3, 2012 at 12:31 pm
    Aug 8, 2012 at 6:01 pm
  • Hello, we have some obscure problems accessing the database via ODBC driver PostgreSQL Unicode on Windows 7/x64 While accessing a table, i get the error *invalid UTF-8 byte sequence detected near ...
    Josef SpringerJosef Springer
    Aug 3, 2012 at 7:18 am
    Aug 5, 2012 at 6:58 am
  • Hello All, I am new to this mailing list and this is my first post :) I want to pass numeric data (2345) into a PostgreSQL BIT datatype column bit(1) using dynamic sql thru ODBC. I very much ...
    Ranjeeth kumarRanjeeth kumar
    Aug 2, 2012 at 7:25 am
    Sep 12, 2012 at 2:11 pm
  • The following query works in pgAdmin query tool but not when run within a java pgm. Don't see any postings with inet as the culprit type for the error. And yes the OR subclause is redundant. Didn't ...
    William FordWilliam Ford
    Jul 18, 2012 at 3:30 pm
    Jul 18, 2012 at 3:39 pm
  • Hi, I'm using a 9.0.2 db in a PowerBuilder 12.1 application, connecting to it via ODBC driver 09.00.0200. I have a table with a bytea column: CREATE TABLE docs ( =C2=A0 blobid character(7) NOT NULL, ...
    Andrea RicciAndrea Ricci
    Jul 17, 2012 at 2:46 pm
    Jul 18, 2012 at 12:44 pm
  • Hi, Currently the organization I work for uses psqlODBC, and we started to package all the 3rd party software we use: while some of our platforms need to be supported by us for longer periods than ...
    Nelson Manuel MarquesNelson Manuel Marques
    Jul 12, 2012 at 7:11 pm
    Jul 12, 2012 at 7:11 pm
  • Greetings, This message arises from LibreOffice bug report "SIGSEGV: ODBC to PostgreSQL, renaming column in SELECT list" <https://bugs.freedesktop.org/show_bug.cgi?id=50849 , but I shall try not to ...
    Terrence EngerTerrence Enger
    Jul 10, 2012 at 12:23 pm
    Jul 23, 2012 at 2:21 pm
  • Hi In centos 6.2 x64 with postgresql 9.1.4 x64 when I try to ./configure psqlodbc-09.01.0100 I get this error : PQconnectdb in -lpq... no configure: error: libpq library not found I think libpq has ...
    Maziar NavahanMaziar Navahan
    Jun 18, 2012 at 9:21 am
    Jun 22, 2012 at 12:17 pm
  • Hi, To use PostGreSQL with unixODBC in an application compiled as universal binary I try to build the unixODBC 2.2.12 version of unixODBC in a universal binary for i386 and ppc targeting OSX 10.3 ...
    Jun 17, 2012 at 8:42 am
    Jun 17, 2012 at 1:07 pm
  • * Ok I feel like a bit of a rubber ball. Microsoft saw this question and said "Great question go ask customer support at PostgreSQL. All I want is a simple answer to what I thought was a simple ...
    Della-Croce, GregoryDella-Croce, Gregory
    Jun 9, 2012 at 8:12 pm
    Jun 11, 2012 at 12:21 pm
  • Recently our postgresql servers were upgraded to 9. Also, our odbc drivers were upgraded to PostgreSQL ANSI Previously we used odbc PostgreSQL I am using MS Access 2003 as a ...
    Fred ParkinsonFred Parkinson
    Jun 6, 2012 at 7:36 pm
    Jun 6, 2012 at 7:36 pm
  • As a novice to Postgres I have a small problem. I ran the install of the ODBC Postgres drivers (psplodbc35w.dll), and I verified that the file exists. However when I go to the Data Source manager in ...
    Della-Croce, GregoryDella-Croce, Gregory
    Jun 5, 2012 at 5:13 pm
    Jun 6, 2012 at 12:05 am
  • I am new to PostgreSQL. I have a FoxPro application that currently accesses an Oracle database using the Microsoft ODBC Driver for Oracle. I am trying to convert it to access PostgreSql. So far I ...
    Christine JorgensenChristine Jorgensen
    Jun 5, 2012 at 1:30 pm
    Jun 5, 2012 at 7:08 pm
  • Hello everybody out there using psqlODBC, On Linux, Windows and Mac OS X 10.6, I could get psqlODBC working perfectly fine. However, on a Mac Mini with PowerPC running Mac OS X 10.4.11, isql fails to ...
    Julia JacobsonJulia Jacobson
    May 27, 2012 at 1:06 pm
    May 29, 2012 at 8:43 am
  • I'm attempting to compile and install this from source but I'm getting a "library not found" error: # ls -l /export/appl/pkgs/pgsql total 4 lrwxrwxrwx 1 root other 6 May 23 09:29 latest - v9.1.3 ...
    Joe TsengJoe Tseng
    May 23, 2012 at 1:56 pm
    May 23, 2012 at 2:19 pm
  • I am able to copy a row with a 127megabyte column, but not with one that is 399 megabytes. Here is the log output of the one that fails: [4272-42.487]SQL_VARBINARY: about to call convert_to_pgbinary, ...
    Michael VitaleMichael Vitale
    May 22, 2012 at 1:57 pm
    May 24, 2012 at 2:55 pm
  • Bugs item #1011196, was opened at 2012-05-21 21:57 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011196&group_id=1000125 Category: None Group: None Status: Open ...
    May 21, 2012 at 9:57 pm
    May 22, 2012 at 2:14 pm
  • I admit, nowadays an exotic szenario: Running a PostgreSQL client on an Windows 98 machine. The 9.1 pSQLOdbc Driver uses some Kernel32.DLL functions which were introduced with WindowsXP. such as ...
    May 8, 2012 at 11:38 am
    May 16, 2012 at 6:06 pm
  • Hello! How can I keep an OdbcDataAdapter from insisting on the fully qualified table name? In VS 2008, I am trying to use the System.Data.Odbc namespace to work with a PostGres database. I don't want ...
    Rob RichardsonRob Richardson
    Apr 25, 2012 at 2:06 pm
    Apr 25, 2012 at 3:12 pm
  • Hello, if 'Advanced Options' - 'OID Options' - 'Show Column' is activated ODBC function SQLColumns() retrieves one more row than expected if you use the function's filter ColumnName. If you check for ...
    Jan-Peter SeifertJan-Peter Seifert
    Apr 23, 2012 at 11:22 am
    Apr 23, 2012 at 11:22 am
  • I have a fairly straightforward routine which uses an ODBC connection to do 4 steps: * DROP TABLE IF EXISTS tmp_rxpurge * CREATE TABLE tmp_rxpurge (rxnum VARCHAR(300),dt_wrt DATE,dt_lastfill ...
    Ken BensonKen Benson
    Apr 11, 2012 at 10:01 pm
    Apr 13, 2012 at 3:22 pm
  • Using the lastest of ODBC ANSI driver for windows 32bit ver 9.00.03 Calling from MS VFP 9.0 public nvar as interger nvar=1 running the following sql: "( select function_pkg(?nvar) " The bind variable ...
    Barry BellBarry Bell
    Apr 9, 2012 at 2:35 pm
    Apr 13, 2012 at 10:28 pm
  • HI, I am very new to PostGreSql and ODBC but an 'expert' in Visual Foxpro. I wanted to try VFP as a client of PostGres. My laptop is under W7-64. I 'installed' the ODBC driver via Stack Builder. All ...
    Apr 8, 2012 at 4:13 pm
    Apr 8, 2012 at 7:45 pm
  • Hi, Since upgrading to PostgreSQL 9.1.2 and its psql-odbc driver (, the results of queries to arrays seems broken. I have an SQL 'items' column of type character(3)[]. A 'normal' SQL query ...
    Barend KöbbenBarend Köbben
    Mar 27, 2012 at 8:30 am
    Mar 31, 2012 at 3:04 pm
  • Bugs item #1010500, was opened at 28/10/2008 15:09 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&group_id=1000125 Category: None Group: None Status ...
    Mar 20, 2012 at 2:11 pm
    Mar 28, 2012 at 3:28 am
  • Has anyone managed to get the psqlodbc drivers to work with M$ Office (for Mac 11) on OS X? If I compile it and test with unixODBC the command line tools like isql work just fine, Office on the other ...
    Maton, BrettMaton, Brett
    Mar 19, 2012 at 6:33 am
    Sep 6, 2012 at 6:59 pm
  • Hi, Some time ago, We start to update our ODBC version. We are using Post 9.0.4(UTF) and ODBC Unicode (psqlodbc_09_01_0100-1) with use declare/fetch enable. One of my customeres have a routine thats ...
    Alexandre - Aldeia DigitalAlexandre - Aldeia Digital
    Mar 15, 2012 at 8:09 pm
    Apr 11, 2012 at 7:21 pm
  • What support does the current PG ODBC driver have for using client certificates for user authentication? Anyone have any experience with this? Thanks Blake Duffey
    Duffey, Blake A.Duffey, Blake A.
    Mar 14, 2012 at 5:10 pm
    May 4, 2012 at 4:54 pm
  • postgres db version: 8.3 driver version: 09 00 0200 MS Access: Office 2003 workstation: winXP I am trying to import a large table to MS Access. After selecting the table, and then ok, the import ...
    Jason TuttleJason Tuttle
    Mar 13, 2012 at 6:06 pm
    Mar 13, 2012 at 8:09 pm
  • We are getting this error when trying to open tables: ERROR :: ODBC--call failed :: Bindings were not allocated properly. (#15) postgres db version: 8.3 driver version: 09 00 0200 Jason Tuttle US ...
    Jason TuttleJason Tuttle
    Mar 12, 2012 at 5:52 pm
    Mar 13, 2012 at 3:00 pm
  • Hi, I wanted to lock a table from one application and insert some data. And my requirement is, if that table is already locked by anyother process then I need to try to lock after a specific amount ...
    Radhesh Krishnan KRadhesh Krishnan K
    Mar 6, 2012 at 11:04 am
    Mar 6, 2012 at 11:46 am
  • Hi, I am running into a death lock with iODBC for function SQLAllocStmt(). The stack in the always the same and it hangs when SQLAllocStmt() is reached. The same code works with unixODBC. Is there ...
    Mar 4, 2012 at 7:26 am
    Mar 4, 2012 at 7:26 am
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-odbc @

Top users

Dave Page: 1069 posts Hiroshi Inoue: 1068 posts Noreply: 614 posts Ludek Finstrle: 389 posts Tom Lane: 238 posts Bruce Momjian: 168 posts Peter Eisentraut: 158 posts Jeff Eckermann: 142 posts Hiroshi Saito: 120 posts Lothar Behrens: 107 posts Greg Campbell: 106 posts Philippe Lang: 105 posts Joel Fradkin: 85 posts Zuschlag2: 82 posts Merlin Moncure: 74 posts Marko Ristola: 70 posts Joshua D. Drake: 68 posts Richard Broersma: 61 posts CG: 57 posts Richard Huxton: 57 posts
show more