Re: Import: about ODBC data source

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Quan Zongliang <quanzongliang(at)gmail(dot)com>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Import: about ODBC data source
Date: 2009-01-14 13:21:07
Message-ID: 496DE6C3.3020702@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Dave Page a écrit :
> On Wed, Jan 14, 2009 at 12:14 PM, Quan Zongliang
> <quanzongliang(at)gmail(dot)com> wrote:
>> Hi All,
>>
>> The wxWidgets framework has some classes relative to ODBC:
>> wxDb/wxDbTable and so on.
>> Them is controlled by identifier wxUSE_ODBC.
>> Default is 0, that is, don't compiling with wxWidgets.
>>
>> My idea is only support this function (import from ODBC) under MS-Windows
>> using Microsoft API. Although there is iODBC (http://www.iodbc.org)
>> under Unix implemented the ODBC API.
>
> iODBC is used on Mac, but in my experience, unixODBC is more popular
> on Linux. I don't know what is used on Solaris or the BSDs. I'm not
> keen on the idea of only offering functionality on one platform.
>
> Without using wxUSE_ODBC, I don't see that you'll be able to do this
> nicely in a cross platform way. I suppose you could allow the user to
> select the ODBC driver libraries (eg. psqlodbc.so) directly, but that
> will mean that DSNs can't be used.
>
> Anyone else got any thoughts?
>

I don't quite understand why we would want to use ODBC in pgAdmin. One
thing that makes pgAdmin great is its use of libpq. Can someone explain
me why we should use ODBC ?

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2009-01-14 13:24:03 Re: Import: about ODBC data source
Previous Message Dave Page 2009-01-14 12:57:03 Re: Import: about ODBC data source