> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Paul Cochrane
> Sent: 10 February 2005 14:32
> To: pgsql-odbc@postgresql.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.