Hi,

I use ODBC connection (64 bits ODBC driver) to access to a SQL AnyWhere V12 database on a Windows 64 bits PC. If I have an error in Interactive SQL (ex simple syntax error), the error message comes after a very long time (45 secondes). If I use instead 32 bits ODBC driver on the same database, then error message comes immediately, which is much more what I want. Is there any parameter to adjust to avoid such long answer ?

Denis

asked 08 Feb '16, 04:35

Denelbe2's gravatar image

Denelbe2
11112
accept rate: 0%


Wrt. to the delayed error message, a similar question was posted before: Delay in Error message. Short version of the answer: install local help files to speed up the reaction. For details please follow the link.

IMHO the bitness of the ODBC driver won't change the behaviour as dramatically as you observed. Using different versions of ISQL (dbisql vs. dbisqlc) might be one possible cause.

permanent link

answered 08 Feb '16, 07:47

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334583
accept rate: 11%

edited 08 Feb '16, 08:44

Mark%20Culp's gravatar image

Mark Culp
23.2k9132273

1

Unless you are really using the Generic ODBC Driver method to connect to your database, Interactive SQL uses the JDBC driver, not the ODBC driver. Under the hood the JDBC driver is using some common code that is also part of the ODBC driver. But I don't think the choice of JDBC or ODBC driver is the issue here. I'd expect your ODBC test to exhibit approximately the same speed whether using the 64-bit driver or the 32-bit driver.

(09 Feb '16, 12:01) JBSchueler

Thanks for reply and sorry for long delay; yes the problem appears with dbisql and not with dbisqlc. I saw in the linked post that a patch exists, I will try to install it.

Denis

permanent link

answered 24 Feb '16, 09:10

Denelbe2's gravatar image

Denelbe2
11112
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×125
×6

question asked: 08 Feb '16, 04:35

question was seen: 382 times

last updated: 24 Feb '16, 09:10