> -----Original Message-----
> From: Dan Langille [mailto:dan@langille.org]
> Sent: 22 June 2003 22:19
> To: Dave Page
> Cc: pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] Migration wizard cannot
> connect via ODBC
>
>
> 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.
Good.
> 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?
Regards, Dave.