pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Page <dpage@vale-housing.co.uk>
To: 'Warren Craig' <CWarren@iclretail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: RE: [INTERFACES] PostOBDC
Date: Tue, 1 Dec 1998 08:24:48 -0000
Message-ID: <000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk> (raw)
In-Reply-To: <BF1813FE1ACFD111BACA00A0C9B3C13BC7ABE3@usa04s00010.iclretail.com>

Hi,

I'd bet a fiver that you have a ' somewhere in your data! Can you switch on
the Commlog option in PostODBC, re-run the Migration Wizard as before and
then send me the commlog please.

Unfortunately single quotes in data have my life a misery as far as the
Import and Migration wizards in pgAdmin are concerned!!

Regards,

Dave.

--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!

> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of
> Warren Craig
> Sent: 30 November 1998 23:30
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] PostOBDC
>
>
>   I am trying to copy over a table (schema and Data) from a SQL Server
> Database table to Postgres.  I am using pgAdmin tool on my NT
> machine and I
> have the lates drivers of PostOBDC.  I get an error that says
> "Error 3146:
> ODBC called failed"  Here is the run log from the pgAdmin  It
> looks like the
> error is coming from my DAO object.  Has anybody seen this before?
>
> Software
> ********
> Program: pgAdmin
> Version: 6.4.0
> Sub or Function: frmMigration, Migrate_Data
>
> Error Details
> *************
> Error No: 3146
> Error Description: ODBC--call failed.
> Error Source: DAO.QueryDef
> DLL Error Code: 0
>
> Memory Details
> **************
> Total Physical: 100061184
> Total Swap: 167112704
> Total Virtual: 2147352576
> Available Physical: 39071744
> Available Swap: 102445056
> Available Virtual: 2016604160
> Percentage Free: 0
>
> System Details
> **************
> Processor: 586
> OEM ID: 0
> No. Processors: 1
> Page Size: 4096
>
> OS Details
> **********
> Platform: Windows NT
> Version: 4.0
> Build: 1381
> OS Info: Service Pack 3
>
> Craig Warren
> Work # (619) 458-5541
> e-mail CWarren@iclretail.com
>
>




view thread (9+ messages)  latest in thread

Message-ID: <000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk>
Permalink:  ../000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk/
Also on:    postgresql.org/message-id/000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-interfaces@postgresql.org
  Cc: dpage@vale-housing.co.uk, CWarren@iclretail.com
  Subject: Re: [INTERFACES] PostOBDC
  In-Reply-To: <000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk>
  References: <BF1813FE1ACFD111BACA00A0C9B3C13BC7ABE3@usa04s00010.iclretail.com> <000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox