Connecting to Sybase ASE 12.5 and retrieving large datasets
Posted on 2008-10-29
Hiya - I can't quite believe how hard I am finding this.
I just need to run SQL against an Adaptive Server Enterprise 12.5 server and have the results (however large - base tables 35 M records) saved to a file.
I also need an ODBC driver so I can connect from MS Access - this will make everything soooo much easier.
Research led me to 'Workspace', which gives me a good view of the database objects and lets me create what it calls 'SQL files' to run ad-hoc SQl against the database.
It bombs out on large datasets though (Java Heap exceeded) and I can't see how to tell it to save the results straight to file.
I have tried to download Open Client from the Sybase website, but it tells me I need an account.
I have loaded the whole of SQL Anywhere 11 but it only loads ODBC drivers for 'iAnywhere Solutions 11 - Oracle', 'SQL Anywhere 11' and 'ultraLite 11'.
I have seen a suggestion to load the development version of ASE, which I will try next, but talk about a sledgehammer to crack an ODBC nut!