Scenario: Windows XP running Sybase network server as a service under
version 10. Installation of version 11.0.1.2044 proceeds with no
problems.

Four of my databases run fine under 11, but one fails on starting the
service, with the following error (as recorded in sybase_log.txt):
QOUTE
Could not execute store DLL (dbcis11.dll) entry point
Database server shutdown due to startup error.
END QUOTE

Using Sybase Central, I can open the database that fails with no
reported problem. It also validates OK.

When I attempt to start the service using Sybase Central's service
control procedure, I see an 'unknown fault', with the above error line
in the sybase_log.txt file.

I have unloaded and recreated the database, but there is no change in
the error.

Has anyone come across this problem before? Is there a resolution?

You are almost certainly mixing-and-matching DLLs and server
executables. Check your installation and your path, and verify that you
don't have another dbcis11.dll somewhere on your machine.

Glenn

Richard Hinder wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

On Jan 20, 6:24*pm, "Glenn Paulley [Sybase iAnywhere]"
<paul... (AT) ianywhere (DOT) com> wrote:
Glenn - thanks for your interest.

I have Servoy installed, and Sybase Central. The only dbcis11.dll on
the machine is located in the SQL Anywhere sub folders: there is no
such dll in the Servoy sybase_db folder. My SQL Anywhere service runs
the Sybase installation contained within the Servoy Progam folder: not
that in the SQL Anywhere folder.

Note that this error has not occurred on previous upgrades (e.g. from
9 to 10). I have seen a dbcis11.dll error only once before, when
attempting to run a sybase db from a Windows machine under Mac OS X.

Richard

Hi Richard,

I'm not sure where to go from here, at least on this forum. I have seen
this error when using CIS services only in circumstances where there has
been a mismatch. Other than suggesting a re-install, or perhaps trying
to install an EBF, I can only suggest opening a case with technical
support to help sort this out.

Glenn

Richard Hinder wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Richard,

It is possible that you did not see the problem in previous versions of
SA simply because you did not need it before. Have you recently created
a remote data access server (using the CREATE SERVER) statement? If so,
then that is why the dbcis dll is now needed. Hence, the problem is due
to the fact that your Servoy install does not have dbcis11 installed and
the database you are trying to use needs dbcis11 due to a remote server
definition.

Karim
Richard Hinder wrote:

On Jan 20, 8:09*pm, "Karim Khamis [Sybase iAnywhere]"
<kkha... (AT) sybase (DOT) com> wrote:
Karim

Ah: you have excellent perception. I have tried to migrate the data
from the database to a new one some time ago, in a failed bid to get a
Windows version of the database working under Mac OS X. Although I
have been assured that the Windows and Mac databases are binary
compatible, I have found they do not transfer in practice. Hence the
need to migrate data.

Is it possible to remove that remote server history from the database
so that it proves not to be a hindrance to its starting under version
11? I will investigate here, but perhaps you have some knowledge to
share?

Richard

Verify that the version of SQL Anywhere provided by Servoy is the same
as your 11.0.1.2044 install - particularly the dbcis11.dll. NOTE a
missing dbcis11.dll reports the error:


Could not load the store DLL "dbcis11.dll"

whereas a mismatched version (I copied dbcis11.dll version 11.0.1.2044
over a newer EBF to test) will report the error:


Could not execute store DLL (dbcis11.dll) entry point

-chris

Richard Hinder wrote:

Richard,

RH> Ah: you have excellent perception. I have tried to migrate the data
RH> from the database to a new one some time ago, in a failed bid to get a
RH> Windows version of the database working under Mac OS X. Although I
RH> have been assured that the Windows and Mac databases are binary
RH> compatible, I have found they do not transfer in practice. Hence the
RH> need to migrate data.

Windows and MAC database should be binary compatible. Can you elaborate on the issues you had
copying the database from Windows to MAC?

--
Joshua Savill
Sybase Inc. - Product Manager


Richard Hinder wrote:

Richard,

Since it seems you no longer need remote data access, I would suggest
starting up the database with the installation that works (i.e. the
non-Servoy install) and dropping all remote servers using DROP SERVER.
You may need to explicitly drop all proxy tables first. Once you drop
all your remote data access servers, you should be good to go. You can
then shut down the server and restart the database with the Servoy install.

Karim
Richard Hinder wrote:

On Jan 20, 9:09*pm, "Josh Savill [Sybase]"
<no_spam_jsavill_no_s... (AT) sybase (DOT) com> wrote:
Joshua, Chris, Glenn, Karim
Thank you each for your input. As a result of your suggestions, I have
removed the remote servers from the database (using Sybase Central),
and the database is now operating as a service on the XP machine.

On the broader issue of migrating from Windows to Mac OS X, the
scenario is as follows:
Both Windows XP and Mac OS X 10.5.8 have the same Servoy installer now
installed (Servoy version 5.0.1), with the same version of Sybase SQL
Anywhere (11.0.1.2044).

Stopping both Windows and Mac SQL Anywhere services, I move the
database and transaction log from the Windows machine to a USB memory
stick. Once loaded in the memory, I transfer the memory stick to the
Mac.

On the Mac, the Finder shows the ex-Windows database as a unix
executable.

On attempting to connect to the database on the memory stick using
Sybase Central, I get the following error:

Wed Jan 20 2010 22:09:17
22:09:17 Attempting to connect using:
UID=DBA;PWD=********;DBF=/Volumes/RAH_1GB/database/
example.db;CON=SQL_DBC_100a5e400;LOG=/var/folders/jb/jbwKO9CwEym0fLKqZL
+BVk+++TI/-Tmp-/testcon2146119911662960412.tmp
22:09:17 Attempting to connect to a running server...
22:09:17 Trying to start SharedMemory link ...
22:09:17 SharedMemory link started successfully
22:09:17 Attempting SharedMemory connection (no sasrv.ini cached
address)
22:09:17 Failed to connect over SharedMemory
22:09:17 No server found, attempting to start a personal server...
22:09:22 Autostarted server, attempting to connect using:
UID=DBA;PWD=********;DBF=/Volumes/RAH_1GB/database/
example.db;CON=SQL_DBC_100a5e400;LOG=/var/folders/jb/jbwKO9CwEym0fLKqZL
+BVk+++TI/-Tmp-/testcon2146119911662960412.tmp
22:09:22 Attempting SharedMemory connection (no sasrv.ini cached
address)
22:09:22 Connected to server over SharedMemory
22:09:22 Connected to SQL Anywhere Server version 11.0.1.2045
22:09:22 Application information:
22:09:22 IP=192.168.11.108;HOST=richard-hinders-macbook-
pro.local;OSUSER=Richard;OS='Darwin 9.8.0 i386';EXE=/Applications/
SQLAnywhere11/SybaseCentral.app/Contents/MacOS/
JavaApplicationStub;PID=0x1fb0;THREAD=0x12e24f000; VERSION=11.0.1.2045;API=iAnywhereJDBC;TIMEZONEADJU STMENT=0
22:09:22 Connected to the server, attempting to connect to a running
database...
22:09:22 Database is running, but could not connect to it
22:09:22 Unable to start specified database: Unknown error (1)
22:09:22 Communication function i_cs_HandleSQLPresError code 5
22:09:22 Communication function StrmGetInd code 2

Does this suggest a way forward?