Wine+ADODB+PostgreSQL

somellier · Post by **somellier** » Tue Jul 01, 2008 5:13 pm

I'm trying to write VB6 code to get data from a PostgreSQL server running on Fedora 7 Linux. Running the code in Win XP there is no problem, but when I try running under Wine on the linux server itself I get no rows returned from my database even though the logs show I'm connected and PostgreSQL has located the data I requested. I'm using an ADODB connection with a DSN. However the same DSN works perfectly in the Visdata add-in in VB, presumably because it sets up a bound data control rather than an ADODB data control to access the database. I have in fact written some simple code to emulate this with a data control bound to a sql select statement and it does work. Can anyone please give me an idea as to what I need to do to fix this or maybe tell me to stop wasting my time because it can't be done.Thanks.

Charity Abbott · Post by **Charity Abbott** » Tue Jul 01, 2008 5:56 pm

On Tue, Jul 1, 2008 at 6:13 PM, somellier <[email protected]> wrote:

I'm trying to write VB6 code to get data from a PostgreSQL server running on Fedora 7 Linux. Running the code in Win XP there is no problem, but when I try running under Wine on the linux server itself I get no rows returned from my database even though the logs show I'm connected and PostgreSQL has located the data I requested. I'm using an ADODB connection with a DSN. However the same DSN works perfectly in the Visdata add-in in VB, presumably because it sets up a bound data control rather than an ADODB data control to access the database. I have in fact written some simple code to emulate this with a data control bound to a sql select statement and it does work. Can anyone please give me an idea as to what I need to do to fix this or maybe tell me to stop wasting my time because it can't be done.Thanks.

Is there a reason you're using wine to do this? I think it would be
much easier to write an app especially for the server in a language
that can run natively in Linux since you are the developer. If you set
up apache and write PHP or Perl code for it, it's actually almost as
easy as making a forms in VB.

somellier · Post by **somellier** » Wed Jul 02, 2008 2:55 am

Thanks for the advice. I'm using Wine because the app already exists, is well established in XP and I would prefer not to rewrite it. However I also want to get off the MS treadmill (XP support stops soon). I would also like to do this at the least cost possible so that probably rules out RealBasic (most other IDEs I've tried are unusable). It looks like I might well be getting a copy of "PHP for Dummies" soon !!!. Thanks again.

austin987 · Post by **austin987** » Wed Jul 02, 2008 7:39 am

On Wed, Jul 2, 2008 at 2:55 AM, somellier <[email protected]> wrote:

Thanks for the advice. I'm using Wine because the app already exists, is well established in XP and I would prefer not to rewrite it. However I also want to get off the MS treadmill (XP support stops soon). I would also like to do this at the least cost possible so that probably rules out RealBasic (most other IDEs I've tried are unusable). It looks like I might well be getting a copy of "PHP for Dummies" soon !!!. Thanks again.

Sounds like you may need some ODBC drivers, off hand.