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.

Somebody Can help me, please ?

2 posts in FoxPro Last posting was on 2010-05-19 14:53:03.0Z
Hugo Glez. Macias Posted on 2010-05-19 05:01:08.0Z
From: "Hugo Glez. Macias" <gomh7172@hotmail.com>
Newsgroups: Advantage.FoxPro
Subject: Somebody Can help me, please ?
Date: Wed, 19 May 2010 00:01:08 -0500
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
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.16.30
Message-ID: <4bf37008@solutions.advantagedatabase.com>
X-Trace: 18 May 2010 22:58:48 -0700, 187.146.16.30
Path: solutions.advantagedatabase.com!187.146.16.30
Xref: solutions.advantagedatabase.com Advantage.FoxPro:356
Article PK: 1109710

I can't to connect a remote database, I have some days trying to connect but
I can't !!

My environment is this:
1.- I have installed Advantage Database Server 9.1 in the server
"pasteur.dnsalias.org", port=2000
2.- In the Advantage Configuration Utility I have configuration in the tab
communicatios Internet Port=2000, in the router also.
3.- I create a Data Dictionary, the name is "ADTS_PASTEUR.ADD" and I have
just 1 table, the name is "paciente.adt"
4.- In the client I have installed Advantage OLE DB Provider 9.1
5.- I trying to connect from VFP and this is my connectionString:

DirCliente = "\usr\hmacias\Advantage\ADTS_pasteur.add"
connectionString = "Provider=Advantage OLE DB Provider;"+;
"Data Source="+dirCliente+";"+;
"ServerType=ADS_REMOTE_SERVER;"+;
"DbfsUseNulls=TRUE;"+;
"LOckMode=ADS_PROPRIETARY_LOCKING;"+;
"SecurityMode=ADS_IGNORERIGHTS;"+;
"CharType=ADS_OEM;"

5.- In the client, In the same path where I have the application I have the
ADS.INI file, I have the same file in the directory "windows\system32" and
"windows", this is the information the ADS.INI
[Cibernetica201]
internet_ip=pasteur.dnsalias.org
internet_port=2000

6.- This is my code VFP
DirCliente = "\usr\hmacias\Advantage\ADTS_pasteur.add"
connectionString = "Provider=Advantage OLE DB Provider;"+;
"Data Source="+dirCliente+";"+;
"ServerType=ADS_REMOTE_SERVER;"+;
"DbfsUseNulls=TRUE;"+;
"LOckMode=ADS_PROPRIETARY_LOCKING;"+;
"SecurityMode=ADS_IGNORERIGHTS;"+;
"CharType=ADS_OEM;"
lcCnx=CREATEOBJECT("ADODB.Connection")
lcCnx.connectionString = connectionString
lcCnx.CommandTimeOut = 90 && lcCnx.CommandTimeOut=gnTimeOut / en
segundos - ECF:28/JUL/09
lcCnx.OPEN() && Línea del error invalid socket handle

I have the next error:
Error 6420: The "discovery" process for the Advantage Database Server
failed. Unable to connect

Please help me, thank you very much !!

Hugo
Cibernetica de Mexico
Guadala, Jalisco


Mark Wilkins Posted on 2010-05-19 14:53:03.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.FoxPro
References: <4bf37008@solutions.advantagedatabase.com>
Subject: Re: Somebody Can help me, please ?
Date: Wed, 19 May 2010 08:53:03 -0600
Lines: 106
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <4bf3fab4@solutions.advantagedatabase.com>
X-Trace: 19 May 2010 08:50:28 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.FoxPro:357
Article PK: 1109706

Hello Hugo.

Your connection path appears to be incorrect. It needs to have two (2)
backslash characters at the beginning of the path:
DirCliente = "\\usr\hmacias\Advantage\ADTS_pasteur.add"

This assumes that "usr" is the server name that you are trying to connect to
and that "hmacias" is a shared directory on that server. It is possible
that the multicast discovery packets cannot reach the server. Multicast is
one of the mechanisms by which the client can contact the server when trying
to connect so that the server will respond with the port number. If this
does not work, then you have a couple of options. First, you could include
the port number in the connection path like this:

DirCliente = "\\usr:2000\hmacias\Advantage\ADTS_pasteur.add"

Or you could include it in your ads.ini file like this:
[USR]
lan_ip=a.b.c.d (put your server's IP address here)
lan_port=2000

The settings "lan_ip" and "lan_port" are used when you are using
ADS_REMOTE_SERVER as the connection type.

I see that you your example shown in ads.ini maybe indicates that the server
you are trying to connect to might be pasteur.dnsalias.org. If so, then
your connection path should maybe be as follows. I am guessing at the
paths:

DirCliente =
"\\pasteur.dnsalias.org:2000\usr\hmacias\Advantage\ADTS_pasteur.add"

If you include the following information in your ads.ini, then you would not
need to include the port (:2000) in the path.

[pasteur.dnsalias.org]
lan_ip=a.b.c.d
lan_port=2000

This link may also contain useful information:
http://devzone.advantagedatabase.com/dz/content.aspx?Key=17&RefNo=020806-1486


Mark Wilkins
Advantage R&D

"Hugo Glez. Macias" <gomh7172@hotmail.com> wrote in message
news:4bf37008@solutions.advantagedatabase.com...
>I can't to connect a remote database, I have some days trying to connect
>but I can't !!
>
> My environment is this:
> 1.- I have installed Advantage Database Server 9.1 in the server
> "pasteur.dnsalias.org", port=2000
> 2.- In the Advantage Configuration Utility I have configuration in the tab
> communicatios Internet Port=2000, in the router also.
> 3.- I create a Data Dictionary, the name is "ADTS_PASTEUR.ADD" and I have
> just 1 table, the name is "paciente.adt"
> 4.- In the client I have installed Advantage OLE DB Provider 9.1
> 5.- I trying to connect from VFP and this is my connectionString:
>
> DirCliente = "\usr\hmacias\Advantage\ADTS_pasteur.add"
> connectionString = "Provider=Advantage OLE DB Provider;"+;
> "Data Source="+dirCliente+";"+;
> "ServerType=ADS_REMOTE_SERVER;"+;
> "DbfsUseNulls=TRUE;"+;
> "LOckMode=ADS_PROPRIETARY_LOCKING;"+;
> "SecurityMode=ADS_IGNORERIGHTS;"+;
> "CharType=ADS_OEM;"
>
> 5.- In the client, In the same path where I have the application I have
> the ADS.INI file, I have the same file in the directory "windows\system32"
> and "windows", this is the information the ADS.INI
> [Cibernetica201]
> internet_ip=pasteur.dnsalias.org
> internet_port=2000
>
> 6.- This is my code VFP
> DirCliente = "\usr\hmacias\Advantage\ADTS_pasteur.add"
> connectionString = "Provider=Advantage OLE DB Provider;"+;
> "Data Source="+dirCliente+";"+;
> "ServerType=ADS_REMOTE_SERVER;"+;
> "DbfsUseNulls=TRUE;"+;
> "LOckMode=ADS_PROPRIETARY_LOCKING;"+;
> "SecurityMode=ADS_IGNORERIGHTS;"+;
> "CharType=ADS_OEM;"
> lcCnx=CREATEOBJECT("ADODB.Connection")
> lcCnx.connectionString = connectionString
> lcCnx.CommandTimeOut = 90 && lcCnx.CommandTimeOut=gnTimeOut / en
> segundos - ECF:28/JUL/09
> lcCnx.OPEN() && Línea del error invalid socket handle
>
> I have the next error:
> Error 6420: The "discovery" process for the Advantage Database Server
> failed. Unable to connect
>
> Please help me, thank you very much !!
>
> Hugo
> Cibernetica de Mexico
> Guadala, Jalisco
>
>