Re: [INTERNALS-WIN] Re: ext/odbc no longer builds under VC6

On Sun, Dec 14, 2008 at 7:08 PM, Steph Fox <steph@php.net> wrote: > OK, going back to the public list. > >> First of all, my patches have been tested to work on VC6 (both 32 and >> 64bit) before i released it to the PHP public. > > Right. Support for 64-bit ODBC came with Windows Server 2003 (see > http://msdn.microsoft.com/en-us/library/ms716287(VS.85).aspx). > Presumably > that means we lose support for earlier versions if we move to this API? What > about Windows 2000 Server, where do we stand with support for that these > days? > > (NB we only dropped support for Windows 98 two years ago.) > >> Secondly, to my knowledge, the header files and libraries for developing >> ODBC enabled applications on Windows is not part of the compiler itself but >> of either the Platform SDK or the MDAC package installed. > > I believe the odbc stuff was shipped with the compiler, but... whatever. It is in the platform SDK. See below. > It's not clear to me which MDAC package I should be downloading to get > SQLLEN defined in the headers/libs. Do you know which you're using? Here is what is in the sqltypes.h header (SDK 2003/02): /* API declaration data types */ typedef unsigned char SQLCHAR; #if (ODBCVER >= 0x0300) typedef signed char SQLSCHAR; typedef unsigned char SQLDATE; typedef unsigned char SQLDECIMAL; typedef double SQLDOUBLE; typedef double SQLFLOAT; #endif typedef long SQLINTEGER; typedef unsigned long SQLUINTEGER; #ifdef _WIN64 typedef INT64 SQLLEN; typedef UINT64 SQLULEN; typedef UINT64 SQLSETPOSIROW; #else #define SQLLEN SQLINTEGER #define SQLULEN SQLUINTEGER #define SQLSETPOSIROW SQLUSMALLINT #endif //For Backward compatibility #ifdef WIN32 typedef SQLULEN SQLROWCOUNT; typedef SQLULEN SQLROWSETSIZE; typedef SQLULEN SQLTRANSID; typedef SQLLEN SQLROWOFFSET; #endif I tested again using a fresh installed windows XP Pro, VC6 Enterprise SP6, and the platform SDK 2003/02 without any other dependency (deps/ or php_builds/ are empty) and it compiles fine. I can pack the include and lib directories from the SDK in a zip and upload it somewhere if you need them. Cheers, -- Pierre http://blog.thepimp.net | http://www.libgd.org