Hi Amy and Gonzalo, does this happens also without --ms-sqlserver? Another option is to run it with the -o sqlalchemy to use another ORM (shouldn't change much...)
Besides this, I fear you have to debug this issue looking at the logs of the db, and see why it get stuck. Basically, imdbpy2sql.py before writing of a batch of data executes, for some tables, something like: SET IDENTITY_INSERT $table ON; and after the insert: SET IDENTITY_INSERT $table off; if I remember correctly, it was needed for tables with auto-increment values. Maybe something was changed in the latest versions of MSSQL? HTH, On Sat, Apr 22, 2017 at 7:49 PM, Amy Garcia Kennedy <ceci...@gmail.com> wrote: > Hey Gonzalo, > > did you find a solution to this? I have the same problem. > > thanks! > > El viernes, 6 de enero de 2017, 16:48:07 (UTC+1), Gonzalo Martinez escribió: >> >> Hi, >> >> I ran "pip install pymssql" and it is working now but it makes me wonder >> why it did not install when running "pip install imdbpy" in the first place? >> >> Now, I have some issues because the following line "imdbpy2sql.py -d >> S:/imdbData/ -u >> mssql://GMDATASERVER\Administrator:Pa$$w0rd@GMDATASERVER/imdbGM >> --ms-sqlserver" stalled an is stuck at this point... >> >> EXECUTING "BEFORE_MOVIES_TODB:SET IDENTITY_INSERT %(table)s >> ON;"...EXECUTING "SET IDENTITY_INSERT title ON;"... >> >> It's been 2h+ and it hasn't moved so there something wrong I'm sure. >> >> I'm using python 2.7 (the latest available at the moment from python.org), >> Windows Server 2012R2 and SQL Server 2016 trial... all is fully patched. >> >> >> >> >> Thanks for any help you guys can provide me. >> >> >> >> >> >> ---- On Fri, 06 Jan 2017 07:28:24 -0500 Davide Alberani >> <davide....@gmail.com> wrote ---- >> >> On Wed, Jan 4, 2017 at 6:31 PM, Gonzalo Martinez <in...@gamartto.com> >> wrote: >> > >> > ImportError: Cannot find an MSSQL driver, tried adodb,pymssql >> >> Hi Gonzalo, >> have you also installed the pymssql package? >> >> HTH, >> >> -- >> Davide Alberani <davide....@gmail.com> [PGP KeyID: 0x3845A3D4AC9B61AD] >> http://www.mimante.net/ >> >> > -- Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x3845A3D4AC9B61AD] http://www.mimante.net/ ------------------------------------------------------------------------------ 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
