Skip site navigation (1) Skip section navigation (2)

Re: Migration wizard cannot connect via ODBC

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Dan Langille" <dan(at)langille(dot)org>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Migration wizard cannot connect via ODBC
Date: 2003-06-23 07:56:40
Message-ID: 03AF4E498C591348A42FC93DEA9661B83AF12F@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Dan Langille [mailto:dan(at)langille(dot)org] 
> Sent: 22 June 2003 22:19
> To: Dave Page
> Cc: pgadmin-support(at)postgresql(dot)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.

Responses

pgadmin-support by date

Next:From: Dan LangilleDate: 2003-06-23 13:11:09
Subject: Re: Migration wizard cannot connect via ODBC
Previous:From: Dave PageDate: 2003-06-23 07:14:51
Subject: Re: sql-builder in pgadmin III

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