FiveTech Support Forums

Hello,

Please, who are the exports of ADS and Harbour?.

Thank you.

Frank,

Thank you.

But using AIS via Internet it gives:

DbUseArea( .T., "ADSCDX", "C:\LUCAS\CONTA.DBF", "LUCAS" )

Error ADSCDX/5132 The specified database object name is not valid.: C:\LUCAS\CONTA.DBF

The location of the Internet-enabled Advantage Database Server must be specified. In addition, you must also configure your application to use the Advantage Internet Server server type. See Connecting Clients through the Internet to Advantage for details. Below are the three ways to specify the location of the Internet-enabled Advantage Database Server:

1. Use the server's IP address and Internet port number in the connection path string. The path can be specified as \\<ip address>:<ip port>\share\Dir\DataDictionary.add, where the <ip address> is the IP address where the Advantage Database Server is located, and the <ip port> is the Internet Port that the Advantage Database Server is listening.

Example of using the server’s IP address and Internet port number with the Advantage Client Engine API:

ulRetVal = AdsConnect60("\\\\193.69.232.1:6262\\share1\\test.add",
ADS_AIS_SERVER,
"User1",
"foobar",
ADS_DEFAULT,
&hConnect );

Similar functionality for specifying the IP address and port in the connection string/path is available in other Advantage clients. The details related to making a connection through the Internet to the Advantage Database Server from other clients can be found in the respective Advantage client Help documentation.

2. Specify the server name in the connection string. The path can be specified as \\<server name>\share\Dir\DataDictionary.add, where the <server name> is the name of a server specified in the ADS.INI file. The ADS.INI file specifies the actual IP address where the Advantage Database Server is located, and IP port that the Advantage Database Server is listening, that correspond to the specified server name. See Setting Up Your Clients Using ADS.INI for more specifics on information in the ADS.INI file.

Example of using a server name with the Advantage Client Engine API:

ulRetVal = AdsConnect60( "\\\\server1\\share1\\test.add",
ADS_AIS_SERVER,
"User1",
"foobar",
ADS_DEFAULT,
&hConnect );

3. Specify a drive letter in the connection string. The drive letter can be specified as <x:>\Dir\DataDictionary.add, where the <x:> is the name of a drive letter specified in the ADS.INI file. The ADS.INI file directly or indirectly specifies the actual IP address where the Advantage Database Server is located, as well as the IP port that the Advantage Database Server is listening, that correspond to the specified drive letter. See Setting Up Your Clients Using ADS.INI for more specifics on information in the ADS.INI file.

Example of using a drive letter with the Advantage Client Engine API:

ulRetVal = AdsConnect60( "x:\\test.add",
ADS_AIS_SERVER,
"User1",
"foobar",
ADS_DEFAULT,
&hConnect );

The Advantage Internet Server configuration can be specified in the ADS.INI file by adding a couple of sections.
The [Drives] section lists the complete UNC path to which a drive letter is mapped. If your client application uses drive letters, you will need to define the drive letter mappings.
Example:

[ Drives ]
R:=\\SERVER1\SHARE

For each Advantage Database Server you want to connect to, you will need to have a separate server-name entry.
Example:

[ <server name> ]
INTERNET_PORT=<the Internet port for the server>
INTERNET_IP=<the IP address for the Advantage Database Server>

Example:

[Drives]
Q:=\\serverA\testsys\
r:=\\serverB\data\
[serverA]
INTERNET_PORT=2001
INTERNET_IP=198.169.1.69
[serverB]
INTERNET_PORT=2002
INTERNET_IP=198.70.169.72

Lucas,

yes, you can't use AIS with free tables.

How you want to configure the 'The security level' without a database (Advantage Data Dictionary), so CATCH 21

So, if you still want to use free tables via Internet, set up a VPN infrastructure and use ADS!

lucas me interesa contactar contigo,

mi email es donboscocorp2@hotmail.com

salu2
carlos vargas

Frank,

Thank you. Your idea works .

I am having trouble with indexes and Data Dictorionary. I create the indexes as INDEX ON FIELD TO INDEXNAME but AIS ignores that.

I think working with a Data Dictionary you need to reindex using AdsReindex(), not INDEX ON command... I´m not sure,

Carlos, I sent you an email.

Thank you very much.

EXECUTE PROCEDURE sp_CreateIndex90(
'caja',
'caja.adi',
'NUM_CIUD',
'num_ciud',
'',
2,
512,
'' );

Thank you, but I need to create the indexes on .prg side, not ARC.

I also need several indexes.

This code works perfect in ADS remote, local or DBCDX but not in AIS:

     // Todas las series
     INDEX ON FSERIE + StrZero (FNUMERO,20 ) TO (cMyPath+"FACTUR1") FOR !Deleted()
     // Serie A, B 
     INDEX ON FSERIE + StrZero (FNUMERO,20 ) TO (cMyPath+"FACTURA") FOR (FSERIE="A") .AND. !Deleted()
     INDEX ON FSERIE + StrZero (FNUMERO,20 ) TO (cMyPath+"FACTURB") FOR (FSERIE="B") .AND. !Deleted()
     // Cobrada
     INDEX ON FSERIE + StrZero (FNUMERO,20 ) TO (cMyPath+"FACTURC") FOR FCOBRADA="S"   .AND. !Deleted()
     INDEX ON FSERIE + StrZero (FNUMERO,20 ) TO (cMyPath+"FACTURN") FOR FCOBRADA!="S"  .AND. !Deleted()
     DbCloseAll()

Any clude, Thank you very much,