Thank you. I finally got it working after a really several hours.
the connection string is: python imdbpy2sql.py -d C:/imdb/zipped/ -u
mssql://david:[EMAIL PROTECTED]/imdb --ms-sqlserver
The trickiest part was that you MUST have a single backslash between the
machine name and the sql server instance name. and between the instance name
and the database you MUST use a forward slash! That was really hard to
figure out! No idea why but thats what it took. Very painful.
But it still has issues with indentity_insert and database locking. I'm
going to modify the script to get it to work I think.
Thanks
Dave
On Wed, Jun 4, 2008 at 2:04 PM, Davide Alberani <[EMAIL PROTECTED]>
wrote:
> On Jun 03, David Jones <[EMAIL PROTECTED]> wrote:
>
> > Can someone send me a dummy proof connection string for sql server?
>
> Hi,
> I fear I can't be of any help, since I've never used MS SQL.
>
> Anyway, I assume that you must invoke imdbpy2sql.py with a command
> line like this one:
> imdbpy2sql.py --ms-sqlserver -d /directory/with/PlainTextDataFiles/ -u
> mssql://userName:[EMAIL PROTECTED]/databaseName
>
>
> HTH,
> --
> Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47]
> http://erlug.linux.it/~da/ <http://erlug.linux.it/%7Eda/>
>
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
