<div>
try this: 'DSN=micros;UID=custom;PWD<wbr />=custom'
</div>


try this: 'DSN=micros;UID=custom;PWD=custom'

<div>
and also a side note, if you're using odbc, you have to make sure that you have an odbc data source named micros that has your server name in it
</div>


and also a side note, if you're using odbc, you have to make sure that you have an odbc data source named micros that has your server name in it

<div>
Thanks Wilcoxon, just need to adjust your solution.
</div>


Thanks Wilcoxon, just need to adjust your solution.

<div>
<div class="content wysiwyg-content">
Hi, <br />
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.<br />
<br />
I have the batch file (export.bat)<br />

<div class="indent">
REM Generate File<br />
<br />
d:<br />
cd \Export\<br />
<br />
dbisql -q SalesExport1.sql<br />
<br />
REM End of Script
</div>
<br />
When I run this I get the error<br />
Unable to open database connection.<br />
[Sybase][ODBC Driver][SQL Anywhere]Database server not found[Sybase][ODBC Driver<br />
][SQL Anywhere]Database server not found<br />
<br />
SalesExport1.sql<br />

<div class="indent">
//Import Routine <br />
<br />
connect custom identified by custom;<br />
<br />
SELECT item…………………….
</div>
<br />
<br />
I have tried these two connection also:<br />
<br />
dbisql.exe &quot;UID=custom;PWD=custom&quot;;<br />
CONNECT<br />
USING 'UID=custom;PWD=custom;DBN<wbr />=micros';<br />
<br />
I am running Interactive SQL Version 11.0.1, build 2596<br />
<br />
What should the connection string be?
</div>
</div>


Hi, 
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

d:
cd \Export\

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

SalesExport1.sql
//Import Routine 

connect custom identified by custom;

SELECT item…………………….


I have tried these two connection also:

dbisql.exe "UID=custom;PWD=custom";
CONNECT
USING 'UID=custom;PWD=custom;DBN=micros';

I am running Interactive SQL Version 11.0.1, build 2596

What should the connection string be?

dbisql

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.