Hi everyone, in my script I'm trying to connect to a remote database using sqlalchemy. Since I'm pretty new to this library I'm not really sure of what I am doing :-). Up to now what I'm doing to connect to the database is this:
engine = create_engine("mysql:// my_username:my_passw...@phpmyadmin.myhost.com/my_db_name") metadata = MetaData(engine, reflect=True) If I run this script I get the following error: Traceback (most recent call last): File "C:\Documents and Settings\pc2\Desktop\prova.py", line 9, in <module> metadata = MetaData(engine, reflect=True) File "C:\Python25\lib\site-packages\sqlalchemy-0.6.0-py2.5.egg \sqlalchemy\schema.py", line 1770, in __init__ self.reflect() File "C:\Python25\lib\site-packages\sqlalchemy-0.6.0-py2.5.egg \sqlalchemy\schema.py", line 1879, in reflect connection=conn)) File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\engine\base.py", line 1604, in table_names conn = self.contextual_connect() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\engine\base.py", line 1592, in contextual_connect return self.Connection(self, self.pool.connect(), close_with_result=close_with_result, **kwargs) File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 154, in connect return _ConnectionFairy(self).checkout() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 318, in __init__ rec = self._connection_record = pool.get() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 173, in get return self.do_get() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 665, in do_get con = self.create_connection() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 134, in create_connection return _ConnectionRecord(self) File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 209, in __init__ self.connection = self.__connect() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\pool.py", line 271, in __connect connection = self.__pool._creator() File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\engine\strategies.py", line 76, in connect return dialect.connect(*cargs, **cparams) File "c:\python25\lib\site-packages\SQLAlchemy-0.6.0-py2.5.egg \sqlalchemy\engine\default.py", line 227, in connect return self.dbapi.connect(*cargs, **cparams) File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect return Connection(*args, **kwargs) File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__ super(Connection, self).__init__(*args, **kwargs2) OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'phpmyadmin.myhost.com' (10060)") None None Is there something I am missing? thanks in advance for the help! -- http://mail.python.org/mailman/listinfo/python-list