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