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