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.

internet

5 posts in General Discussion Last posting was on 2003-10-22 17:23:40.0Z
Alain Posted on 2003-10-22 13:05:04.0Z
Reply-To: "Alain" <aoehrli@solofours.ch>
From: "Alain" <aoehrli@solofours.ch>
Newsgroups: ianywhere.public.general
Subject: internet
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 212.147.49.193
X-Original-NNTP-Posting-Host: 212.147.49.193
Message-ID: <3f968080@forums-1-dub>
Date: 22 Oct 2003 06:05:04 -0700
X-Trace: forums-1-dub 1066827904 212.147.49.193 (22 Oct 2003 06:05:04 -0700)
X-Original-Trace: 22 Oct 2003 06:05:04 -0700, 212.147.49.193
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1889
Article PK: 4139

Hello,

I use ASA 7.0.0.430
Is it possible to do a connection between scview and a database server by
internet ?
I configured the name of the database, server, the tcpip address, but I
have the message "Database server not running".

I did a connection with Symantec pcanywhere.

Thanks

Alain


Reg Domaratzki Posted on 2003-10-22 13:44:24.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3f968080@forums-1-dub>
Subject: Re: internet
Lines: 33
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: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <3f9689b8@forums-1-dub>
Date: 22 Oct 2003 06:44:24 -0700
X-Trace: forums-1-dub 1066830264 172.31.143.163 (22 Oct 2003 06:44:24 -0700)
X-Original-Trace: 22 Oct 2003 06:44:24 -0700, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1890
Article PK: 4141

Yes, it is certainly possible.

What was the start line for the database server engine?

--
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

"Alain" <aoehrli@solofours.ch> wrote in message
news:3f968080@forums-1-dub...
> Hello,
>
> I use ASA 7.0.0.430
> Is it possible to do a connection between scview and a database server by
> internet ?
> I configured the name of the database, server, the tcpip address, but I
> have the message "Database server not running".
>
> I did a connection with Symantec pcanywhere.
>
> Thanks
>
> Alain
>
>


abt Posted on 2003-10-22 16:02:30.0Z
Sender: dd0.3f96aa8a.1804289383@sybase.com
From: abt@mixnet.net
Newsgroups: ianywhere.public.general
Subject: iAnywhere 9.0
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f96ab10.dd9.846930886@sybase.com>
References: <3f968080@forums-1-dub><3f9689b8@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 22 Oct 2003 09:06:41 -0700, 10.22.241.42
Lines: 12
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Oct 2003 08:55:33 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Oct 2003 09:02:30 -0700
X-Trace: forums-1-dub 1066838550 10.22.108.75 (22 Oct 2003 09:02:30 -0700)
X-Original-Trace: 22 Oct 2003 09:02:30 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1893
Article PK: 4144

Good day,
II have a *.db file that is SYBASE data according to my
customer. I am not sure whether this is a SYBASE export file
or a table. I am not sure how SYBASE stores its data.

I need to convert this file into a fixed ASCII file.

I do not have SYBASE installed. I have SQL Anywhere 9
installed.

Any help would be appreciated.
abt@mixnet.net


Breck Carter [TeamSybase] Posted on 2003-10-22 17:23:40.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: iAnywhere 9.0
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <c7edpvsib4tj7h1rodpem7q71v3n8bm6vr@4ax.com>
References: <3f968080@forums-1-dub><3f9689b8@forums-1-dub> <3f96ab10.dd9.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 22 Oct 2003 10:23:40 -0700
X-Trace: forums-1-dub 1066843420 64.7.134.118 (22 Oct 2003 10:23:40 -0700)
X-Original-Trace: 22 Oct 2003 10:23:40 -0700, bcarter.sentex.ca
Lines: 34
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1894
Article PK: 4142

The .DB file may be a SQL Anywhere database of some version or
another. You may be able to open it with SQL Anywhere 9. You can use
this .BAT file to start the database

"%ASANY9%\win32\dbeng9.exe" xxx.db

Then you can use Start - Programs - SQL Anywhere 9 - Sybase Central to
view it with a GUI, or run ISQL with this .BAT file:

"%ASANY9%\win32\dbisql.exe" -c "ENG=xxx;DBN=xxx;UID=dba;PWD=sql"


Breck

On 22 Oct 2003 09:02:30 -0700, abt@mixnet.net wrote:

>Good day,
>II have a *.db file that is SYBASE data according to my
>customer. I am not sure whether this is a SYBASE export file
>or a table. I am not sure how SYBASE stores its data.
>
>I need to convert this file into a fixed ASCII file.
>
>I do not have SYBASE installed. I have SQL Anywhere 9
>installed.
>
>Any help would be appreciated.
>abt@mixnet.net

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Greg Fenton Posted on 2003-10-22 14:35:18.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: internet
References: <3f968080@forums-1-dub>
In-Reply-To: <3f968080@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3f9695a6$1@forums-1-dub>
Date: 22 Oct 2003 07:35:18 -0700
X-Trace: forums-1-dub 1066833318 172.31.140.253 (22 Oct 2003 07:35:18 -0700)
X-Original-Trace: 22 Oct 2003 07:35:18 -0700, gfenton-xp.sybase.com
Lines: 32
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1892
Article PK: 4143


Alain wrote:
> Is it possible to do a connection between scview and a database server by
> internet ?

Yes, I do this all the time.

However, if you are going to be going through different routers,
subnets, etc... then it is likely that the client broadcast that
searches for the server will fail.

I always include the following "advanced" connection property when
connecting:

LINKS=tcpip{host=<my_ip_address>;dobroadcast=direct}

See the following page in the ASA 7.x online docs:

ASA Adaptive Server Anywhere Reference Manual
CHAPTER 3. Connection and Communication Parameters
Network communications parameters
- DoBroadcast parameter

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/