Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.1/8.8.8) with ESMTP id MAA25398
	for <pgsql-interfaces@postgresql.org>;
	Thu, 22 Oct 1998 12:49:13 -0400 (EDT)
	(envelope-from byronn@insightdist.com)
Received: from insightdist.com (root@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA11102
	for pgsql-interfaces@postgresql.org;
	Thu, 22 Oct 1998 12:44:05 -0400 (EDT)
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA26084; Thu, 22 Oct 1998 10:54:20 -0400
Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA42630; Thu, 22 Oct 1998 10:54:20 -0400
Message-Id: <362F4852.5302207B@insightdist.com>
Date: Thu, 22 Oct 1998 10:59:30 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: angg <angg@vng.ru>
Cc: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] C++ Builder (Delphi), ODBC and large objects
References: <01bdfdab$c94f6320$0b02a8c0@mis1>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



angg wrote:

> Byron, I tried to build driver with MS Visual C++ 5.0, but the proces failed
> with the following messages:
> [...]
> C:\Program Files\DevStudio\MyProjects\psqlodbc\execute.c(132) : warning
> C4229: anachronism used : modifiers on data are ignored
> gpps.c
> info.c
> C:\Program Files\DevStudio\MyProjects\psqlodbc\info.c(846) : error C2065:
> 'SQL_NUM_FUNCTIONS' : undeclared identifier
> C:\Program Files\DevStudio\MyProjects\psqlodbc\info.c(848) : error C2065:
> 'SQL_EXT_API_START' : undeclared identifier
> C:\Program Files\DevStudio\MyProjects\psqlodbc\info.c(848) : error C2065:
> 'SQL_EXT_API_LAST' : undeclared identifier
> [...]
>
> It isn't my compiler so I'm not sure it was installed properly. So far as
> can understand some *.h files are absent. Can you tell me which. I'm now
> seeking another opportunity to build the driver. I work to the North of
> Russia and it isn't a simple task :-).
>
> Mikhail.

Since I use VC4.0, which includes the old sql include files, there is not a
problem.

On VC5.0, the newer odbc 3.0 sql include files are used.  Therefore, the driver
needs to specify the ODBCVER explicitly, otherwise it defaults to 3.0 which is
the problem.

Solution:

1.  Somewhere in "psqlodbc.h", add the following line:

# define ODBCVER   0x0200

2. In connection.h, move the #include "psqlodbc.h" to prior to #ifdef HAVE_IODBC

3. In statement.h, move the #include "psqlodbc.h" to prior to #ifdef HAVE_IODBC

4. In convert.c, add the line #include "psqlodbc.h" prior to #ifdef HAVE_IODBC


As for the anachronism thing, you can either ignore it or just remove the
SQL_API keyword.


I will try to get these corrections into the next release.

Thanks,

Byron