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.

JConnect with SQL Anywhere

4 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-16 13:33:32.0Z
Kreg Holgerson Posted on 1997-07-15 00:20:18.0Z
Message-ID: <33CAC242.5D5@cloudscape.com>
Date: Mon, 14 Jul 1997 17:20:18 -0700
From: Kreg Holgerson <kreg@cloudscape.com>
Reply-To: kreg@cloudscape.com
X-Mailer: Mozilla 3.0 (WinNT; I)
MIME-Version: 1.0
Subject: JConnect with SQL Anywhere
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:548
Article PK: 252302

I am having difficulty in getting jConnect working with the SADEMO
database that comes with SQL Anywhere. The first problem I am having is
getting the Open Server Gateway setup. I have followed the directions
that come with jConnect on SQL Anywhere, but I am still in need for more
detail.

Can anyone get me going?


Don Blair Posted on 1997-07-15 22:10:37.0Z
Message-ID: <33CBF55D.7FE5@sybase.com>
Date: Tue, 15 Jul 1997 18:10:37 -0400
From: Don Blair <dblair@sybase.com>
Reply-To: dblair@sybase.com
Organization: Powersoft
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: kreg@cloudscape.com
CC: dblair
Subject: Re: JConnect with SQL Anywhere
References: <33CAC242.5D5@cloudscape.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:544
Article PK: 252295


Kreg Holgerson wrote:
>
> I am having difficulty in getting jConnect working with the SADEMO
> database that comes with SQL Anywhere. The first problem I am having is
> getting the Open Server Gateway setup. I have followed the directions
> that come with jConnect on SQL Anywhere, but I am still in need for more
> detail.
>
> Can anyone get me going?

Are you connecting to a local or remote database?
I can't give the official Sybase party line, but I
can tell you how I connect to SQL Anywhere on my
local machine.

Make sure you installed Open Server components when you
installed SQL Anywhere. This sets up the SYBASE environ
variable and adds to your PATH. Make sure you rebooted
system aferwards. I've heard that you need at least
Version 5.5.02 for both the gateway and SQL Server itself.

Run C:\sybase\bin\sqledit to configure a port for
the gateway. Here's my resultant SQL.INI file:

[SYBSERVER1]
query=NLWNSCK,localhost,4444
master=NLWNSCK,localhost,4444

Start up the SQL Anywhere database.

Start the open Server Gateway:

cd C:\sqlany50\win32
start dbos50 SYBSERVER1

Then connect using

Class.forName("com.sybase.jdbc.SybDriver");
DriverManager.getConnection("jdbc:sybase:Tds:localhost:4444", "dba",
"sql");

The URL is from memory, but I think I got it right.

Don

Don


Kreg Holgerson Posted on 1997-07-16 00:48:48.0Z
Message-ID: <33CC1A70.6876@cloudscape.com>
Date: Tue, 15 Jul 1997 17:48:48 -0700
From: Kreg Holgerson <kreg@cloudscape.com>
Reply-To: kreg@cloudscape.com
X-Mailer: Mozilla 3.0 (WinNT; I)
MIME-Version: 1.0
Subject: Re: JConnect with SQL Anywhere
References: <33CAC242.5D5@cloudscape.com> <33CBF55D.7FE5@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 45
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:543
Article PK: 252296

I am working against the local SADEMO SQL Anywhere database. Does the
SADEMO name need to be included anywhere in the sql.ini file? Also, how
can I tell if the Gateway is running? When I tried your example, after
typing "start dbos50 SADEMO" at the DOS prompt nothing appeared.

Thanks

Don Blair wrote:
>
> Kreg Holgerson wrote:
> >
> > I am having difficulty in getting jConnect working with the SADEMO
> > database that comes with SQL Anywhere. The first problem I am having is
> > getting the Open Server Gateway setup. I have followed the directions
> > that come with jConnect on SQL Anywhere, but I am still in need for more
> > detail.
> >
> > Can anyone get me going?
>
> Are you connecting to a local or remote database?
> I can't give the official Sybase party line, but I
> can tell you how I connect to SQL Anywhere on my
> local machine.
>
> Make sure you installed Open Server components when you
> installed SQL Anywhere. This sets up the SYBASE environ
> variable and adds to your PATH. Make sure you rebooted
> system aferwards. I've heard that you need at least
> Version 5.5.02 for both the gateway and SQL Server itself.
>
> Run C:\sybase\bin\sqledit to configure a port for
> the gateway. Here's my resultant SQL.INI file:
>
> [SYBSERVER1]
> query=NLWNSCK,localhost,4444
> master=NLWNSCK,localhost,4444
>
> Start up the SQL Anywhere database.
>
> Start the open Server Gateway:
>
> cd C:\sqlany50\win32
> start dbos50 SYBSERVER1
>
> Then connect using
>
> Class.forName("com.sybase.jdbc.SybDriver");
> DriverManager.getConnection("jdbc:sybase:Tds:localhost:4444", "dba",
> "sql");
>
> The URL is from memory, but I think I got it right.
>
> Don
>
> Don


Don Blair Posted on 1997-07-16 13:33:32.0Z
Message-ID: <33CCCDAC.3859@sybase.com>
Date: Wed, 16 Jul 1997 09:33:32 -0400
From: Don Blair <dblair@sybase.com>
Reply-To: dblair@sybase.com
Organization: Powersoft
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: kreg@cloudscape.com
CC: dblair
Subject: Re: JConnect with SQL Anywhere
References: <33CAC242.5D5@cloudscape.com> <33CBF55D.7FE5@sybase.com> <33CC1A70.6876@cloudscape.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 66
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:539
Article PK: 252291


Kreg Holgerson wrote:
>
> I am working against the local SADEMO SQL Anywhere database. Does the
> SADEMO name need to be included anywhere in the sql.ini file?

SQL.INI gives the Open Server name and port number for
the Open Server gateway. These are used by Open Clients
to connect to the gateway, but do not affect what database
the gateway connects to.

DBOS50 has command-line options which tell it what
SQL Anywhere server/database to connect to. Presumably,
an open server gateway can only be connected to 1 server/database.
For instance, to connect the gateway to the webdemo database
on an sademo server, you would use this:

start DBOS50 -d webdemo -e sademo OPENSERVER1

where OPENSERVER1 is the open server name assigned in the
SQL.INI file. In my example, the gateway must default
to "-d sademo -e sademo" since I didn't specify.

> Also, how
> can I tell if the Gateway is running? When I tried your example, after
> typing "start dbos50 SADEMO" at the DOS prompt nothing appeared.

Try running sybping.exe.

Don


> Don Blair wrote:
> >
> > Kreg Holgerson wrote:
> > >
> > > I am having difficulty in getting jConnect working with the SADEMO
> > > database that comes with SQL Anywhere. The first problem I am having is
> > > getting the Open Server Gateway setup. I have followed the directions
> > > that come with jConnect on SQL Anywhere, but I am still in need for more
> > > detail.
> > >
> > > Can anyone get me going?
> >
> > Are you connecting to a local or remote database?
> > I can't give the official Sybase party line, but I
> > can tell you how I connect to SQL Anywhere on my
> > local machine.
> >
> > Make sure you installed Open Server components when you
> > installed SQL Anywhere. This sets up the SYBASE environ
> > variable and adds to your PATH. Make sure you rebooted
> > system aferwards. I've heard that you need at least
> > Version 5.5.02 for both the gateway and SQL Server itself.
> >
> > Run C:\sybase\bin\sqledit to configure a port for
> > the gateway. Here's my resultant SQL.INI file:
> >
> > [SYBSERVER1]
> > query=NLWNSCK,localhost,4444
> > master=NLWNSCK,localhost,4444
> >
> > Start up the SQL Anywhere database.
> >
> > Start the open Server Gateway:
> >
> > cd C:\sqlany50\win32
> > start dbos50 SYBSERVER1
> >
> > Then connect using
> >
> > Class.forName("com.sybase.jdbc.SybDriver");
> > DriverManager.getConnection("jdbc:sybase:Tds:localhost:4444", "dba",
> > "sql");
> >
> > The URL is from memory, but I think I got it right.
> >
> > Don
> >
> > Don