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.

Unable to connect to database engine

5 posts in General Discussion Last posting was on 2002-09-26 15:33:52.0Z
David Posted on 2002-09-19 15:00:33.0Z
From: David
Date: Thu, 19 Sep 2002 11:00:33 -0400
Newsgroups: ianywhere.public.general
Subject: Unable to connect to database engine
Message-ID: <3EF90CB97386DD40005272A685256C39.005272BC85256C39@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:605
Article PK: 2423

hi !

I have trouble with my SQL Anywhere 5.0.

I have installed SQL Anywhere 5.0 on my machine and I try to connect to a
sybase server on a distant machine with ISQL throught ODBC.

But a popup message appears and said "Unable to start database engine".

I don't understand why i've got this message.

Could anyone help me, please ?


Robert Waywell Posted on 2002-09-20 20:23:31.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <3EF90CB97386DD40005272A685256C39.005272BC85256C39@webforums>
Subject: Re: Unable to connect to database engine
Date: Fri, 20 Sep 2002 16:23:31 -0400
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <yNiNMWOYCHA.251@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:600
Article PK: 2418

You might want to move this question to the
sybase.public.sqlanywhere.general newsgroup.

When you post there, you should provide the server command line and the
connection parameters you are using in ISQL. Note that ISQL in version 5.x
does not support ODBC as a connection protocol.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

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

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

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 iAnywhere
Developer Community at www.ianywhere.com/developer

<David> wrote in message
news:3EF90CB97386DD40005272A685256C39.005272BC85256C39@webforums...
> hi !
>
> I have trouble with my SQL Anywhere 5.0.
>
> I have installed SQL Anywhere 5.0 on my machine and I try to connect to a
> sybase server on a distant machine with ISQL throught ODBC.
>
> But a popup message appears and said "Unable to start database engine".
>
> I don't understand why i've got this message.
>
> Could anyone help me, please ?


David Posted on 2002-09-25 15:11:26.0Z
From: David
Date: Wed, 25 Sep 2002 11:11:26 -0400
Newsgroups: ianywhere.public.general
Subject: Re: Unable to connect to database engine
Message-ID: <DAD55AC3B033C270005371E585256C3F.00741D9085256C3A@webforums>
References: <3EF90CB97386DD40005272A685256C39.005272BC85256C39@webforums> <yNiNMWOYCHA.251@forums.sybase.com>
Lines: 38
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:591
Article PK: 2409

Thanks for your response

But I describe all the problem as I only give you the error message.

Here is the problem in details :

I have an SQL ANYWHERE 5.0 database on a server machine named
"fr1dbsybase".
I have an SQL CLIENT 5.0 on my machine.

I configure an ODBC connection on my machine.

I want to connect to the database with MS ACCESS via the ODBC connection.

But I got the error message :

[Sybase][ODBC Driver]Unable to connect to database server:unable to start
database engine (#-80)

--------
I tried something else. I uninstall the client on my machine and install
the server. I start the sample database "sademo" on my machine.
I install a client on another machine and I configure the ODBC connexion. I
tried to connect to this database and I SUCCESS IN CONNECTING TO THE
DATABASE with ISQL and MS ACCESS via ODBC.

I investigate and I saw that there is 2 network cards on the server
machine.
I stop the sample database "sademo" on my machine and I start the sample
database "sademo" on the server.
When it started, there is two IP address, and the first one is not on my
domain but the second is.

I can ping the IP address that is on my domain.
When I tried to connect to the database "sademo" via ISQL and MS ACCESS via
ODBC connexion , I failed in connecting.

I wonder if the problem is not the IP address ?

Can you help me please ?


Robert Waywell Posted on 2002-09-26 13:24:35.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <3EF90CB97386DD40005272A685256C39.005272BC85256C39@webforums> <yNiNMWOYCHA.251@forums.sybase.com> <DAD55AC3B033C270005371E585256C3F.00741D9085256C3A@webforums>
Subject: Re: Unable to connect to database engine
Date: Thu, 26 Sep 2002 09:24:35 -0400
Lines: 71
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <w8NKMIWZCHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: CPE014310004450.cpe.net.cable.rogers.com 24.102.227.16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:587
Article PK: 2405

The IP address is likely the issue. In your connection parameters you should
specify -x tcpip{myip=...}. You may have to do "host= .." too but the myip
parameter is a good starting point.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

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

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

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 iAnywhere
Developer Community at www.ianywhere.com/developer

<David> wrote in message
news:DAD55AC3B033C270005371E585256C3F.00741D9085256C3A@webforums...
> Thanks for your response
>
> But I describe all the problem as I only give you the error message.
>
> Here is the problem in details :
>
> I have an SQL ANYWHERE 5.0 database on a server machine named
> "fr1dbsybase".
> I have an SQL CLIENT 5.0 on my machine.
>
> I configure an ODBC connection on my machine.
>
> I want to connect to the database with MS ACCESS via the ODBC connection.
>
> But I got the error message :
>
> [Sybase][ODBC Driver]Unable to connect to database server:unable to start
> database engine (#-80)
>
> --------
> I tried something else. I uninstall the client on my machine and install
> the server. I start the sample database "sademo" on my machine.
> I install a client on another machine and I configure the ODBC connexion.
I
> tried to connect to this database and I SUCCESS IN CONNECTING TO THE
> DATABASE with ISQL and MS ACCESS via ODBC.
>
> I investigate and I saw that there is 2 network cards on the server
> machine.
> I stop the sample database "sademo" on my machine and I start the sample
> database "sademo" on the server.
> When it started, there is two IP address, and the first one is not on my
> domain but the second is.
>
> I can ping the IP address that is on my domain.
> When I tried to connect to the database "sademo" via ISQL and MS ACCESS
via
> ODBC connexion , I failed in connecting.
>
> I wonder if the problem is not the IP address ?
>
> Can you help me please ?


David Posted on 2002-09-26 15:33:52.0Z
From: David
Date: Thu, 26 Sep 2002 11:33:52 -0400
Newsgroups: ianywhere.public.general
Subject: Re: Unable to connect to database engine
Message-ID: <D234576334B2F6DD00557FA185256C40.004EC34085256C40@webforums>
References: <3EF90CB97386DD40005272A685256C39.005272BC85256C39@webforums> <yNiNMWOYCHA.251@forums.sybase.com> <DAD55AC3B033C270005371E585256C3F.00741D9085256C3A@webforums> <w8NKMIWZCHA.198@forums.sybase.com>
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:583
Article PK: 2398

Hi,

In the option of the ODBC configuration I enter this line in the start
command :

c:\sqlany50\win32\dbclient.exe -x tcpip{myip=...}

or
c:\sqlany50\win32\dbclient.exe -x tcpip{myip=...;host=...}


it doesn't work.

the server will return to us soon.
I will specify an IP in my domain machine and delete the other IP address
so that it will have only a single address IP specified.
And I will try the connection.

If you are any idea, or any solution, give it to me please.

Thanks for all