Davide Alberani <davide.alberani@...> writes: > > First of all, pardon for the long delay. :-/ > > Hmmm... not much, not knowing enough of SQL Server. > Maybe you can just try interfacing with it using SQLAlchemy, instead of the > default SQLObject. Try adding the "-o sqlalchemy" argument to the > imdbpy2sql.py command line... > > HTH, >
Hi David, no worries about the delay - we're all busy :) I should have stated in my original post also tried SQL Alchemy. Here's the output: --- c:\Python27\Scripts>python27 imdbpy2sql.py -d d:/install/imdb/subset/ -u "mssql+ pymssql://imdb:imdb@localhost/imdb" --ms-sqlserver -o sqlalchemy 2012-04-03 13:36:47,696 WARNING [imdbpy.parser.sql.alchemy] C:\Python27\lib\site -packages\imdb\parser\sql\alchemyadapter.py:38: Unable to import migrate.changes et: Foreign Keys will not be created. Traceback (most recent call last): File "imdbpy2sql.py", line 501, in <module> conn = setConnection(URI, DB_TABLES) File "C:\Python27\lib\site-packages\imdb\parser\sql\alchemyadapter.py", line 4 86, in setConnection eng_conn = engine.connect() File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2458, in connect return self._connection_cls(self, **kwargs) File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 881, in _ _init__ self.__connection = connection or engine.raw_connection() File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2544, in raw_connection return self.pool.unique_connection() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 183, in unique_c onnection return _ConnectionFairy(self).checkout() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 387, in __init__ rec = self._connection_record = pool._do_get() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 739, in _do_get con = self._create_connection() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 188, in _create_ connection return _ConnectionRecord(self) File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 270, in __init__ self.connection = self.__connect() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 330, in __connec t connection = self.__pool._creator() File "C:\Python27\lib\site-packages\sqlalchemy\engine\strategies.py", line 80, in connect return dialect.connect(*cargs, **cparams) File "C:\Python27\lib\site-packages\sqlalchemy\engine\default.py", line 285, i n connect return self.dbapi.connect(*cargs, **cparams) File "pymssql.pyx", line 549, in pymssql.connect (pymssql.c:7110) sqlalchemy.exc.OperationalError: (OperationalError) (20009, 'Net-Lib error durin g Unknown error') None None c:\Python27\Scripts> --- I have created a blank DB in SQL Server which I can connect to okay using SQL Server Management Studio. I would expect the error messages to be a little more helpful, perhaps stating the login is incorrect or something - but the last few lines seem to indicate something is broken :( Damien. ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help