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/
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 |