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

RE: [INTERFACES] PostOBDC

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Warren Craig'" <CWarren(at)iclretail(dot)com>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: [INTERFACES] PostOBDC
Date: 1998-12-01 08:24:48
Message-ID: 000201be1d04$114100e0$2801a8c0@pc81.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)vale-housing(dot)co(dot)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(at)postgreSQL(dot)org
> [mailto:owner-pgsql-interfaces(at)postgreSQL(dot)org]On Behalf Of
> Warren Craig
> Sent: 30 November 1998 23:30
> To: pgsql-interfaces(at)postgreSQL(dot)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(at)iclretail(dot)com
>
>


In response to

  • PostOBDC at 1998-11-30 23:29:46 from Warren Craig

pgsql-interfaces by date

Next:From: Bryan WhiteDate: 1998-12-01 16:47:25
Subject: Can a PGresult outlive a PGconn
Previous:From: The Hermit HackerDate: 1998-12-01 02:46:51
Subject: Re: [ADMIN] Re:

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