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 Connection

2 posts in Internet Server Last posting was on 2011-07-21 07:34:59.0Z
Randall H. Carpenter Posted on 2011-07-21 00:46:40.0Z
From: "Randall H. Carpenter" <rhcarpenter@gcwins.com>
Newsgroups: Advantage.Internet_Server
Subject: Internet Connection
Date: Wed, 20 Jul 2011 20:46:40 -0400
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 174.111.99.228
Message-ID: <4e2776ec$1@solutions.advantagedatabase.com>
X-Trace: 20 Jul 2011 17:46:36 -0700, 174.111.99.228
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:841
Article PK: 1121095

I am trying to set up a new DB using the internet ServerType. I already
have one DB setup and working using the internet ServerType. I set it up
almost two years ago and it's working fine. It is accessed from a Delphi
application. Now I'm trying to setup an additional DB and I'm apparently
missing something. Your help will be appreciated.

The DB WHICH IS WORKING has the following connection properties:

ConnectionPath: \\67.xxx.xxx.xx7:6260\data\tippsdb.add
Username: AdsSys
TableType: adt
ServerType: internet
CommunicationType: tcp/ip
LockingMode: proprietary
CharType: ansi
SecurityMode: ignorerights
DBFTableType: cdx
BlankPassword: no

The DB dictionary FOR THIS WORKING CONNECTION has the following properties:

Name: TIPPSWEBDB
Paths
Database: \\67.xxx.xxx.xx7:6260\data\
Default: \\67.xxx.xxx.xx7:6260\data\TIPPSDB
Temp: \\67.xxx.xxx.xx7:6260\data\TIPPSDB
User Access: Logins Required is checked and Check User Rights is checked
Internet Access: Enabled is checked. Security Level is Authenticate &
Encrypt

I am trying create the new DB using Architect. In Architect, I am doing the
following:

File|New Connection Wizard
Select Create a connection to a new database; Select Next
Select Create a connection to a new data dictionary; Select Next
Name: TIPPSqsDB
Server Type: Remote Server
Paths:
Database: \\67.xxx.xxx.xx7:6260\data\
Default: \\67.xxx.xxx.xx7:6260\data\TIPPSqsDB
Temp: \\67.xxx.xxx.xx7:6260\data\TIPPSqsDB

When I click OK, I get a message that says "The database path does not
exist, create it?". If I select Yes, I get the message "Failed to create
directory." If I select No, I get the message "Error 7083: An Advantage
Data Dictionary connection is required. axServerConnect"

I think the problem is related to the path. On the physical drive, the
data\TIPPSqsDB is actually a subfolder of a path off the root of the
physical drive. The full path is:

C:\gcwdata\data\TIPPSqsDB

Apparently somewhere I have mapped the IP address of \\67.xxx.xxx.xx7:6260
to the physical path of c:\GCWData. But I don' t recall where that is done.

Please help. I need top get this going asap. Your help will be greatly
appreciated.

Randall H. Carpenter


Joachim Duerr (ADS) Posted on 2011-07-21 07:34:59.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Internet Connection
Newsgroups: Advantage.Internet_Server
References: <4e2776ec$1@solutions.advantagedatabase.com>
Date: Thu, 21 Jul 2011 09:34:59 +0200
User-Agent: XanaNews/1.19.1.269
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.29.66.130
Message-ID: <4e27d6c6$1@solutions.advantagedatabase.com>
X-Trace: 21 Jul 2011 00:35:34 -0700, 10.29.66.130
Lines: 19
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:842
Article PK: 1121094


Randall H. Carpenter wrote:

>I am trying create the new DB using Architect.

ARC uses the file system to create the files. You can't do it over the
internet.

The only possiblity I see: Create a connection to your location and run
a SQL statement:

CREAE DATABASE myDB

In order to connect to an internet port, a data dictionary with AIS
enabled has to exist prior the above mentioned steps (Login required).

--
Joachim Duerr, Advantage Presales
*** NEW *** Advantage Pocket Guide released *** NEW ***
http://pocketguide.jd-engineering.de