Skip site navigation (1) Skip section navigation (2)

Re: ODBC Connection failed after importing linked tables

From: "ben sewell" <mosherben(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Connection failed after importing linked tables
Date: 2006-08-02 09:18:06
Message-ID: bf6c74d80608020218p73f3f84fm6b485e824fa57ce3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Joshua,
thanks for the link. I'm not getting that error anymore, but now I'm getting
a problem when I'm importing several tables with the error "the size of a
field is too long". As far as I remember, the tables only compose of int4
fields, varchar fields and a text field.

Text boxe's don't have a limit on the number of charecters they are stored
as they are seen as a string. This leads me to believe that it's the varchar
fields, since the highest number in the integer fields is 7759. Any ideas on
what's going wrong? Any ideas what the maximum number of charecters is
allowed for varchar fields? At the moment, I have specified the limit for
number of charecters in the varchar fields.

Cheers,
Ben

On 8/1/06, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> ben sewell wrote:
> > Hi,
> > I'm running a postgresql 8.1 server on Windows 2002 Small Business
> > Server. I
> > am in the middle of a migration from an MS Access backend to a
> PostgreSQL
> > backend. The existing MS Access 2000 frontend will be used. I'm using
> the
> > pgSQL ODBC driver (latest) on Windows XP Pro SP2.
>
> You could try ODBCng:
>
> http://projects.commandprompt.com/public/odbcng
>
> Joshua D. Drake
>
>
>
> >
> > I have using the linked table wizzard to link tables to the PostgreSQL,
> > which had no problems and I setup the relationships on the front end.
> > However, when I try to open the database, it is saying this error
> message
> > "ODBC--connection to '{PostgreSQL}10.0.0.2' failed". This is strange
> > because
> > I can ping the server and use telnet to connect to postgresql. I've done
> a
> > google search and this seems to be a problem that seems to happen to
> MySQL
> > databases. What I was wondering is, can anyone offer any solutions on
> > how to
> > solve this problem?
> >
> > Cheers,
> > Ben
> >
>
>
> --
>
>    === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>    Providing the most comprehensive  PostgreSQL solutions since 1997
>              http://www.commandprompt.com/
>
>
>

In response to

pgsql-odbc by date

Next:From: Pascal ViandierDate: 2006-08-03 15:23:15
Subject: RE : Cannot update or delete rows
Previous:From: Arnaud LesauvageDate: 2006-08-02 07:30:41
Subject: Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group