Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbisql.exe missing for 64 bit installation

2 posts in General Discussion Last posting was on 2011-05-09 07:26:35.0Z
Igor Posted on 2011-05-06 08:30:49.0Z
Sender: 4a36.4dc2b011.1804289383@sybase.com
From: Igor
Newsgroups: ianywhere.public.general
Subject: dbisql.exe missing for 64 bit installation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4dc3b1b9.7a53.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 May 2011 01:30:49 -0700
X-Trace: forums-1-dub 1304670649 10.22.241.41 (6 May 2011 01:30:49 -0700)
X-Original-Trace: 6 May 2011 01:30:49 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8140
Article PK: 7159

Hello, when installing SQL Anywhere 11.0.1 on an x64 windows
XP machine, I notice that dbisql.exe is present in the bin32
folder, but not the bin64 folder. This is causing us
problems as we are using 64 bit ODBC data sources, and the
bin32\dbisql.exe application that we use to execute SQL
scripts cannot recognise them. We could always use the
dbisqlc.exe application which does exist in the bin32 and
bin64 folders, but I understand that this is a deprecated
version of dbisql.exe.
Regards..


Volker Barth <No_VBarth Posted on 2011-05-09 07:26:35.0Z
From: Volker Barth <No_VBarth@Spam_GLOBAL-FINANZ.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: dbisql.exe missing for 64 bit installation
References: <4dc3b1b9.7a53.1681692777@sybase.com>
In-Reply-To: <4dc3b1b9.7a53.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4dc7972b$1@forums-1-dub>
Date: 9 May 2011 00:26:35 -0700
X-Trace: forums-1-dub 1304925995 10.22.241.152 (9 May 2011 00:26:35 -0700)
X-Original-Trace: 9 May 2011 00:26:35 -0700, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8141
Article PK: 7158

Igor,

to quote from 11.0.1 docs
(http://dcx.sybase.com/index.html#1101/en/dbprogramming_en11/pg-deploy-win-step2.html):

"On most platforms, the Java-based administration tools are 32-bit
applications. Except for Mac OS X, there are no 64-bit versions. The
32-bit administration tools can be deployed on x64-based platforms where
the 32-bit JRE is available."


64-bit administration tools (Interactive SQL and Sybase Central) are
available from 12.0.0 and above.

IMHO, it should be possible to
a) add 32-bit DSNs (with same contents as the 64-bit ones) and let
dbisql use them or
b) run dbisql without DSN by specifying an according connection string,
i.e. something like
dbisql -c "ENG=Myserver;DBN=MyDb;UID=dba;PWD=...;LINKS=TCPIP...."



HTH
Volker

P.S. dbisqlc.exe is still available in v12 and still under (limited)
development so from my point of view, there's nothing uncommon in using
dbisqlc.exe for running scripts:)

Igor wrote:
> Hello, when installing SQL Anywhere 11.0.1 on an x64 windows
> XP machine, I notice that dbisql.exe is present in the bin32
> folder, but not the bin64 folder. This is causing us
> problems as we are using 64 bit ODBC data sources, and the
> bin32\dbisql.exe application that we use to execute SQL
> scripts cannot recognise them. We could always use the
> dbisqlc.exe application which does exist in the bin32 and
> bin64 folders, but I understand that this is a deprecated
> version of dbisql.exe.
> Regards..