This project is read-only.

error when we use not trusted connection to SQL server

Sep 5, 2007 at 12:20 PM

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


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 9:30 PM
Edited Nov 16, 2009 at 11:32 PM

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