请教,连接有密码的access数据库

nbfan

我照http://bbs.chinaunix.net/viewthread.php?tid=699906&extra=page%3D1%26filter%3Ddigest
帖子里的类连接没密码的access数据库都可以,但是我有个带密码的access数据库就不知道怎么连接了.
self.conn.Open(self.db) 这段代码我改成
self.conn.Open(self.db,'password')
是否正确?老提示错误.

1. Traceback (most recent call last):
   
2.   File "<interactive input>", line 1, in ?
   
3.   File "C:\Python24\lib\site-packages\win32com\gen_py\2A75196C-D9EB-4129-B803-931327F72D5Cx0x2x8.py", line 2069, in Open
   
4.     , UserID, Password, Options)
   
5.   File "C:\Python24\Lib\site-packages\win32com\client\__init__.py", line 446, in _ApplyTypes_
   
6.     return self._get_good_object_(
   
7. com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '[Microsoft][ODBC \xc7\xfd\xb6\xaf\xb3\xcc\xd0\xf2\xb9\xdc\xc0\xed\xc6\xf7] \xce\xb4\xb7\xa2\xcf\xd6\xca\xfd\xbe\xdd\xd4\xb4\xc3\xfb\xb3\xc6\xb2\xa2\xc7\xd2\xce\xb4\xd6\xb8\xb6\xa8\xc4\xac\xc8\xcf\xc7\xfd\xb6\xaf\xb3\xcc\xd0\xf2', None, 0, -2147467259), None)

复制代码

nbfan

奇怪今天用这个类怎么什么数据库也看不了了.
提示

1. 
   
2. Traceback (most recent call last):
   
3.   File "C:\Python24\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 310, in RunScript
   
4.     exec codeObject in __main__.__dict__
   
5.   File "G:\dd.py", line 61, in ?
   
6.     main()
   
7.   File "G:\dd.py", line 58, in main
   
8.     db.printrcd()
   
9.   File "G:\dd.py", line 30, in printrcd
   
10.     for i in range(self.rs.Fields.count):
    
11.   File "C:\Python24\Lib\site-packages\win32com\client\__init__.py", line 454, in __getattr__
    
12.     raise AttributeError, "'%s' object has no attribute '%s'" % (repr(self), attr)
    
13. AttributeError: '<win32com.gen_py.Microsoft ActiveX Data Objects 2.8 Library.Fields instance at 0x18045888>' object has no attribute 'count'
    

复制代码

nbfan

for i in range(self.rs.Fields.count):
这个count 要大写,晕

ghostwwl

其实只要改连接字符串  就可以了 ，至于连接字符串这块的内容
在介绍ado的相关文章和教程都有