[python] adodb 错误,求助
通过了 adodb 的doc 试联了一下MSSQL,但是总有报错,额,虽然是个小问题,但怎么也解决不了,各位高手帮我看看问题出哪里,小的就此拜过
代码如下
--------------------------------------------------------------------
import adodb
if __name__ == "__main__":
conn = adodb.NewADOConnection('mssql') # mxodbc required
conn.Connect("Driver={SQL Server};Server=localhost;Database=python;")
cursor = conn.Execute('select * from python_test')
while not cursor.EOF:
print cursor.fields
cursor.MoveNext()
cursor.Close()
conn.Close()
-------------------------------------------------------------------
报错内容
-------------------------------------------------------------------
Traceback (most recent call last):
File "C:\Python\SQLTEST.PY", line 5, in <module>
conn.Connect("Driver={SQL Server};Server=localhost;Database=python;")
AttributeError: 'NoneType' object has no attribute 'Connect'
--------------------------------------------------------------------
mxodbc 已经安装。。。。,但是就是老报错,python关了再开过,SQL也在运行中。。。,数据库已生成,表已建。。。
print conn
>>>None
未生成 CONN。。。。。
NewADOConnection代码如下
--------------------------------------------------------------------
def NewADOConnection(modulename):
if modulename.find(':') >= 0:
'''无关内容隐了
'''
if modulename == 'oracle':
modulename = 'oci8'
try:
modulename = 'adodb_'+modulename
module = __import__(modulename,globals(), None, [modulename]) #就这里出问题了,IMPORT不进去,why,why,why
except ImportError:
return None
klass = vars(module)[modulename]
return klass()
--------------------------------------------------------------------
继续深入找问题
>>> modulename = 'adodb_mssql'
>>> module = __import__(modulename,globals(), None, [modulename])
Traceback (most recent call last):
File "<pyshell#8>", line 1, in <module>
module = __import__(modulename,globals(), None, [modulename])
File "C:\Python\Lib\site-packages\adodb\adodb_mssql.py", line 7, in <module>
import adodb,adodb_pyodbc,datetime
File "C:\Python\Lib\site-packages\adodb\adodb_pyodbc.py", line 16, in <module>
import pyodbc
ImportError: No module named pyodbc # NND,这里说找不到pyodbc,我明明装好了。。。
>>>import pyodbc 铁证啊。。。,怎么这里又好了。。。,古怪古怪
>>>
--------------------------------------------------------------------
代码是ADODB的范例啊。。。。,怎么会报错。。。,那个地方配置的不对啊
运行环境 WINXP,MSSQL 2000,PY 2.6
哪位老大帮我看看问题出哪里了