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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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