RE: [INTERFACES] PostOBDC - Mailing list pgsql-interfaces
From | Dave Page |
---|---|
Subject | RE: [INTERFACES] PostOBDC |
Date | |
Msg-id | 000001be1dcb$02f91f00$2801a8c0@pc81.vale-housing.co.uk Whole thread Raw |
List | 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@iclretail.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@vale-housing.co.uk] > :)Sent: Tuesday, December 01, 1998 12:25 AM > :)To: 'Warren Craig' > :)Cc: pgsql-interfaces@postgreSQL.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@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 > :)> > :)> > :) > :) >
pgsql-interfaces by date: