Re: [GENERAL] ODBC driver issue

On 7/26/2017 9:06 PM, Igor Korot wrote: With the char(), is there a "Standard SQL" way to do trimming? trim(trailing from fieldname) but really, if you want a variable length string without padding, don't use CHAR() as a data type. use VARCHAR or TEXT. -- john r pierce, recycling bits i

Re: [GENERAL] ODBC driver issue

Hi, John, On Wed, Jul 26, 2017 at 11:08 PM, John R Pierce wrote: > On 7/26/2017 7:25 PM, Igor Korot wrote: >> >> When I tried to query the database table with the column "char(129)" I >> get: >> >> "My field text" >> >> (the text with the bunch of spaces at the end). >> >> The driver is not the c

Re: [GENERAL] ODBC driver issue

On 7/26/2017 7:25 PM, Igor Korot wrote: When I tried to query the database table with the column "char(129)" I get: "My field text" (the text with the bunch of spaces at the end). The driver is not the current one - but I don't remember the version. Is this known issue? Maybe its already fixe

[GENERAL] ODBC driver issue

Hi, I'm testing my program and got an interesting issue. I have an OSX 10.8 with iODBC manager and PostgreSQL ODBC driver. When I tried to query the database table with the column "char(129)" I get: "My field text" (the text with the bunch of spaces at the end). The dri

[GENERAL] ODBC and Kerberos authtentication

Hello everyone, I'm new to the list, greetings from MX! I'm currently working on a small project with PostgreSQL 9.6. This project involves Kerberos for authentication, my question is: The ODBC driver support this? What are the flags/options you have to use on the odbc.ini file? I cant find t

Re: [GENERAL] odbc to emulate mysql for end programs

On 06/02/2015 04:16 AM, Mimiko wrote: Thanks for response. I've tried to connect the application to postgres with odbc. Arised 2 problems: 1) mysql widelly uses case-insensitive naming for schemas,tables,columns. Actually that is not true as I found out the hard way. See here for all the way

Re: [GENERAL] odbc to emulate mysql for end programs

On Tue, Jun 02, 2015 at 01:31:55PM +0200, Thomas Kellerer wrote: > > 2) as program double-quotes the schema,table and column names. > > Don't use quoted identifiers. Neither in Postgres nor in MySQL (or any other > DBMS) I think a better rule of thumb is either always to use them (and spell eve

Re: [GENERAL] odbc to emulate mysql for end programs

Mimiko schrieb am 02.06.2015 um 13:16: > 1) mysql widelly uses case-insensitive naming for > schemas,tables,columns. So does Postgres. FOO, foo and Foo are all the same name > But postgres use case-sensitive when doulbe-quoting Which is what the SQL standard requires (and this was required *lo

Re: [GENERAL] odbc to emulate mysql for end programs

Thanks for response. I've tried to connect the application to postgres with odbc. Arised 2 problems: 1) mysql widelly uses case-insensitive naming for schemas,tables,columns. But postgres use case-sensitive when doulbe-quoting or lowers the names without quoting. Is there a configure option

Re: [GENERAL] odbc to emulate mysql for end programs

On 6/1/2015 12:04 PM, Mimiko wrote: I have several programs which can use mysql,access,oracle DB as a front-end DB via odbc. Is there a method to emulate or hide the back-end DB so for program it will be seen as mysql, but real DB will be on postgres? ODBC *is* that method. you just need

Re: [GENERAL] odbc to emulate mysql for end programs

Hello, PostgreSQL has a fully standards compliant ODBC driver (See: https://odbc.postgresql.org/). Any application designed to communicate with DBMS over ODBC connection should be able to use that driver to communicate with PostgreSQL. Most applications that interact with databases come with ODBC

Re: [GENERAL] odbc to emulate mysql for end programs

On 06/01/2015 12:04 PM, Mimiko wrote: Hello. I have several programs which can use mysql,access,oracle DB as a front-end DB via odbc. Is there a method to emulate or hide the back-end DB so for program it will be seen as mysql, but real DB will be on postgres? On a theoretical level you could

[GENERAL] odbc to emulate mysql for end programs

Hello. I have several programs which can use mysql,access,oracle DB as a front-end DB via odbc. Is there a method to emulate or hide the back-end DB so for program it will be seen as mysql, but real DB will be on postgres? Thank you. -- Sent via pgsql-general mailing list (pgsql-general@pos

Re: [ODBC] [GENERAL] ODBC constructs

On Wed, May 22, 2013 at 6:06 PM, Dev Kumkar wrote: > On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ wrote: > >> >> Yes, or, as mentioned before, you can simply download the RPM directly >> from the repo. >> > Thanks Devrim! > > Installed postgres-92 server from > postgresql92-server-9.2.4-1PGDG.

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 11:28 PM, Dev Kumkar wrote: > On Tue, May 21, 2013 at 10:49 PM, John R Pierce wrote: > >> its looking for the RPM installed packages it was linked against. its not >> looking to see if any same named files just happen to be on your system. > > > Oh, got it. So the only way

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:25 PM, Dann Corbit wrote: > >> > > I do not know if you have 64 bit or 32 bit Linux and if it is Redhat or > Mandrake or whatever. > > To be clear: > > The PostgreSQL distribution allows you to download the PostgreSQL ODBC > driver. The PostgreSQL ODBC driver i

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:33 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] Thanks for the info. Its Red Hat Enterprise Linux Server release 5.5

Re: [ODBC] [GENERAL] ODBC constructs

On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ wrote: > > Yes, or, as mentioned before, you can simply download the RPM directly > from the repo. > Thanks Devrim! Installed postgres-92 server from postgresql92-server-9.2.4-1PGDG.rhel5.x86_64.rpm, actually links which John (Thanks!) mentioned wer

Re: [ODBC] [GENERAL] ODBC constructs

[snip] You want me clean some stuff. Because I installed 'unixODBC-2.3.0'? >> I guess that if you did a successful make install of unixODBC-2.3.0 it will work as your ODBC driver manager. On the other hand, it is easier and more trouble free to use the standardized package installer for your dis

Re: [ODBC] [GENERAL] ODBC constructs

On Wed, May 22, 2013 at 11:44 AM, John R Pierce wrote: > why the heck are you not installing unixODBC-libs from RPMs ?!? > > yum install unixODBC64 unixODBC64-libs unixODBC64-devel > > should do it, unless you're on Red Hat Enterprise without a subscription, > then you can do it the hard way.

Re: [ODBC] [GENERAL] ODBC constructs

On 5/22/2013 11:24 AM, Dev Kumkar wrote: Started first with looking more into building psqlODBC today why the heck are you not installing unixODBC-libs from RPMs ?!? yum install unixODBC64 unixODBC64-libs unixODBC64-devel should do it, unless you're on Red Hat Enterprise without a subsc

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 10:49 PM, John R Pierce wrote: > its looking for the RPM installed packages it was linked against. its not > looking to see if any same named files just happen to be on your system. Oh, got it. So the only way is to do bless it thru 'yum install unixODBC-libs' only. Hmm

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 10:37 PM, Dev Kumkar wrote: BTW where does the 'postgresql91-odbc.x86_64' looking for libodbc.so.1 and libodbcinst.so.1 files. its looking for the RPM installed packages it was linked against. its not looking to see if any same named files just happen to be on your system. --

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 8:40 PM, Dann Corbit wrote: >>> > > I guess that if you did a successful make install of unixODBC-2.3.0 it > will work as your ODBC driver manager. > > On the other hand, it is easier and more trouble free to use the > standardized package installer for your distributi

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 8:33 PM, Dev Kumkar wrote: I can do 'yum update' and its started to update 1st package. Although I exit, just want to confirm there is no unixODBC-libs package so it will not update it. Is that correct? I have no idea what you're saying here. what 1st package? you should app

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:40 PM, John R Pierce wrote: > # yum install unixODBC-libs > > should install the latest version from the distribution base repositories. Its not finding it. May be I need to get on another box then, not sure. Since ODBC driver was missing, downloaded unixODBC-2.3.0.t

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 7:33 PM, Dev Kumkar wrote: Red Hat Enterprise Linux Server release 5.5. 5.5 is a fairly old release of Red Hat Enteprise Linux Server release 5, they are up to 5.9 now. simply running `yum update` should get you the latest incremental files now, if you're running RHEL withou

Re: [ODBC] [GENERAL] ODBC constructs

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dev Kumkar Sent: Tuesday, May 21, 2013 7:27 PM To: John R Pierce Cc: pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] Suggestions

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:35 PM, John R Pierce wrote: > On 5/21/2013 7:02 PM, Dev Kumkar wrote: > > The link > http://www.enterprisedb.com/products-services-training/pgdownload#windows > which > you had earlier provided was postgres installation. It installed libpq but > odbc library was not in

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 7:27 PM, Dev Kumkar wrote: Ya it should have been with base registry. Where to get unixODBC-libs-2.2.11-10.el5.i386? # yum install unixODBC-libs should install the latest version from the distribution base repositories. Since ODBC driver was missing, downloaded unixODBC-2.3

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 7:02 PM, Dev Kumkar wrote: The link http://www.enterprisedb.com/products-services-training/pgdownload#windows which you had earlier provided was postgres installation. It installed libpq but odbc library was not installed. I hope am looking at correct things. after installing p

Re: [ODBC] [GENERAL] ODBC constructs

> > Currently looking for RHEL 5. Thanks! yes looked into my machine and "yum > list postgres*" listed "postgresql91-odbc.x86_64" > But when trying to install, then found the base ODBC library itself are > missing and those needs to be configured first on test machine. > > Error: Missing Dependenc

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:13 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs On Tue, May 21, 2013 at 7:09 PM, Dann Corbit mailto:dcor...@connx.com

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:09 PM, Dann Corbit wrote: > The ODBC library is contained in either the iodbc or unixodbc RPMs. > > The correct RPM to use will depend on your operating system. > Where are these located?

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:03 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] The link http://www.enterprisedb.com/products-services-training

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 5:21 PM, Dann Corbit wrote: > When you install an ODBC driver, it does not install a library. It > installs a DLL or shared object. > > If you have already installed the driver, then set up your data source > with a data source manager. > > ** ** > > IODBC is a popul

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 3:49 PM, Dev Kumkar wrote: On Tue, May 21, 2013 at 3:17 PM, John R Pierce > wrote: what specific non-Windows operating system distribution are you using? ODBC stuff is packaged for most of them. for instance, the yum.postgresql.org

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 1:59 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] I already have installed this on Linux from above link some days

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 3:17 PM, John R Pierce wrote: > what specific non-Windows operating system distribution are you using? > ODBC stuff is packaged for most of them. for instance, the > yum.postgresql.org repository has it packaged as postgresql92-odbc, > available for a variety of redhat/f

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 1:59 PM, Dev Kumkar wrote: I already have installed this on Linux from above link some days back but not able to find library. Can you point me to the same? Also this link says to compile if its non-windows - http://psqlodbc.projects.pgfoundry.org/faq.html#1.2 Check 1.3 Can you

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:45 PM, Dann Corbit wrote: > >> > > Just install the driver and use it. You don’t have to build the driver. > It is already built for you. Look here if you need Solaris or BSD: > > http://www.postgresql.org/download/ > > Or go directly here for Mac, Windows

Re: [ODBC] [GENERAL] ODBC constructs

[snip] Yeah, hope you got my confusion and inclination now. Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? http://www.postgresql.org/ftp/odbc/versions/src/ has sources for windows or am I missing something here? Regards... >

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:35 PM, Guy Rouillier wrote: > On 5/21/2013 3:32 PM, Dev Kumkar wrote: > >> Well to work with psqlODBC, will I need to recompile the psqlODBC binary >> and any additional stuff to get ODBC working? >> > > No, you don't need to recompile any libraries. You just use them.

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:32 PM, Dev Kumkar wrote: > On Tue, May 21, 2013 at 12:16 PM, John R Pierce wrote: > > for pooling, check out pgbouncer. IMHO its a better basic pooler than >> pg_pool. >> > > Sure, looks like its more light weight. And I hope, its not related to the > decision between

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 3:32 PM, Dev Kumkar wrote: Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? No, you don't need to recompile any libraries. You just use them. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-gen

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:16 PM, John R Pierce wrote: for pooling, check out pgbouncer. IMHO its a better basic pooler than > pg_pool. > Sure, looks like its more light weight. And I hope, its not related to the decision between libpq and psqlODBC. And will work with both? thats the perfect

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 11:58 AM, Dev Kumkar wrote: Thanks everyone for sharing comments, really useful ones. Yes the requirement is not connecting to other DBMS but only Postgres and libpq is the correct way so far from comments here. Regarding libpq performance wanted to discuss about connection polling

Re: [ODBC] [GENERAL] ODBC constructs

On Mon, May 20, 2013 at 11:32 PM, Heikki Linnakangas < hlinnakan...@vmware.com> wrote: > libpq is generally-speaking better than psqlodbc. The advantage of ODBC is > that if you have a suitable driver, you can connect to other DBMS' as well, > while libpq will only work with PostgreSQL. Unless you

Re: [ODBC] [GENERAL] ODBC constructs

On 21.05.2013 08:11, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharma wrote: If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge about psqlODBC. Thanks for the comments. Yes objective is to work in C and found l

Re: [GENERAL] ODBC constructs

On 5/21/2013 1:11 AM, Dev Kumkar wrote: Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about psqlODBC. It would be really great to get comments from community here regarding comparison between both of them and also performance perspective. Based on

Re: [GENERAL] ODBC constructs

On 5/20/2013 11:04 PM, Atri Sharma wrote: Also,is it only me,or are we all a bit wary of ODBC? its clumsy.getting software working well with it requires more work. its promise of portability only holds true if you restrict yourself to SQL that works the same on different servers, and if

Re: [GENERAL] ODBC constructs

Sent from my iPad On 21-May-2013, at 11:24, John R Pierce wrote: > libpq lets you talk directly to postgres in its native tongue. > > ODBC implements a sort of abstraction. IMHO, its like trying to type with > mittens on. > Also,I see no point in working using ODBC with Postgres if you

Re: [GENERAL] ODBC constructs

On 5/20/2013 10:11 PM, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharma > wrote: If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge about psqlODBC. Thanks for the comments.

Re: [GENERAL] ODBC constructs

On Mon, May 20, 2013 at 9:12 PM, Atri Sharma wrote: > > If you wish to work in C,then,I would suggest libpq.I would wait for more > replies on this,as I have little knowledge > about psqlODBC. > Thanks for the comments. Yes objective is to work in C and found libpq useful but am not sure about p

Re: [GENERAL] ODBC constructs

Sent from my iPad On 21-May-2013, at 6:15, Dev Kumkar wrote: > Hello, > > My objective is to work with postgres from my linux box using C. Am not sure > whether psqlODBC or libpq should be used. > I was playing and used libpq successfully but not sure which route to go and > whats the diffe

Re: [GENERAL] ODBC constructs

Also adding the pgsql-admin alias. Regards...

Re: [GENERAL] ODBC constructs

Hello, My objective is to work with postgres from my linux box using C. Am not sure whether psqlODBC or libpqshould be used. I was playing and used libpq successfully but not sure which route to go and whats the difference. Also Can you please

[GENERAL] ODBC FDW - could a gently soul help on geting binaries?

Hi! I've tried (a lot, let me say) to compile ODBC FDW in Win32 and Win64 platforms, without success at all. Compilers tried so far: MinGW Gcc Win32 port of Gcc Microsoft Visual C++ 2005 32 and 64 bits None of them had success, with lots of all sort of errors... I'm afraid I'm not a C coder

[GENERAL] ODBC and bytea

Hi, currently we are trying to integrate Postgres with ODBC and have problems with blobs. We tried to use bytea and were under the impression that bytea would act like a blob in other databases when used through ODBC. So far we could not make it work properly. It seems we still have to do the en

Re: [GENERAL] [ODBC] pgsql ODBC text escaping issue

Have you tried one of the newer ODBC drivers? Also, you may want to look into enabling standard_conforming_strings or disabling the warning messages with escape_string_warning. Jon From: Zhidong She To: pgsql-o...@postgresql.org, pgsql-general@postgresql.org, Zhidong She Date: 07/

[GENERAL] ODBC Cursor inserting records appears to lock the database

I have an external script (not maintained by me) that is using an ODBC driver to insert data into one of my databases. The COMMIT appears to take less than one second but closing the cursor takes 13s. It also appears to be locking the database as a whole. Does this sound like a feasible situation w

Re: [GENERAL] [ODBC] resultset metadata libpq

Hi, I had referred below link I could not able to locate or identify api to retrieve information like precision, scale, nullability. Thanks, Ravi Katkar -Original Message- From: willfurn...@googlemail.com [mailto:willfurn...@googlemail.com] On Behalf Of William Furnass Sent: Tuesd

Re: [GENERAL] [ODBC] resultset metadata libpq

On 27 July 2010 13:43, Ravi Katkar wrote: > > From: Ravi Katkar > Sent: Tuesday, July 27, 2010 5:45 PM > To: 'pgsql-general@postgresql.org'; 'pgsql-o...@postgresql.org' > Subject: resultset metadata libpq > > I wanted to retrieve the below metadata information for a column from > resultset. > > Co

[GENERAL] ODBC and configure

Hi List, I have installed ODBC and configure the same in RHEL 4.4. Configured the ODBC in the following way: [ODBC Data Sources] testPSQL = PostgreSQL Test [testPSQL] Driver=/usr/lib/psqlodbc.so Description=Sample PostgreSQL DSN DSN=testPSQL SERVER=xhost+localhost Username=postgres Database=rtd

Re: [GENERAL] ODBC mac os

Thank you very much ;) Enrico 2010/1/29 Dave Page : > On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote: >> Hi, >> I would like to find an odbc driver for mac os x, >> where I can find it? >> >> Thanks to all > > If you're running the one-click PG installer, you can install the ODBC > driver

Re: [GENERAL] ODBC mac os

On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote: > Hi, > I would like to find an odbc driver for mac os x, > where I can find it? > > Thanks to all If you're running the one-click PG installer, you can install the ODBC driver using StackBuilder. -- Dave Page EnterpriseDB UK: http://www.e

[GENERAL] ODBC mac os

Hi, I would like to find an odbc driver for mac os x, where I can find it? Thanks to all regards, Enrico -- That's one small step for man; one giant leap for mankind -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

ok i brought it in as varchar and cast as date. On Sun, Mar 22, 2009 at 12:27 PM, zach cruise wrote: > On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer > wrote: >> zach cruise wrote: >>> when importing from oracle 10g >> >> Importing how? CSV dump and load? DB link of some sort? > > odbc (see email

Re: [GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

On Sun, Mar 22, 2009 at 3:39 AM, Craig Ringer wrote: > zach cruise wrote: >> when importing from oracle 10g > > Importing how? CSV dump and load? DB link of some sort? odbc (see email) specifically Microsoft OLE DB Provider for Oracle > Operating system and version? Oracle version? windows 2k3

Re: [GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

zach cruise wrote: > when importing from oracle 10g Importing how? CSV dump and load? DB link of some sort? Operating system and version? Oracle version? > i get "multiple step ole db generated > error". >From what program ? Where? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsq

[GENERAL] (odbc) multiple step ole db generated error - date/timestamp column

when importing from oracle 10g, i get "multiple step ole db generated error". i narrowed this down to a date/timestamp column - actually to about 100 rows within that column, all = '01-JAN-01' (never null). there is another date/timestamp column that gets imported error-free, and other tables also

Re: [GENERAL] ODBC limitation??

On Saturday, March 14, 2009, Adrian Klaver wrote: > On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > > When I run the following query through psql, it executes successfully. > > However, when I run it through ODBC (via OpenOffice Base), I get the > > error > > > > SQL Status: HY000 > >

Re: [GENERAL] ODBC limitation??

ral@postgresql.org > > Subject: [GENERAL] ODBC limitation?? > > > > When I run the following query through psql, it executes successfully. > > However, when I run it through ODBC (via OpenOffice Base), I get the > > error > > > > SQL Status: HY000 > > Erro

Re: [GENERAL] ODBC limitation??

On Saturday, March 14, 2009, Adrian Klaver wrote: > On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > > When I run the following query through psql, it executes successfully. > > However, when I run it through ODBC (via OpenOffice Base), I get the > > error > > > > SQL Status: HY000 > >

Re: [GENERAL] ODBC limitation??

kla...@comcast.net > To: pgsql-general@postgresql.org; carl.sopc...@cegis123.com > Subject: Re: [GENERAL] ODBC limitation?? > Date: Sat, 14 Mar 2009 18:36:51 -0700 > > On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > > When I run the following query through psql, it executes s

Re: [GENERAL] ODBC limitation??

On Saturday 14 March 2009 5:40:40 pm Carl Sopchak wrote: > When I run the following query through psql, it executes successfully. > However, when I run it through ODBC (via OpenOffice Base), I get the error > > SQL Status: HY000 > Error code: 1000 > > syntax error, unexpected $end, expecting BETWEE

Re: [GENERAL] ODBC limitation??

> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Carl Sopchak > Sent: Saturday, March 14, 2009 5:41 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] ODBC limitation?? > > When I

[GENERAL] ODBC limitation??

When I run the following query through psql, it executes successfully. However, when I run it through ODBC (via OpenOffice Base), I get the error SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE Is this some limitation of ODBC? (I do

Re: [GENERAL] [ODBC] Error in Adding All Table

Hello, What PostgreSQL server and ODBC driver version do you use? salman Sheikh wrote: Hi freinds, i wanted to add my all tables once in MFC application,normally we add it one by one. If i add all table by pressing control and click on all table ,i can add them,but by debugging it shows me alw

Re: [GENERAL] ODBC driver crash

Craig Ringer wrote: > Hi > The crash occurs whether a file, system, or user DSN is being used. > I can reproduce this on two different machines. It happens with or > without SSL in use. It affects any Access 2007 database with a > PostgreSQL ODBC connection in use, including a newly created blank >

[GENERAL] ODBC driver crash

Hi I'm currently encountering an interesting issue with the PostgreSQL ODBC driver on Windows. I'm unlucky enough to have to use MS Access 2007 for a project at the moment, with PostgreSQL providing the storage through ODBC. It all works as well as can be expected from Access, except that the appl

Re: [GENERAL] ODBC, access, and joins

=-- On Fri, 11/23/07, Tom Hart <[EMAIL PROTECTED]> wrote: > The problem I'm having is that anything defined as a "text" datatype in > > postgres gets converted to a "memo" datatype in access, and when we > attempt to perform a join query on thatfield access starts complaining > > about not bein

Re: [GENERAL] ODBC, access, and joins

On Fri, Nov 23, 2007 at 03:48:01PM -0500, Tom Hart wrote: > The problem I'm having is that anything defined as a > "text" datatype in postgres gets converted to a "memo" datatype in > access, and when we attempt to perform a join query on that field access > starts complaining about not being ab

[GENERAL] ODBC, access, and joins

Hi again everybody. I've got kind of a weird one today (the more complicated my db gets, the stranger the questions). I've built a data mine backend to replace our access data mine (eww, I know), but we'd like to still be able to use access to get to the tables, and write queries/reports/etc. a

Re: [GENERAL] odbc parameters

am Wed, dem 11.07.2007, um 14:55:28 +0200 mailte Zlatko Matic folgendes: > I have already tried COPY. > But, it has problems with type castings. > For example, COPY operation fails because PostgreSQL can't copy value > 7.844,000 into NUMERIC field... Either copy such values into a temp. table wi

Re: [GENERAL] odbc parameters

t: Wednesday, July 11, 2007 2:31 PM Subject: Re: [GENERAL] odbc parameters am Wed, dem 11.07.2007, um 14:15:02 +0200 mailte Zlatko Matic folgendes: Hello, please don't hijack other threads. If you only change the subject for a new question, your mail will be sorted completely wrong. (within

Re: [GENERAL] odbc parameters

am Wed, dem 11.07.2007, um 14:15:02 +0200 mailte Zlatko Matic folgendes: > Hello, please don't hijack other threads. If you only change the subject for a new question, your mail will be sorted completely wrong. (within modern email-clients such thunderbird or mutt) > > I use MS Access for data

[GENERAL] odbc parameters

Hello, I use MS Access for data import. Access imports csv file, make some calculation and transffers data to PostgreSQL. Unfortunately, it takes a lot of time to transfer data to PostgreSQL. My odbc settings are following: [ODBC] DRIVER=PostgreSQL Unicode UID=postgres XaOpt=1 LowerCaseIdentif

Re: [GENERAL] odbc with encrypted ssl key?

Hi! You may try https://projects.commandprompt.com/public/odbcng/. This PostgreSQL ODBC driver's connection string can contain parameters you need: SSL_CERTIFICATE=[string] - path to SSL certificate file SSL_PRIVATE_KEY=[string] - your SSL private key SSL_PASSPHRASE=[str

[GENERAL] odbc with encrypted ssl key?

Hi, is there a way to have MS-Access use ODBC and still use a passphrase encrypted private-key? Right now ODBC works with unencrypted key. For security reasons I'd rather have my private key stored encrypted. I suppose to do this Access had to tell the odbc driver the passphrase so that it can

Re: [GENERAL] odbc can't edit postgresql database ?? -- Small example

I have a clue to this problem, see below. On 3/11/07, Geoff Russell <[EMAIL PROTECTED]> wrote: Hi all, I have postgresql 8.1, unixodbc and openoffice on a Ubuntu 6.06.1 machine and can connect to my postgresql databases fine --- but can't edit data, only view. pgadmin3 also only allows viewing

[GENERAL] odbc can't edit postgresql database ??

Hi all, I have postgresql 8.1, unixodbc and openoffice on a Ubuntu 6.06.1 machine and can connect to my postgresql databases fine --- but can't edit data, only view. pgadmin3 also only allows viewing but not editing. I can insert records with psql. To make matters worse, I have another machine

[GENERAL] odbc and pgadmin.support newsgroup from news server are not functional

News reader cannot read pgsql.interfaces.odbc pgsql.interfaces.pgadmin.support groups from news.postgresql.org news server last message in odbc group is from 14.12.6 and in pgadmin group is from 18.12.6 pgsql.general and pgsql.announce newsgroups works OK. Andrus. ---

Re: R: [GENERAL] [ODBC] information request on postgresql --> oracle

Glauco Mancini schrieb: Hi all, Ragnar and Tino many thanks for you feedback. Using this type of approach probably i will try first with pl-j or pl/java because i am more comfortable with the java language. It would be nice if i can use, inside postgresql, something like "select * from [EMAI

R: [GENERAL] [ODBC] information request on postgresql --> oracle

ECTED]" ... Probably it would be nice if elephants can fly too ! Best regards, Glauco Mancini -Messaggio originale- Da: Tino Wildenhain [mailto:[EMAIL PROTECTED] Inviato: lunedì 29 maggio 2006 11.50 A: Ragnar Cc: Glauco Mancini; pgsql-general@postgresql.org Oggetto: Re: [GENERAL] [ODBC] informati

Re: [GENERAL] [ODBC] information request on postgresql --> oracle

Ragnar schrieb: On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote: i'm looking for a method to connect natively a postgresql db to oracle ( maybe via odbc ? ) with something similar to the oracle dblink. I connected successfully a oracle instance to a postgresql instance using unix-odb

Re: [GENERAL] [ODBC] information request on postgresql --> oracle

On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote: > i'm looking for a method to connect natively a postgresql db to oracle > ( maybe via odbc ? ) with something similar to the oracle dblink. > > I connected successfully a oracle instance to a postgresql instance > using unix-odbc, now i

[GENERAL] [ODBC] information request on postgresql --> oracle connect via odbc

Hi all,     i'm looking for a method to connect natively a postgresql db to oracle ( maybe via odbc ? ) with something similar to the oracle dblink.   I connected successfully a oracle instance to a postgresql instance using unix-odbc, now i need to proceed on the other way.   Can you plea

Re: [GENERAL] odbc problem

"P.MO" <[EMAIL PROTECTED]> writes: > I've just recompiled a postgres 8.1.3 on freebsd 5.4 and since > then, I can no more access it with odbc. What happens exactly when you try? Does it still work from other clients, eg psql? regards, tom lane ---

Re: [GENERAL] [ODBC] Problem using ODBC from .NET framework

--- Ludek Finstrle <[EMAIL PROTECTED]> wrote: > Feel free to re-post the message if 08.01.0200 is still boken. I'll > appreciate if you include mylog output (from 08.01.0200 driver). > Using 08.01.0200, I'm still receiving the same error. However, I've managed to narrow the case when it happens

  1   2   3   >