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 13:11:09
Message-ID: 3EF6C42D.24053.344C837B@localhost (view raw or flat)
Thread:
Lists: pgadmin-support
On 23 Jun 2003 at 8:56, Dave Page wrote:

> > For what it's worth, the migration gets this error:
> > 
> > Creating table: newforum1_bodies
> >   Copying data...
> > 
> > An error occured at: 22/06/2003 5:11:40 PM: 
> > -2147467259: ERROR:  parser: unterminated quoted string at or near 
> > "'<HTML>tr -d "" at character 72
> >
> > 
> > If you want me to try a patch etc, I can do that.  Otherwise, I'll 
> > just modify the data.
> 
> Odd, it should escape the data - in fact the code looks like:
> 
> Values = Values & "'" & Replace(Replace((szValue), "\", "\\"), "'",
> "''") & "', "
> 
> Thing is with that though, it's not escaping double quotes, but that's
> because it doesn't need to. In PostgreSQL, the following will work just
> fine:
> 
> INSERT INTO foo (bar) VALUES ('"');
> 
> Can you provide a log with the SQL query that's failing in it please?

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

If there's anything else, let me know.
-- 
Dan Langille : http://www.langille.org/


In response to

pgadmin-support by date

Next:From: Dave PageDate: 2003-06-23 13:35:44
Subject: Re: Migration wizard cannot connect via ODBC
Previous:From: Dave PageDate: 2003-06-23 07:56:40
Subject: Re: Migration wizard cannot connect via ODBC

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