RE: [INTERFACES] PostOBDC

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