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.

SQL Anywhere Open Server Gateway

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-09-18 18:47:35.0Z
Jeff McConathy Posted on 1997-09-17 00:03:18.0Z
Message-ID: <341F1E46.E8CFE5EB@ix.netcom.com>
Date: Tue, 16 Sep 1997 17:03:18 -0700
From: Jeff McConathy <mcconath@ix.netcom.com>
Reply-To: bigmac2000@msn.com
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: SQL Anywhere Open Server Gateway
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 62
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:269
Article PK: 252021

I'm having trouble with the SQL.INI file and dbos50.exe.

In developing a web site using a series of applets to interact with SQL
Anywhere, I had to use the Open Server Gateway. So I set my SQL.INI file

to the following and ran dbos50.exe:

[OSGtwy]
master=NLWNSCK,localhost,1498
query=NLWNSCK,localhost,1498

where localhost is my development machine host name using Sun's Java Web

Server. This has worked great and I've been able to access my SQL
Anywhere server without problems throughout the development process.

Now I'm trying to make the site public so I've put the web server online

with an accessible IP address, and figured that changing my SQL.INI file

to the following would work:

[OSGtwy]
master=NLWNSCK,207.90.181.110,1498
query=NLWNSCK,207.90.181.110,1498

but it doesn't. Now when I try to start the gateway, I receive the
following error message:

* All rights reserved. Sybase is a trademark of Sybase, Inc.
* Sybase SQL Server Runtime Components:
* libsrv/10.0.3/P/PC Intel/Windows NT 3.1/1/OPT/Aug 1 1995 23:42:55
* Log Filename: OSGtwy.wos

* Tue Sep 16 12:01:37 1997 Open Server Gateway Started
* Tue Sep 16 12:01:41 1997 Gateway failed to initialize. List of
common problems:
* (1) An Open Server Gateway of this Name/Address is already started.

* (2) Network problems (or machine not found).
* (3) Sybase Open Server Components are installed incorrectly.
* (4) Server name 'Master' entry in the Interfaces File is:
* (a) not found (can be case sensitive); please create one.
* (b) incorrect; please verify format and information.
* (c) in use by another service; please choose unique address.
* Run SQLEDIT and select 'Help On SQLEDIT' from the 'Help' menu.
* Contact your Network Administrator.
* Tue Sep 16 12:01:41 1997 Error Code #16240, Severity 20 CS error :
Net-Library routine net_listen failed in srv__start_net
* Network error: status = 23 - Net-Lib protocol driver call to
register a listener failed

* OS error : Operating system error: -1 - Error in resolving the
hostname - Error is 11001

* Tue Sep 16 12:01:41 1997 Open Server Gateway Stopped

Any clues as to why this wouldn't work? Anyone know where there is
decent documentation for this?
My OS is Win95 and I'm using SQL Anywhere Open Server Gateway version
5.5.01 build #1333 along with SQL Anywhere 5.5.01 and jConnect 2.2


David Clegg Posted on 1997-09-18 17:45:17.0Z
Message-ID: <342168AD.57499E25@sybase.com>
Date: Thu, 18 Sep 1997 10:45:17 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: bigmac2000@msn.com
Subject: Re: SQL Anywhere Open Server Gateway
References: <341F1E46.E8CFE5EB@ix.netcom.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 78
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:255
Article PK: 252007

I'm not going to try to guess why this worked using localhost
in your development environment ... but SQLAnywhere generally
listens on port 1498 for tcp/udp communications in a SQL-Anywhere
specific protocol. I suspect that you are now trying to run
your OSG and S/A on the same machine whereas before they were
on different boxes. You now have a conflict on port 1498, and
you need to change your sql.ini to give OSG a different port number.
You can just pick any unused port.

dave

Jeff McConathy wrote:
>
> I'm having trouble with the SQL.INI file and dbos50.exe.
>
> In developing a web site using a series of applets to interact with SQL
> Anywhere, I had to use the Open Server Gateway. So I set my SQL.INI file
>
> to the following and ran dbos50.exe:
>
> [OSGtwy]
> master=NLWNSCK,localhost,1498
> query=NLWNSCK,localhost,1498
>
> where localhost is my development machine host name using Sun's Java Web
>
> Server. This has worked great and I've been able to access my SQL
> Anywhere server without problems throughout the development process.
>
> Now I'm trying to make the site public so I've put the web server online
>
> with an accessible IP address, and figured that changing my SQL.INI file
>
> to the following would work:
>
> [OSGtwy]
> master=NLWNSCK,207.90.181.110,1498
> query=NLWNSCK,207.90.181.110,1498
>
> but it doesn't. Now when I try to start the gateway, I receive the
> following error message:
>
> * All rights reserved. Sybase is a trademark of Sybase, Inc.
> * Sybase SQL Server Runtime Components:
> * libsrv/10.0.3/P/PC Intel/Windows NT 3.1/1/OPT/Aug 1 1995 23:42:55
> * Log Filename: OSGtwy.wos
>
> * Tue Sep 16 12:01:37 1997 Open Server Gateway Started
> * Tue Sep 16 12:01:41 1997 Gateway failed to initialize. List of
> common problems:
> * (1) An Open Server Gateway of this Name/Address is already started.
>
> * (2) Network problems (or machine not found).
> * (3) Sybase Open Server Components are installed incorrectly.
> * (4) Server name 'Master' entry in the Interfaces File is:
> * (a) not found (can be case sensitive); please create one.
> * (b) incorrect; please verify format and information.
> * (c) in use by another service; please choose unique address.
> * Run SQLEDIT and select 'Help On SQLEDIT' from the 'Help' menu.
> * Contact your Network Administrator.
> * Tue Sep 16 12:01:41 1997 Error Code #16240, Severity 20 CS error :
> Net-Library routine net_listen failed in srv__start_net
> * Network error: status = 23 - Net-Lib protocol driver call to
> register a listener failed
>
> * OS error : Operating system error: -1 - Error in resolving the
> hostname - Error is 11001
>
> * Tue Sep 16 12:01:41 1997 Open Server Gateway Stopped
>
> Any clues as to why this wouldn't work? Anyone know where there is
> decent documentation for this?
> My OS is Win95 and I'm using SQL Anywhere Open Server Gateway version
> 5.5.01 build #1333 along with SQL Anywhere 5.5.01 and jConnect 2.2


Jeff McConathy Posted on 1997-09-18 18:47:35.0Z
Message-ID: <34217746.3104BA7F@msn.com>
Date: Thu, 18 Sep 1997 11:47:35 -0700
From: Jeff McConathy <bigmac2000@msn.com>
Reply-To: bigmac2000@msn.com
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: SQL Anywhere Open Server Gateway
References: <341F1E46.E8CFE5EB@ix.netcom.com> <342168AD.57499E25@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 93
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:253
Article PK: 252004

Just wanted to let anyone interested know I got it working. The problem was
that my IP address wasn't registered with a DNS, so when I tried to start the
Gateway it failed since it wasn't able to locate a host name. By associating
my Domain Name to my IP in my ISP's DNS everything worked great. BTW, I have
my S/A and OSG on the same machine and there is no conflict with port 1498...

Hope this helps anyone else having similar problems.

David Clegg wrote:

> I'm not going to try to guess why this worked using localhost
> in your development environment ... but SQLAnywhere generally
> listens on port 1498 for tcp/udp communications in a SQL-Anywhere
> specific protocol. I suspect that you are now trying to run
> your OSG and S/A on the same machine whereas before they were
> on different boxes. You now have a conflict on port 1498, and
> you need to change your sql.ini to give OSG a different port number.
> You can just pick any unused port.
>
> dave
>
> Jeff McConathy wrote:
> >
> > I'm having trouble with the SQL.INI file and dbos50.exe.
> >
> > In developing a web site using a series of applets to interact with SQL
> > Anywhere, I had to use the Open Server Gateway. So I set my SQL.INI file
> >
> > to the following and ran dbos50.exe:
> >
> > [OSGtwy]
> > master=NLWNSCK,localhost,1498
> > query=NLWNSCK,localhost,1498
> >
> > where localhost is my development machine host name using Sun's Java Web
> >
> > Server. This has worked great and I've been able to access my SQL
> > Anywhere server without problems throughout the development process.
> >
> > Now I'm trying to make the site public so I've put the web server online
> >
> > with an accessible IP address, and figured that changing my SQL.INI file
> >
> > to the following would work:
> >
> > [OSGtwy]
> > master=NLWNSCK,207.90.181.110,1498
> > query=NLWNSCK,207.90.181.110,1498
> >
> > but it doesn't. Now when I try to start the gateway, I receive the
> > following error message:
> >
> > * All rights reserved. Sybase is a trademark of Sybase, Inc.
> > * Sybase SQL Server Runtime Components:
> > * libsrv/10.0.3/P/PC Intel/Windows NT 3.1/1/OPT/Aug 1 1995 23:42:55
> > * Log Filename: OSGtwy.wos
> >
> > * Tue Sep 16 12:01:37 1997 Open Server Gateway Started
> > * Tue Sep 16 12:01:41 1997 Gateway failed to initialize. List of
> > common problems:
> > * (1) An Open Server Gateway of this Name/Address is already started.
> >
> > * (2) Network problems (or machine not found).
> > * (3) Sybase Open Server Components are installed incorrectly.
> > * (4) Server name 'Master' entry in the Interfaces File is:
> > * (a) not found (can be case sensitive); please create one.
> > * (b) incorrect; please verify format and information.
> > * (c) in use by another service; please choose unique address.
> > * Run SQLEDIT and select 'Help On SQLEDIT' from the 'Help' menu.
> > * Contact your Network Administrator.
> > * Tue Sep 16 12:01:41 1997 Error Code #16240, Severity 20 CS error :
> > Net-Library routine net_listen failed in srv__start_net
> > * Network error: status = 23 - Net-Lib protocol driver call to
> > register a listener failed
> >
> > * OS error : Operating system error: -1 - Error in resolving the
> > hostname - Error is 11001
> >
> > * Tue Sep 16 12:01:41 1997 Open Server Gateway Stopped
> >
> > Any clues as to why this wouldn't work? Anyone know where there is
> > decent documentation for this?
> > My OS is Win95 and I'm using SQL Anywhere Open Server Gateway version
> > 5.5.01 build #1333 along with SQL Anywhere 5.5.01 and jConnect 2.2