Re: [ADMIN] ODBC constructs

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

Re: [ADMIN] ODBC for Windows-64 ?

* Josef Springer wrote: we are using PostgrSQL 8.1 and the client is connected via ODBC PostgreSQL Unicode. What must be used to use the install ODBC on a Windows-64 system ? The latest release of the 32-bit ODBC driver appears to be

Re: [ADMIN] odbc

On Tue, Mar 29, 2011 at 10:51 AM, Marc Fromm wrote: > I am running postgres on a red hat linux server. > > postgresql-python-8.1.23-1.el5_6.1 > > postgresql-test-8.1.23-1.el5_6.1 > > postgresql-libs-8.1.23-1.el5_6.1 > > postgresql-docs-8.1.23-1.el5_6.1 > > postgresql-contrib-8.1.23-1.el5_6.1 > >

Re: [ADMIN] odbc

From: Marc Fromm [mailto:marc.fr...@wwu.edu] Sent: Tuesday, March 29, 2011 1:52 PM To: pgsql-admin@postgresql.org Subject: odbc I am running postgres on a red hat linux server. postgresql-pyth

Re: [ADMIN] [ODBC] PGexpress v4.11 + postgresql 8.4.4

On 13/08/2010 13:25, Victor Hugo wrote: > Hi, > > Someone uses pgExpress Driver v4.11 with postgresql 8.4.4? Hi there, Yes, I use it. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscrip

Re: [ADMIN] ODBC

On Wed, Jan 21, 2009 at 3:31 PM, Marc Fromm wrote: > Some of our users use an ODBC connection between MS Access and an Oracle > database to work with the data. > Access however has a 255 field/column limit, which the Oracle Db has now > execeded. I am not sure what kind of data model would requir

Re: [ADMIN] odbc error, operator does not exist

On Sat, Aug 23, 2008 at 12:05 PM, c k <[EMAIL PROTECTED]> wrote: > Hello all, > > As I am testing our old mysql based erp app., on postgresql with most of > things are as they are in MySQL db with PG 8.3, Unicode ODBC driver and > Access 2003, I got this error: > ODBC -call failed. Operator does no

Re: [ADMIN] [ODBC] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE

On Wed, Jun 11, 2008 at 11:17 AM, Hiroshi Inoue <[EMAIL PROTECTED]> wrote: >> Tagables.Parameters(0) = oldtags("devicetype") >> Set tagableRS = Tagables.Execute >> tagableid = tagableRS("tagableid").Value > > Please add > tagableRS.Close() Your advice worked perfec

Re: [ADMIN] odbc problem on Japanese windows machine

Am Donnerstag, 13. Dezember 2007 14.40:22 schrieb Sofer, Yuval: > Hi, > > > > I am trying to use postgres odbc driver on windows Japanese machine, to > test connection to a remote postgres database. The database has latin1 > encoding. > > > > Connection tests to databases with latin1 encoding fail

Re: [ADMIN] ODBC connection problem

On 7/24/06, Erik Ferencz <[EMAIL PROTECTED]> wrote: Hi. I have got a problem with connection to my Postgres DB.   I have Win2003 server with Postgres 8.1.4 instalation. Let's call this server server2003   I wrote an application in C#.This application is connecting to my Postgre DB on serv

Re: [ADMIN] ODBC TROUBLE

> Hi all, I been having a weird problem with the postgresql odbc driver, I > am working on an aplication in ms visual fox pro which use to have a > database in MS SQL Server I am migrating it to postgres, the problem with > the driver is that when I put the user name and password, the driver giv

Re: [ADMIN] ODBC + pgsql on win32

I don't claim to be an export in this area, but here is how I am doing things: ADO connection snipit: Set oTargetConn = New ADODB.Connection oTargetConn.ConnectionString = "DRIVER={PostgreSQL};" _ & "SERVER=" & Me.txtHost & ";" _ & "UID=" & Me.txtLogin & ";" _

Re: [ADMIN] [ODBC] invalid input syntax for type tid: "(,)"

"Jose' Cruanyes" <[EMAIL PROTECTED]> writes: > select * from table1 where ctid = '(,)'; > [ works on some machines and not others ] I would argue that the ODBC driver is broken and needs to be fixed, as does the TID input parser which should never allow this ... However, the reason for the platfo

Re: [ADMIN] ODBC Driver generates a too big "windows swap file" and

On Fri, 12 Dec 2003, Rhaoni Chiu Pereira wrote: Hi, is there a switch in your pgsql/odbc connector to enable cursors? If so, try turning that on. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] ODBC Driver

If you go to http://odbc.postgresql.org it will redirect you to http://gborg.postgresql.org/project/psqlodbc/projdisplay.php There is the official PostgreSQL ODBC Driver. Rhaoni Chiu Pereira wrote: Hi List, I finished the first step of the PostgreSQL's approval process ( We are gonig to use

Re: [ADMIN] ODBC and unknown i.p.

Thanks. That did the trick. I knew there had to be a simple solution. At 04:14 PM 2/11/03 +0800, you wrote: > > Mike, > Have you tried adding an entry for the entire Internet? > eg: IP: 127.0.0.1(could be anything) Mask: 0.0.0.0 > > Mike.(also) > > > -Original Message- > > From: Mik

Re: [ADMIN] ODBC and unknown i.p.

Title: RE: [ADMIN] ODBC and unknown i.p. Mike, Have you tried adding an entry for the entire Internet? eg: IP: 127.0.0.1(could be anything) Mask: 0.0.0.0 Mike.(also) > -Original Message- > From: Mike Alford [mailto:[EMAIL PROTECTED]] > Sent: Monday, 10 February 2003 9:4

Re: [ADMIN] ODBC error

Hi, I updated the table definitions and changed the field type from numeric(18) to int for the field I was linking the tables with. This solved the problem. However, if a decimal field was required, I think this would cause a big problem. Is there a workaround if a decimal field is required?

Re: [ADMIN] ODBC Problem

Friends, A little more information: I'm actually only having this problem with some tables that have triggers on insert, update and delete. A table and the assocaited triggers/functions shown below. I suspect that something changed in the triggers or functions in 7.2, but I can'

Re: [ADMIN] ODBC queries die; "Unexpected protocol character from backend"

Steve Frampton <[EMAIL PROTECTED]> writes: > I have a PostgreSQL 7.1.3 system which is accessed from an Apache CGI > handler via ODBC (driven by libiodbc-3.0.5). It has worked very well, but > on two occasions queries just stop working. > The Apache error log shows: > Unknown error; > Unexpec

Re: [ADMIN] ODBC password crypting support

> When trying to connect to the postgreSQL database through ODBC, I get an error > "Unknown username or password. Password crypt authentication not supported. > (errcode 13095)" > I can assume ODBC do not support password crypting. Does that mean I cannot > connect through ODBC, or there's anoth

RE: [ADMIN] ODBC connection to PostgreSQL

That helped, thanks! > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Stefan Huber > Sent: Friday, April 27, 2001 6:32 PM > To: [EMAIL PROTECTED] > Subject: Re: [ADMIN] ODBC connection to PostgreSQL > > > > >Now

Re: [ADMIN] ODBC connection to PostgreSQL

>Now I wonder how I have to configure the postmaster to get this >working... Try starting it with the -i option to tell the postmaster to listen to TCP Sockets, too. If it isn't that, you might have a different port, the postmaster is listening to, or a "misconfigured" firewall/packetfilter.

Re: [ADMIN] ODBC connection to PostgreSQL

Christian Marschalek wrote: > > I installed the PostgreSQL ODBC dll, but everytime I'm trying to connect > to my database server (witch is another machine in my network) I get the > error "Couldn't connect to server, couldn't connect to remote socket" > > Now I wonder how I have to configure the

Re: [GENERAL] RE: [ADMIN] ODBC connect in ERWin

rom the specified IP address. But still > getting the same error. > > Anybody has any idea?? > > Thanks again for your continuing support. > > Niral > > -Original Message- > From: Warren Vanichuk [mailto:[EMAIL PROTECTED]] > Sent: Friday, January

Re: [GENERAL] Re: [ADMIN] ODBC connect in ERWin

> > But When I am trying to forward engineer that to my Remote PostgreSQL db I > > am getting ODBC error saying: > > 'Could not connect to the Server' > > 'Could not connect to remote socket' Oh, and I do recognize those error messages as the same that occur when you are configured for SSH port f

Re: [ADMIN] ODBC connect in ERWin

> But When I am trying to forward engineer that to my Remote PostgreSQL db I > am getting ODBC error saying: > 'Could not connect to the Server' > 'Could not connect to remote socket' > > Now, I have already added 'host' line in 'pg_hba.conf' file to give access > to the db from my machine as fol

Re: [ADMIN] ODBC on NT/cygwin Installation

You must download and install the PGSQL ODBC Driver separately. There are links for downloading it on the PGSQL site. Configuring with ODBC just activates support within PGSQL for using ODBC drivers, but doesn't do any installation of drivers. - Original Message - From: <[EMAIL PROTECTED]

Re: [ADMIN] odbc driver

e- > From: Nuchanach Klinjun <[EMAIL PROTECTED]> > To: shan <[EMAIL PROTECTED]> > Cc: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> > Date: Thursday, August 26, 1999 10:31 PM > Subject: Re: [ADMIN] odbc driver > > > > > >I think you will ha

Re: [ADMIN] odbc driver

t;[EMAIL PROTECTED]> To: shan <[EMAIL PROTECTED]> Cc: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Thursday, August 26, 1999 10:31 PM Subject: Re: [ADMIN] odbc driver > >I think you will have to check which os that file support. I had >'postdrv.exe' too

Re: [ADMIN] odbc driver

I think you will have to check which os that file support. I had 'postdrv.exe' too and it's work normally. So, the file you have maybe corrupt while you download it. please try download and install again. and if u want that file I will give u. On Thu, 26 Aug 1999, shan wrote: > I am running an

Re: [ADMIN] ODBC CONNECTION

-Original Message-From: Michael Krecek <[EMAIL PROTECTED]>To: SPICES BOARD <[EMAIL PROTECTED]>Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>Date: Tuesday, June 22, 1999 4:40 PMSubject: Re: [ADMIN] ODBC CONNECTION SPICES BOAR

Re: [ADMIN] ODBC CONNECTION

SPICES BOARD schrieb:  I have just started using Redhat Linux 5.2 and Postgresql-6.3.2. Postgres SQL ODBC Driver (v06-40-0006I) was downloaded and installed on windows 95 client side.   Using MS Access and Delphi, I could read data on Postgres. But there is no write access. Please help me. Than

Re: [ADMIN] odbc - frontend HELP!!!

I just went through the same problems you and Jim Burnett are describing. Here is what I got to work and how I did it. (Remember I am new to both Linux and Postgres so there may have been an easier way.) I am on a RH 5.0 system that installed Postgres from the RH cd. It puts Postgres 6.2

RE: [ADMIN] odbc

On Wed, 26 May 1999, Herbert Ambos wrote: > 2. User authentication failed (#210) --> but i did double check the > username, password, database, server, port. have youe edit the file pg_hba.conf ? This file contain the machine (external) that can connect to your DB. ciaoz Ho talment

RE: [ADMIN] odbc

Sir/Madamme: This my 3rd day researching about PostgreSQL and i got a similar problem with respect to Jim Burnett's. First of all, I have PostgreSQL ver 6.3.2 running on my RedHat Linux 5.2. It seems that my postmaster has no problem and I added (restarted) it with the -i option

RE: [ADMIN] odbc

-Original Message- From: Jim Burnett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 25, 1999 11:07 AM To: Karell Ste-Marie Subject: RE: [ADMIN] odbc Well I have postgres installed on my linux box, and I downloaded my ODBC driver for windows and installed it, but when I try to Import using th

RE: [ADMIN] ODBC

The file you need is postdrv.exe ... I will check where I got it just now, but you just install that and it works like a charm with 6.4.2 ;-) I think if you check the documentation in the doc directory you will get the site where you need to download it ... or perhaps it is in the FAQ ... I think

Re: [ADMIN] ODBC Call fail? (fwd)

: > -- Forwarded message -- > Date: Sun, 31 May 1998 18:52:53 +0530 > From: Venugopal <[EMAIL PROTECTED]> > To: Peter Mount <[EMAIL PROTECTED]> > Subject: Re: [ADMIN] ODBC Call fail? > Newsgroups: comp.databases.postgresql.admin > > Peter Mount wrot

Re: [ADMIN] ODBC Call fail? (fwd)

wrote: > > -- Forwarded message -- > Date: Sun, 31 May 1998 18:52:53 +0530 > From: Venugopal <[EMAIL PROTECTED]> > To: Peter Mount <[EMAIL PROTECTED]> > Subject: Re: [ADMIN] ODBC Call fail? > Newsgroups: comp.databases.postgresql.admin > > Peter Mount wrote: >

Re: [ADMIN] ODBC Call fail? (fwd)

-- Forwarded message -- Date: Sun, 31 May 1998 18:52:53 +0530 From: Venugopal <[EMAIL PROTECTED]> To: Peter Mount <[EMAIL PROTECTED]> Subject: Re: [ADMIN] ODBC Call fail? Newsgroups: comp.databases.postgresql.admin Peter Mount wrote: > On Sat, 30 May 1998, Thom

Re: [ADMIN] ODBC Call fail?

On Sat, 30 May 1998, Thomas Lester wrote: > Everytime I try to hit my database from my ODBC driver I get ODBC call failed. > I have a pretty good idea why. I do not have an entry for postgres in my > /etc/services (I'm using solaris 2.6). Am I correct? You don't need an entry. Are you runn