FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour ADS 5132 Errors / Struggles with Internet and Local Server
Posts: 36
Joined: Thu Oct 26, 2006 05:23 PM

ADS 5132 Errors / Struggles with Internet and Local Server

Posted: Wed Sep 23, 2009 02:52 AM

I am using Advantage Database Server version 8.1

I have the AIS portion of my system running like a charm. However, I want to switch to ALS and create temp tables here and there in my code. I cannot seem to figure out how to use both ALS and AIS in the same application.

Can someone help me out? My specific question is how to COPY STRUCTURE, USE, etc. using ALS when I have an active .ADD
connected via AIS.

TIA

Andy

Posts: 389
Joined: Wed Nov 29, 2006 01:51 PM

Re: ADS 5132 Errors / Struggles with Internet and Local Server

Posted: Wed Sep 23, 2009 10:09 AM

TIA,

See:

AdsCopyTableStructure()

Regards

Posts: 811
Joined: Tue May 06, 2008 04:28 AM

Re: ADS 5132 Errors / Struggles with Internet and Local Server

Posted: Thu Sep 24, 2009 01:46 AM
arpipeline wrote:I am using Advantage Database Server version 8.1

I have the AIS portion of my system running like a charm. However, I want to switch to ALS and create temp tables here and there in my code. I cannot seem to figure out how to use *both* ALS and AIS in the same application.

Can someone help me out? My specific question is how to COPY STRUCTURE, USE, etc. using ALS when I have an active .ADD
connected via AIS.

TIA

Andy



Mr. Andy,

I have a similar application which uses both ADS and ALS at the same time.

Code (fw): Select all Collapse
 ...
 hADS := 0
 hALS := 0

 lServerOK := ADSConnect60(  <.add location>,4,'adssys',,,@hADS)
 ...
 lLocalOK  := ADSConnect60( <.add location>,1, 'adssys',,,@hALS)
 ...


Use this to switch your connection
Code (fw): Select all Collapse
...

AdsConnection( hADS )    //switch to ADS handle
...

AdsConnection( hALS )    //switch to ALS handle
...


All other ADS operation are standard.


Regards,
-Frances
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

Continue the discussion