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-22 21:19:08
Message-ID: 3EF5E50C.22257.30E4DB7E@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 22 Jun 2003 at 21:33, Dave Page wrote:

> > Thanks. http://pgadmin.postgresql.org/ seems to be down just now...
>
> Looks OK from here.

And now from here.

> From
> http://archives.postgresql.org/pgadmin-support/2003-03/msg00068.php:
>
> FYI - If you have anyone else reporting this issue, MyODBC 2.50.19 looks
> to be the go!

Thanks for that. I've just tried version 2.50.39 (latest on website)
and it seems fine too.

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

Rolling back... Done.

Sounds like the data contains extra "s which are not being escaped.
Here's what I found:

mysql> select * from newforum1_bodies where body like '<HTML>tr -d
%';
+-----+------------------------------------------+--------+
| id | body | thread |
+-----+------------------------------------------+--------+
| 155 | <HTML>tr -d " | 155 |
+-----+------------------------------------------+--------+
1 row in set (0.08 sec)

mysql>

If you want me to try a patch etc, I can do that. Otherwise, I'll
just modify the data.

And if you're on IRC or MSN, email me offlist and I'll send you my
contact details.
--
Dan Langille : http://www.langille.org/

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Marc Cuypers 2003-06-23 07:06:44 sql-builder in pgadmin III
Previous Message Dave Page 2003-06-22 20:33:24 Re: Migration wizard cannot connect via ODBC