SQL Assistant 14.10 "The file name or directory is invalid" export to mdb MS Access error

Tools & Utilities
sp2
Fan

SQL Assistant 14.10 "The file name or directory is invalid" export to mdb MS Access error

Hi,

Since upgrading to SQL Assistant 14.10 from 13.11, the -e command for SQL Assistant throws an error.  Has anyone run into this issue or know how to resolve this problem?

TIA

 

here is the sample command line being used.

"C:\Program Files (x86)\Teradata\Client\14.10\Teradata SQL Assistant\sqla.exe" -c ODBC -f "C:\export_test.sql" -e "C:\test_123.mdb\A"

2 REPLIES
sp2
Fan

Re: SQL Assistant 14.10 "The file name or directory is invalid" export to mdb MS Access er

bump

Senior Apprentice

Re: SQL Assistant 14.10 "The file name or directory is invalid" export to mdb MS Access er

Hi,

I'd be surprised if that command worked on SQLA 13.11.

 

The "-e" parameter would seem to contain an invalid path/file name, it currently says:

-e "C:\test_123.mdb\A"

 

What does the '\A' on the end mean?

 

Have you tried removing that and running it again?

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com