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.

how do I connect to -xs http using odbc ON asa 9

3 posts in General Discussion Last posting was on 2004-03-24 15:10:42.0Z
Gordon Johnson Posted on 2004-03-24 05:22:00.0Z
Reply-To: "Gordon Johnson" <gjohnson@intellimed.com>
From: "Gordon Johnson" <gjohnson@intellimed.com>
Newsgroups: ianywhere.public.general
Subject: how do I connect to -xs http using odbc ON asa 9
Lines: 35
Organization: Intellimed
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ip68-230-108-159.ph.ph.cox.net
X-Original-NNTP-Posting-Host: ip68-230-108-159.ph.ph.cox.net
Message-ID: <40611af8$1@forums-1-dub>
Date: 23 Mar 2004 21:22:00 -0800
X-Trace: forums-1-dub 1080105720 68.230.108.159 (23 Mar 2004 21:22:00 -0800)
X-Original-Trace: 23 Mar 2004 21:22:00 -0800, ip68-230-108-159.ph.ph.cox.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2831
Article PK: 6302

Here is my server configureation for my ASA 9 server.
-ch768M
-cl768M
-gt1
-n dev
-xs http(port=80)
f:\datawip\workit.db

I have configured my firewall to NAT http for a public IP to this servers
private IP.

I have tried to setup an ODBC connection and I get the message connection
failed database server not found.

Here is the DSN information
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ref3]
"Driver"="D:\\Program Files\\Sybase\\SQL Anywhere 9\\win32\\dbodbc9.dll"
"UID"="correct user"
"PWD"="correct password"
"DatabaseName"="workit"
"EngineName"="dev"
"AutoStop"="YES"
"PreventNotCapable"="NO"
"Integrated"="NO"
"Debug"="NO"
"DisableMultiRowFetch"="NO"
"CommLinks"="TCPIP{host=208.178.77.109:HTTP}"
"Compress"="No"

Please let me know If I can connect via pure HTTP through an ODBC
connection.

Thanks.


Reg Domaratzki Posted on 2004-03-24 15:05:14.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40611af8$1@forums-1-dub>
Subject: Re: how do I connect to -xs http using odbc ON asa 9
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <4061a3a6$1@forums-2-dub>
X-Original-Trace: 24 Mar 2004 07:05:10 -0800, rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Mar 2004 07:05:11 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Mar 2004 07:05:14 -0800
X-Trace: forums-1-dub 1080140714 10.22.108.75 (24 Mar 2004 07:05:14 -0800)
X-Original-Trace: 24 Mar 2004 07:05:14 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2837
Article PK: 6308

Starting with -xs http is running a web server, and accepts connections from
web browsers, not an ASA client. An ASA client can connect to the server
using TCP/IP, SPX or Shared Memory.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Gordon Johnson" <gjohnson@intellimed.com> wrote in message
news:40611af8$1@forums-1-dub...
> Here is my server configureation for my ASA 9 server.
> -ch768M
> -cl768M
> -gt1
> -n dev
> -xs http(port=80)
> f:\datawip\workit.db
>
> I have configured my firewall to NAT http for a public IP to this servers
> private IP.
>
> I have tried to setup an ODBC connection and I get the message connection
> failed database server not found.
>
> Here is the DSN information
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ref3]
> "Driver"="D:\\Program Files\\Sybase\\SQL Anywhere 9\\win32\\dbodbc9.dll"
> "UID"="correct user"
> "PWD"="correct password"
> "DatabaseName"="workit"
> "EngineName"="dev"
> "AutoStop"="YES"
> "PreventNotCapable"="NO"
> "Integrated"="NO"
> "Debug"="NO"
> "DisableMultiRowFetch"="NO"
> "CommLinks"="TCPIP{host=208.178.77.109:HTTP}"
> "Compress"="No"
>
> Please let me know If I can connect via pure HTTP through an ODBC
> connection.
>
> Thanks.
>
>


Graeme Perrow Posted on 2004-03-24 15:10:42.0Z
From: Graeme Perrow <gperrowNO@SPAMianywhere.PLEASEcom>
Reply-To: gperrowNO@SPAMianywhere.PLEASEcom
Organization: iAnywhere Solutions, Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: how do I connect to -xs http using odbc ON asa 9
References: <40611af8$1@forums-1-dub>
In-Reply-To: <40611af8$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gperrow-pc.sybase.com
Message-ID: <4061a4eb$1@forums-2-dub>
X-Original-Trace: 24 Mar 2004 07:10:35 -0800, gperrow-pc.sybase.com
Lines: 57
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Mar 2004 07:10:36 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Mar 2004 07:10:42 -0800
X-Trace: forums-1-dub 1080141042 10.22.108.75 (24 Mar 2004 07:10:42 -0800)
X-Original-Trace: 24 Mar 2004 07:10:42 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2838
Article PK: 6316

The -xs switch starts web services, which listens for HTTP and HTTPS
connections, eg. from browsers and other HTTP clients. ODBC doesn't use
HTTP. You need to start the TCP port (add -x tcpip to your server start
line), and remove the ":HTTP" from your CommLinks parameter.

You'll also have to configure your firewall to allow access to port
2638, which is the default TCP port used by ASA.

Graeme Perrow
Senior Software Developer
gperrow@ianywhere.com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

Gordon Johnson wrote:
> Here is my server configureation for my ASA 9 server.
> -ch768M
> -cl768M
> -gt1
> -n dev
> -xs http(port=80)
> f:\datawip\workit.db
>
> I have configured my firewall to NAT http for a public IP to this servers
> private IP.
>
> I have tried to setup an ODBC connection and I get the message connection
> failed database server not found.
>
> Here is the DSN information
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ref3]
> "Driver"="D:\\Program Files\\Sybase\\SQL Anywhere 9\\win32\\dbodbc9.dll"
> "UID"="correct user"
> "PWD"="correct password"
> "DatabaseName"="workit"
> "EngineName"="dev"
> "AutoStop"="YES"
> "PreventNotCapable"="NO"
> "Integrated"="NO"
> "Debug"="NO"
> "DisableMultiRowFetch"="NO"
> "CommLinks"="TCPIP{host=208.178.77.109:HTTP}"
> "Compress"="No"
>
> Please let me know If I can connect via pure HTTP through an ODBC
> connection.
>
> Thanks.
>
>