error when we use not trusted connection to SQL server

Sep 5, 2007 at 11:20 AM
Hello,

It's very helpful tool for me. Thanks.
However when we use option "-d" and we don't have trusted connection to SQL server we get following error:
...
bcp.exe "db.dbo.TableName" out TableName.txt -c -T -SServerName
Exception caught in Main()
---------------------------------------
The directory name is invalid

System.ComponentModel.Win32Exception

at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start()
at Elsasoft.ScriptDb.DatabaseScripter.ScriptTables(Boolean verbose, Database db, ScriptingOptions so, String outputDirectory, Boolean scriptData)
at Elsasoft.ScriptDb.DatabaseScripter.GenerateScript(String connStr, String outputDirectory, Boolean scriptData, Boolean verbose)
at Elsasoft.ScriptDb.Program.Main(String[] args)
---------------------------------------

I find your description about quick solution for that - it means that you use bcp tool. I change a little your program for my use and I only inform you and other people.
Nov 16, 2009 at 8:30 PM
Edited Nov 16, 2009 at 10:32 PM

My version posted as patch today is working with BCP and no trusted connection