How to open a Sybase SQL Anywhere database and query its table?

The system already Sybase SQL installed. And under it's interactive SQL, I have used "SELECT * FROM allevents" to sucessfully queried the table. However, when I used autoit, it returns compiling error: "no such table: allevents" $hDB = _SQLite_Open ("C:\Database.db" = ":memory:") _SQLite_Exec ($hDB, "SELECT * FROM allevents")

By sfresher, October 2, 2008
14 replies

I successfully use ADO DB on Sybase ASE with this DSN string: "Driver={SYBASE SYSTEM 11};Srvr=%server%;Database=master;Uid=admin;Pwd=password;" You may also try to use Interactive SQL via its commandline.