The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

Usually, I start dbisqlc with an appropriate connection string.

However, when trying to connect interactively, I can only choose among ODBC datasources of the version, i.e. dbisclqc V8 lists only V8 DSNs, dbisqlc V12 lists only V12 DSNs, dbisqlc V11 only V11 DSNs. (As such, it' sno new problem.)

In contrast, DBISQL seems to do so by default, too, but has this "search" button to look for different DSNs.


Question: Have I met another dbisqlc restriction, or can this by changed by some option?

asked 21 Oct '10, 09:33

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646
accept rate: 32%

(21 Oct '10, 09:34) Volker Barth

dbisqlc (actually dbconX.dll) does explicitly filter the DSNs to those that are defined to use the SQL Anywhere ODBC driver of the same major version as dbisqlc and there is no way to get around that behaviour. I can only guess that the filtering was done because we didn't want to show non-SQLAnywhere DSNs. What would you expect -- would you want it to show all DSNs or just SQLAnywhere DSNs?

I also found that the 64-bit version of dbisqlc doesn't populate the DSN list at all.

Note that dbisqlc is a dblib application and doesn't use ODBC when you use a DSN. The DSN is only used to pick up connection parameters.

-john.

permanent link

answered 21 Oct '10, 20:30

John%20Smirnios's gravatar image

John Smirnios
8.7k377106
accept rate: 40%

John, thanks for explaining the behaviour. I guess it is something that has rarely caused problems for me, as I usually use engine and dbisqlc in the same version, and usually use predefined connect strings. I just noticed the behaviour when testing for http://sqlanywhere-forum.sap.com/questions/1240, when I switched between different versions, and noticed that DBISQL let choose me different DSNs. So this is not really a restriction in dbisqlc. - On the other hand, I conclude that DBISQL does extend dbconX.dll to search for different DSNs?

(22 Oct '10, 19:37) Volker Barth
1

dbisql doesn't use dbconX.dll -- it uses its own dialogs implemented in Java. It looks like dbmlsync is the only other thing that uses dbconX.dll. Assuming that team doesn't object to the change, I'll submit a fix for dbconX.dll to list all SQLAnywhere DSN's (at least v6 and up) for dbmlsync and dbisqlc. Otherwise, I'll make a different change for just dbisqlc.

(22 Oct '10, 20:34) John Smirnios

@John: That's good to hear (and more than I have expected given the somewhat "deprecated" state of dbisqlc). In my mind, if a change is made, then it would make sense that dbisqlc lists DSNs of those SA versions it can connect to. That will correspond to v6 and up, as you describe.

(24 Oct '10, 10:02) Volker Barth

FWIW, according to John this is fixed (with other topics) under CR 645986 cf. http://search.sybase.com/kbx/changerequests?bug_id=645986.

(28 Oct '10, 14:39) Volker Barth

I've had that problem too. If you know the data source name you might overcome that limitation with
CONNECT USING 'DSN=MyDSN'

permanent link

answered 21 Oct '10, 15:54

Reimer%20Pods's gravatar image

Reimer Pods
4.1k324278
accept rate: 12%

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:

×124
×17
×14

question asked: 21 Oct '10, 09:33

question was seen: 3,147 times

last updated: 21 Oct '10, 20:30