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

Re: Migration wizard cannot connect via ODBC

From: "Dan Langille" <dan(at)langille(dot)org>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Migration wizard cannot connect via ODBC
Date: 2003-06-23 14:17:57
Message-ID: 3EF6D3D5.2842.3489ABB4@localhost (view raw or flat)
Thread:
Lists: pgadmin-support
On 23 Jun 2003 at 15:00, Dave Page wrote:

> > On 23 Jun 2003 at 14:35, Dave Page wrote:
> > 
> > > > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO
> > > > "newforum1_bodies" ("id", "body", "thread") VALUES ('151', 
> > > > '<HTML>Uh, Internal Server Errors may be triggered by a 
> > > > particular browser, but the problem _lies on the server 
> > > > itself_, so you''d best off scouring your error logs for 
> > > > clues.</HTML>', '133')
> > > > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO 
> > > > "newforum1_bodies" ("id", "body", "thread") VALUES ('155', 
> > > > '<HTML>tr -d "
> > > > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): ROLLBACK
> > > 
> > 
> > > I notice that the query is not even fully built - could 
> > there be a \0 or
> > > some other odd character in your data? A non-escaped quote 
> > or wahtever
> > > wouldn't prevent the SQL being built in this way - it would just be
> > > invalid SQL.
> > 
> > Looking at the output of mysqldump, I found this:
> > 
> > (155,'<HTML>tr -d \"\015\" < dosfile.txt\r\n</HTML>',155)
> 
> That's almost certainly the problem then. pgAdmin (or more precisely VB)
> is barfing on the control character (which mysqldump nicely outputs as a
> charcode).
> 
> Not much I can do about that I'm afraid.

Are you saying that databases which contain control characters cannot 
be migrated to PostgreSQL using this procedure?  Control characters 
are valid in strings.  They are just characters, slightly special, 
but characters nonetheless.

Hmmm, other suggestions?  
-- 
Dan Langille : http://www.langille.org/


In response to

pgadmin-support by date

Next:From: Dave PageDate: 2003-06-23 14:42:02
Subject: Re: Migration wizard cannot connect via ODBC
Previous:From: Dave PageDate: 2003-06-23 14:00:09
Subject: Re: Migration wizard cannot connect via ODBC

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