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 

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
    return self._connection_cls(self, **kwargs)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 881, in _
    self.__connection = connection or engine.raw_connection()
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2544, in
    return self.pool.unique_connection()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 183, in unique_c
    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_
    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
    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



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 :(


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.
Imdbpy-help mailing list

Reply via email to