Hi, I would like to start using OOo in my organization to replace my Excel VBA that I am currently using to create reports based on information in a .csv file. I would like to hold the data in a MySQL database instead of the .csv file also. In order to conveniently control the data in the MySQL database, I want to use Python, specifically the MySQL-python-1.2.1_p2 set of modules. All of the workstations would be WinXP. How can I install modules so that the OOo's Python will be able to use them. I manually installed the files to the "\OpenOffice.org 2.0\program\python-core-2.3.4\lib\site-packages" directory. The import of MySQLdb will work in a python script, but If I try to actually use anything, I receive an error stating:
"com.sun.star.uno.RuntimeExceptionexceptions.AttributeError: 'module' object has no attribute 'connect', traceback follows ... line 73, in createTable" where line 73 of the script looks like: db = MySQLdb.connect(host="dcs002", user="", passwd="", db="test") I know that the connection process works, because when I tested it with my actual python installation all went well. I assume that the OOo Python installation is just not recognizing the module properly, but maybe I'm just not applying it properly. Any help would be greatly appreciated. OOo is version 2.0.4 on WinXP, binary downloaded from OOo site. Thank You, Mike Elkevizth --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
