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-02 08:08:54
Message-ID: 000001be1dcb$02f91f00$2801a8c0@pc81.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
Good, I'm glad you got it sorted. I'm suprised that a . threw it though,
it's usually spaces or single quotes that cause problems because of the way
that the SQL to create the table is formed. I would appreciate it if you
could still send me the relevant section of the commlog so I can try to fix
the problem for the next release.

Regards,

Dave.

> -----Original Message-----
> From: Warren Craig [mailto:CWarren(at)iclretail(dot)com]
> Sent: 01 December 1998 15:32
> To: 'Dave Page'
> Subject: RE: [INTERFACES] PostOBDC
>
>
> Thanks for your help.  I found the error to be a "." in the
> table name.  I
> was trying to copy a table from SQLServer and the table name
> was dbo.<the
> table name> .  I then imported the table to Access and
> changed the name
> without the "dbo" and it worked.
>
> :)-----Original Message-----
> :)From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> :)Sent: Tuesday, December 01, 1998 12:25 AM
> :)To: 'Warren Craig'
> :)Cc: pgsql-interfaces(at)postgreSQL(dot)org
> :)Subject: 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(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
> :)>
> :)>
> :)
> :)
>


pgsql-interfaces by date

Next:From: Tom LaneDate: 1998-12-02 15:45:40
Subject: Re: [INTERFACES] Can a PGresult outlive a PGconn
Previous:From: Peter T MountDate: 1998-12-02 06:46:53
Subject: Re: [INTERFACES] Using Postgres's NOTIFY/LISTEN

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