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
>
>
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