Re: Compiling using Visual Studio 2003

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Paul Cochrane" <paul(dot)m(dot)cochrane(at)tuht(dot)scot(dot)nhs(dot)uk>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Compiling using Visual Studio 2003
Date: 2005-02-10 14:54:45
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4528A91@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Paul Cochrane
> Sent: 10 February 2005 14:32
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Compiling using Visual Studio 2003
>
> Dave Page wrote:
>
> >>Off topic, FYI, I couldn't get the command line nmake to
> work. I did
> >>try putting in extra search paths & stuff but gave up shortly
> >>thereafter
> >>and continued my fight with the IDE.
> >>
> >>
> >
> >That's how I build it all the time. Did you run vcvars32.bat
> first? That
> >should be all that is needed.
> >
> >
> >
> I'm Thick. What is this file? It doesn't seem come with psqlodbc and
> there is no mention of it in the doc on the GBORG site about
> compiling
> the driver. I was changing to the extracted dir & trying nmake.....

It sets up the DOS environment for VC and is part of Visual Studio. On
my system I have it in:

C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\bin (VS.NET 2K3)

And

C:\Program Files\Microsoft Visual Studio\VC98\Bin (VS6)

Note that if you can it's better to use VC++6 as the required runtimes
are generally already on most machines.

> I can fix it in code but this would break the compatibility of using
> either the paradox tables or postgres tables. I would have to
> have two
> different versions of each form etc & record many lines of
> code to say
> "If in postgres add a public. to every table name" which is a
> huge pest
> & I don't want to have two version of each form to try & keep in sync
> with each other.

You can't abstract it into a macro or function - i.e. in your forms have
something like

EXECUTE("SELECT * FROM " + FixName("MyTable"));

(bearing in mind I know nothing about Paradox)?

> If I get it working, I may update the ODBC driver form to
> have a couple
> of tick boxes to make this an option in the driver and send you the
> changes made.

OK, thanks. 1 tick box will probably do though :-)

Regards, Dave.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Paul Cochrane 2005-02-10 15:22:37 Re: Compiling using Visual Studio 2003
Previous Message Paul Cochrane 2005-02-10 14:31:31 Re: Compiling using Visual Studio 2003