I have a sql query that works in Interactive SQL, I would like to automate the query so I can the results in a file at the same time each day using dbisql.
I have the batch file (export.bat)
REM Generate File
dbisql -q SalesExport1.sql
REM End of Script
When I run this I get the error
Unable to open database connection.
[Sybase][ODBC Driver][SQL Anywhere]Database server not found[Sybase][ODBC Driver
][SQL Anywhere]Database server not found
connect custom identified by custom;
I have tried these two connection also:
I am running Interactive SQL Version 11.0.1, build 2596
What should the connection string be?