# New to Adabas - Crystal Reports SQL problem

**URL:** <https://techcommunity.softwareag.com/t/new-to-adabas-crystal-reports-sql-problem/58283>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Add-on-Products, SQL-Access, Mainframe-Integration, CONNX\
**Created:** [April 30, 2007, 1:58pm UTC](https://techcommunity.softwareag.com/t/new-to-adabas-crystal-reports-sql-problem/58283 "2007-04-30T13:58:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt1](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Matt1](https://techcommunity.softwareag.com/u/Matt1)\
**Post date:** [April 30, 2007, 1:58pm UTC](https://techcommunity.softwareag.com/t/new-to-adabas-crystal-reports-sql-problem/58283/1 "2007-04-30T13:58:56Z")

</div>

Hi - New to Adabas. We have it installed by a 3rd party running on a custom Linux kernel behind a router and I don’t have direct access to the database - only to a set of views. I’m trying to pull off the last 24 hours production figures for all jobs run. I can do this easily on SQL Server and MySQL, but it falls over on the Adabas connections. With the other DBs I have set up custom views to do it server-side but as I don’t have access to the Adabas DB I can’t do that, and the suppliers don’t want to add a view because it then becomes a non-standard installation. I get the 3008 INVALID KEYWORD OR MISSING DELIMITER error and ACCESS VIOLATIONs. I’m also fairly new to Crystal - we’re trialing XI with the Entrprise Server - so having problems with their SQL Query editor as well but I have posts on the forum there too. Also, the Adabas connection seems quite slow. I’m using the ODBC connector V13.01.07.00 - is there a way to optimise the connection? The DB has aroung 250,000 records from the last 8 months or so and I now have to report on them.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:39pm UTC](https://techcommunity.softwareag.com/t/new-to-adabas-crystal-reports-sql-problem/58283/2 "2021-04-02T14:39:09Z")

</div>