Hi,
I'm trying to dump the IMDB interfaces files onto a Microsoft SQL Database
using SQL Server 2016 (trial) on a Windows Server 2012 R2 server so I can start
playing with the dataset. I already installed Python 2.7 and used pip install
Imdbpy successfully. My problem is when I use the following line to extract
the data "imdbpy2sql.py -d S:/imdbData/ -u mssql://GMDATASERVER/imdbGM?sspi=1
--ms-sqlserver" ... I get the following error:
C:\Users\Administrator>imdbpy2sql.py -d S:/imdbData/ -u
mssql://GMDATASERVER/imdbGM?sspi=1 --ms-sqlserver
Traceback (most recent call last):
File "C:\Python27\Scripts\imdbpy2sql.py", line 538, in <module>
conn = setConnection(URI, DB_TABLES)
File "C:\Python27\lib\site-packages\imdb\parser\sql\objectadapter.py", line
189, in setConnection
conn = connectionForURI(uri, **kw)
File "C:\Python27\lib\site-packages\sqlobject\dbconnection.py", line 1072, in
connectionForURI
conn = connCls.connectionFromURI(uri)
File "C:\Python27\lib\site-packages\sqlobject\dbconnection.py", line 154, in
connectionFromURI
return cls._connectionFromParams(*cls._parseURI(uri))
File "C:\Python27\lib\site-packages\sqlobject\mssql\mssqlconnection.py", line
101, in _connectionFromParams
host=host or 'localhost', port=port, db=path, **args)
File "C:\Python27\lib\site-packages\sqlobject\mssql\mssqlconnection.py", line
36, in __init__
'Cannot find an MSSQL driver, tried %s' % drivers)
ImportError: Cannot find an MSSQL driver, tried adodb,pymssql
C:\Users\Administrator>
Everything is installed on the same server (standalone).
Any help would be appreciated greatly.
Thanks.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
