为Sybase ASE15.x编译安装python-sybase模块

如果你有陈旧的vs2003编译器，那么这篇短文或者意义不是很大，
http://blog.donews.com/tekjian/archive/2006/08/06/990279.aspx 有简单的介绍如何直接安装这个玩意儿。
但是，现在很多人都用上了vs2005或者vs2008，可是python还是用的2.5.x版。这个时候痛苦就来了，
下载完python-sybase-0.38之后，如果你执行：
python setup.py intall,

肯定会出这样的错：

1. error: Python was built with Visual Studio 2003;  
2. extensions must be built with a compiler than can generate compatible binaries.  
3. Visual Studio 2003 was not found on this system. If you have Cygwin installed,  
4. you can try compiling with MingW32, by passing "-c mingw32" to setup.py.  

经过若干周折，发现，有办法绕过去，让vs2008直接支持编译安装。
先让sybase.bat环境变量生效，接着让vcvars.bat生效，(即执行这两个 bat)

把ASE15.x\OCS-150\lib下的三个文件libsyb*.lib,重命名为lib*.lib, 这三个新文件是：libct.lib, libcs.lib, libblk.lib

然后要修改python\Lib\distutils\msvccomiler.py, 找到：

1. # x86    
2. if self.__version >= 7:    
3.     self.__root = r"Software\Microsoft\VisualStudio"    
4.     self.__macros = MacroExpander(self.__version)    
5. else:    
6.     self.__root = r"Software\Microsoft\Devstudio"    

注释掉这一行：self.__macros = MacroExpander(self.__version)

之后，把对应的pyc文件删掉，让它强制重新编译。

设置两个环境变量：set DISTUTILS_USE_SDK=1
set MSSdk=1

这之后执行python setup.py install, 就可以完全成功的安装了。

以下是详细的编译安装结果：

1. E:\learn\db_research\python-sybase-0.39>python setup.py install  
2.   
3. ---------------------------------------------------------------------------  
4. This script requires setuptools version 0.6c6 to run (even to display  
5. help).  I will attempt to download it for you (from  
6. ), but  
7. you may need to enable firewall access for this script first.  
8. I will start the download in 15 seconds.  
9.   
10. (Note: if this machine does not have network access, please obtain the file  
11.   
12.    setuptools-0.6c6-py2.5.egg  
13.   
14. and place it in this directory before rerunning this script.)  
15. ---------------------------------------------------------------------------  
16. Downloading setuptools-0.6c6-py2.5.egg  
17. running install  
18. running bdist_egg  
19. running egg_info  
20. creating python_sybase.egg-info  
21. writing python_sybase.egg-info\PKG-INFO  
22. writing top-level names to python_sybase.egg-info\top_level.txt  
23. writing dependency_links to python_sybase.egg-info\dependency_links.txt  
24. writing manifest file 'python_sybase.egg-info\SOURCES.txt'  
25. reading manifest file 'python_sybase.egg-info\SOURCES.txt'  
26. writing manifest file 'python_sybase.egg-info\SOURCES.txt'  
27. installing library code to build\bdist.win32\egg  
28. running install_lib  
29. running build_py  
30. creating build  
31. creating build\lib.win32-2.5  
32. copying Sybase.py -> build\lib.win32-2.5  
33. running build_ext  
34. building 'sybasect' extension  
35. creating build\temp.win32-2.5  
36. creating build\temp.win32-2.5\Release  
37. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcblk.c /Fobuild\temp.win32-2.5\Release\blk.obj  
38. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
39. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
40. blk.c  
41. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcdatabuf.c /Fobuild\temp.win32-2.5\Release\databuf.obj  
42. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
43. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
44. databuf.c  
45. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tccmd.c /Fobuild\temp.win32-2.5\Release\cmd.obj  
46. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
47. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
48. cmd.c  
49. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcconn.c /Fobuild\temp.win32-2.5\Release\conn.obj  
50. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
51. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
52. conn.c  
53. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcctx.c /Fobuild\temp.win32-2.5\Release\ctx.obj  
54. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
55. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
56. ctx.c  
57. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcdatafmt.c /Fobuild\temp.win32-2.5\Release\datafmt.obj  
58. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
59. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
60. datafmt.c  
61. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tciodesc.c /Fobuild\temp.win32-2.5\Release\iodesc.obj  
62. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
63. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
64. iodesc.c  
65. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tclocale.c /Fobuild\temp.win32-2.5\Release\locale.obj  
66. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
67. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
68. locale.c  
69. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcmsgs.c /Fobuild\temp.win32-2.5\Release\msgs.obj  
70. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
71. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
72. msgs.c  
73. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcnumeric.c /Fobuild\temp.win32-2.5\Release\numeric.obj  
74. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
75. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
76. numeric.c  
77. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcmoney.c /Fobuild\temp.win32-2.5\Release\money.obj  
78. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
79. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
80. money.c  
81. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcdatetime.c /Fobuild\temp.win32-2.5\Release\datetime.obj  
82. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
83. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
84. datetime.c  
85. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcdate.c /Fobuild\temp.win32-2.5\Release\date.obj  
86. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
87. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
88. date.c  
89. C:\tools\vs9\VC\BIN\cl.exe /c /nologo /Ox /MD /W3 /GX /DNDEBUG -DWANT_BULKCOPY -DHAVE_DATETIME -DHAVE_DECIMAL -DHAVE_BLK_ALLOC -DHAVE_BLK_DESCRIBE -DHAVE_BLK_DROP -DHAVE_BLK_ROWXFER_MULT -DHAVE_BLK_TEXTXFER -DHAVE_CT_CURSOR -DHAVE_CT_DATA_INFO -DHAVE_CT_DYNAMIC -DHAVE_CT_SEND_DATA -DHAVE_CT_SETPARAM -DHAVE_CS_CALC -DHAVE_CS_CMP -ID:\sybase\OCS-15_0\include -Id:\tools\python\include -Id:\tools\python\PC /Tcsybasect.c /Fobuild\temp.win32-2.5\Release\sybasect.obj  
90. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release  
91. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'  
92. sybasect.c  
93. C:\tools\vs9\VC\BIN\link.exe /DLL /nologo /INCREMENTAL:NO /LIBPATH:D:\sybase\OCS-15_0\lib /LIBPATH:d:\tools\python\libs /LIBPATH:d:\tools\python\PCBuild libblk.lib libct.lib libcs.lib /EXPORT:initsybasect build\temp.win32-2.5\Release\blk.obj build\temp.win32-2.5\Release\databuf.obj build\temp.win32-2.5\Release\cmd.obj build\temp.win32-2.5\Release\conn.obj build\temp.win32-2.5\Release\ctx.obj build\temp.win32-2.5\Release\datafmt.obj build\temp.win32-2.5\Release\iodesc.obj build\temp.win32-2.5\Release\locale.obj build\temp.win32-2.5\Release\msgs.obj build\temp.win32-2.5\Release\numeric.obj build\temp.win32-2.5\Release\money.obj build\temp.win32-2.5\Release\datetime.obj build\temp.win32-2.5\Release\date.obj build\temp.win32-2.5\Release\sybasect.obj /OUT:build\lib.win32-2.5\sybasect.pyd /IMPLIB:build\temp.win32-2.5\Release\sybasect.lib  
94. LINK : fatal error LNK1181: cannot open input file 'libblk.lib'  
95. error: command 'link.exe' failed with exit status 1181  
96.   
97. E:\learn\db_research\python-sybase-0.39>python setup.py install  
98. running install  
99. running bdist_egg  
100. running egg_info  
101. writing python_sybase.egg-info\PKG-INFO  
102. writing top-level names to python_sybase.egg-info\top_level.txt  
103. writing dependency_links to python_sybase.egg-info\dependency_links.txt  
104. reading manifest file 'python_sybase.egg-info\SOURCES.txt'  
105. writing manifest file 'python_sybase.egg-info\SOURCES.txt'  
106. installing library code to build\bdist.win32\egg  
107. running install_lib  
108. running build_py  
109. running build_ext  
110. building 'sybasect' extension  
111. C:\tools\vs9\VC\BIN\link.exe /DLL /nologo /INCREMENTAL:NO /LIBPATH:D:\sybase\OCS-15_0\lib /LIBPATH:d:\tools\python\libs /LIBPATH:d:\tools\python\PCBuild libblk.lib libct.lib libcs.lib /EXPORT:initsybasect build\temp.win32-2.5\Release\blk.obj build\temp.win32-2.5\Release\databuf.obj build\temp.win32-2.5\Release\cmd.obj build\temp.win32-2.5\Release\conn.obj build\temp.win32-2.5\Release\ctx.obj build\temp.win32-2.5\Release\datafmt.obj build\temp.win32-2.5\Release\iodesc.obj build\temp.win32-2.5\Release\locale.obj build\temp.win32-2.5\Release\msgs.obj build\temp.win32-2.5\Release\numeric.obj build\temp.win32-2.5\Release\money.obj build\temp.win32-2.5\Release\datetime.obj build\temp.win32-2.5\Release\date.obj build\temp.win32-2.5\Release\sybasect.obj /OUT:build\lib.win32-2.5\sybasect.pyd /IMPLIB:build\temp.win32-2.5\Release\sybasect.lib  
112.    Creating library build\temp.win32-2.5\Release\sybasect.lib and object build\temp.win32-2.5\Release\sybasect.exp  
113. creating build\bdist.win32  
114. creating build\bdist.win32\egg  
115. copying build\lib.win32-2.5\Sybase.py -> build\bdist.win32\egg  
116. copying build\lib.win32-2.5\sybasect.pyd -> build\bdist.win32\egg  
117. copying build\lib.win32-2.5\sybasect.pyd.manifest -> build\bdist.win32\egg  
118. byte-compiling build\bdist.win32\egg\Sybase.py to Sybase.pyc  
119. creating stub loader for sybasect.pyd  
120. byte-compiling build\bdist.win32\egg\sybasect.py to sybasect.pyc  
121. creating build\bdist.win32\egg\EGG-INFO  
122. writing python_sybase.egg-info\native_libs.txt  
123. copying python_sybase.egg-info\PKG-INFO -> build\bdist.win32\egg\EGG-INFO  
124. copying python_sybase.egg-info\SOURCES.txt -> build\bdist.win32\egg\EGG-INFO  
125. copying python_sybase.egg-info\dependency_links.txt -> build\bdist.win32\egg\EGG-INFO  
126. copying python_sybase.egg-info\top_level.txt -> build\bdist.win32\egg\EGG-INFO  
127. zip_safe flag not set; analyzing archive contents...  
128. creating dist  
129. creating 'dist\python_sybase-0.39-py2.5-win32.egg' and adding 'build\bdist.win32\egg' to it  
130. removing 'build\bdist.win32\egg' (and everything under it)  
131. Processing setuptools-0.6c6-py2.5.egg  
132. Copying setuptools-0.6c6-py2.5.egg to d:\tools\python\lib\site-packages  
133. Adding setuptools 0.6c6 to easy-install.pth file  
134. Installing easy_install-script.py script to d:\tools\python\Scripts  
135. Installing easy_install.exe script to d:\tools\python\Scripts  
136. Installing easy_install-2.5-script.py script to d:\tools\python\Scripts  
137. Installing easy_install-2.5.exe script to d:\tools\python\Scripts  
138.   
139. Installed d:\tools\python\lib\site-packages\setuptools-0.6c6-py2.5.egg  
140. Processing dependencies for setuptools==0.6c6  
141. Finished processing dependencies for setuptools==0.6c6  
142. Processing python_sybase-0.39-py2.5-win32.egg  
143. Copying python_sybase-0.39-py2.5-win32.egg to d:\tools\python\lib\site-packages  
144. Adding python-sybase 0.39 to easy-install.pth file  
145.   
146. Installed d:\tools\python\lib\site-packages\python_sybase-0.39-py2.5-win32.egg  
147. Processing dependencies for python-sybase==0.39  
148. Finished processing dependencies for python-sybase==0.39  

经此实验，可以确定不一定要安装vc7,就可以安装一些要编译的python模块了。 当然，如果你机器上可以安装，最省事儿了。至于vc7，你完全可以自己整理出一个解压缩的绿色包，也就20来兆的样子。