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.

I can't connect to AIS with DBF's from VFP

2 posts in Internet Server Last posting was on 2010-05-17 23:10:29.0Z
Hugo Glez. Macias Posted on 2010-05-17 19:10:17.0Z
From: "Hugo Glez. Macias" <gomh7172@hotmail.com>
Newsgroups: Advantage.Internet_Server
Subject: I can't connect to AIS with DBF's from VFP
Date: Mon, 17 May 2010 14:10:17 -0500
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: 187.146.196.212
Message-ID: <4bf19406@solutions.advantagedatabase.com>
X-Trace: 17 May 2010 13:07:50 -0700, 187.146.196.212
Path: solutions.advantagedatabase.com!187.146.196.212
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:832
Article PK: 1121086

Hi,

I'm using OLDB, This is my original connectionString and this is working,

DirCliente = "L:\aplica\imss"
connectionString = "Provider=Advantage OLE DB Provider;"+;
"Data Source="+dirCliente+";"+;
"ServerType=ADS_REMOTE_SERVER;"+;
"DbfsUseNulls=TRUE;"+;
"TableType=ADS_CDX;" +;
"LOckMode=ADS_PROPRIETARY_LOCKING;"+;
"SecurityMode=ADS_CHECKRIGHTS;"+;
"CharType=ADS_OEM;"


but when I change the path "DirCliente" adding the remote server for example
DirCliente="\\pedgdl.imsslab.net\aplica\imss\"
TipoServ = "ADS_AIS_SERVER"
connectionString = "Provider=Advantage OLE DB Provider;"+;
"Data Source="+dirCliente+";"+;
"ServerType="+TipoServ+";"+;
"DbfsUseNulls=TRUE;"+;
"TableType=ADS_CDX;" +;
"LOckMode=ADS_PROPRIETARY_LOCKING;"+;
"SecurityMode=ADS_CHECKRIGHTS;"+;
"CharType=ADS_OEM;"

I get the error 6424 Advantage Could not find an ADS.INI file in the search
path

I need a file ADS.INI in the server ?
I need a file ADS.INI in the client ?

if it must go this file, How can I create this file whit what information ?

Somebody Can help me?
Thank's

Hugo


Joachim Duerr (ADS) Posted on 2010-05-17 23:10:29.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: I can't connect to AIS with DBF's from VFP
Newsgroups: Advantage.Internet_Server
References: <4bf19406@solutions.advantagedatabase.com>
Date: Tue, 18 May 2010 01:10:29 +0200
User-Agent: XanaNews/1.19.1.194
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
NNTP-Posting-Host: 84.158.170.46
Message-ID: <4bf1cc4c@solutions.advantagedatabase.com>
X-Trace: 17 May 2010 17:07:56 -0700, 84.158.170.46
Lines: 27
Path: solutions.advantagedatabase.com!84.158.170.46
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:833
Article PK: 1121085


Hugo Glez. Macias wrote:

>DirCliente="\\pedgdl.imsslab.net\aplica\imss\"
>TipoServ = "ADS_AIS_SERVER"
>connectionString = "Provider=Advantage OLE DB Provider;"+;
> "Data Source="+dirCliente+";"+;
> "ServerType="+TipoServ+";"+;
> "DbfsUseNulls=TRUE;"+;
> "TableType=ADS_CDX;" +;
> "LOckMode=ADS_PROPRIETARY_LOCKING;"+;
> "SecurityMode=ADS_CHECKRIGHTS;"+;
> "CharType=ADS_OEM;"
>
>I get the error 6424 Advantage Could not find an ADS.INI file in the
>search path

for AIS: if the connection is not specified in the connection string,
then the client searches for the definition in the ads.ini file. It
should be enough to add the Internet-Port to your path - and a data
dictionary, since this is an AIS requirement:

DirCliente="\\pedgdl.imsslab.net:2001\aplica\imss\mydictionary.ADD"

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch