Alaska Software Inc. - Connecting to an computer via WAA
Username: Password:
AuthorTopic: Connecting to an computer via WAA
Toni KlammerConnecting to an computer via WAA
on Mon, 09 Jan 2006 22:57:43 +0100
Hoi everybody,

I have a simple question, but I don't know the answer because in that case I 
didn't have that question 

Anyway,

I wrote an application (can be anything) that works fine.
It is working in a netwerkenvironment via ADSDBE, so not using WAA.
The files are normal .DBF files, the indexes are in .CDX format, created by 
ADSDBE.

the file ADS.INI contains following (and of course this works fine, the 
question comes later on !!!)
----------------------------
[MAIN-SERVER]
LAN_IP=192.168.0.1
LAN_PORT=2002
----------------------------

I thought I read somewhere in the docs that it's possible to let the 
application reach the server by connection
to the server by using WAA, also connect to the server via an internet 
connection (or should I say an IP connection?)

Thus, normaly I have an application which connects to the server via an 
network connection, now I want to use that same application to connect
to the server using an internet connection (a connection via an IP adress!)

The following code I use to connect to the server via ADSDBE.

*******************************************************************************
* DbeSys() is always executed at program startup
*******************************************************************************
PROCEDURE DbeSys( )
/*
 *   The lHidden parameter is set to .T. for all database engines
 *   which will be combined to a new abstract database engine.
 */
LOCAL aDbes := { { "DBFDBE", .T.} ;
                            , { "NTXDBE", .T.} ;
                            , { "FOXDBE", .T.} ;
                            , { "CDXDBE", .T.} ;
                            , { "ADSDBE", .F.} ;
                            }
LOCAL aBuild := { { "DBFNTX", 1, 2 } ;
                            , { "FOXCDX", 3, 4 } ;
                            }
LOCAL i
  /*
   *   Set the sorting order and the date format
   */
//SET COLLATION TO AMERICAN
SET DATE TO BRITISH
  /*
   *   load all database engines
   */
FOR i:= 1 TO LEN( aDbes )
     IF !DbeLoad( aDbes[ i ][ 1 ], aDbes[ i ][ 2 ] )
          ALERTBOX( aDbes[ i ][ 1 ] + "Failed to load!", {"OK"} )
     ENDIF
NEXT
  /*
   *   create database engines
   */
FOR i:= 1 TO len(aBuild)
     IF !DbeBuild( aBuild[ i ][ 1 ], aDbes[ aBuild[ i ][ 2 ] ] [ 1 ], 
aDbes[ aBuild[ i ] [ 3 ] ][ 1 ] )
             ALERTBOX( aBuild[ i ][ 1 ] + "Failed to load!", {"OK"} )
     ENDIF
NEXT
#IFDEF ADSDBE
      DbeSetDefault( "ADSDBE" )
#ELSE
      DbeSetDefault( "FOXCDX" )
#ENDIF
RETURN

#IFDEF ADSDBE
     ADSDBE is required.
    #INCLUDE "ADSDBE.CH"
    #INCLUDE "ADS.CH"
#ENDIF

 Main

PROCEDURE Main
LOCAL cConnect
#IFDEF ADSDBE
    PUBLIC lADSDBE := .T.
#else
    PUBLIC lADSDBE := .F.
#ENDIF
IF GETENV( "ADSDBE" ) == "OFF"
     lADSDBE := .F.
     DbeSetDefault( "FOXCDX" )
ELSE
     IF lADSDBE
          cConnect := "DBE=ADSDBE;SERVER=" + CURDRIVE( ) + ":\" + CURDIR( )
          oSession := DacSession():New( cConnect )
          IF !oSession:isConnected()
               ALERTBOX( "Error", STR( oSession:GetLastError( ) ) )
               ALERTBOX( "Info", oSession:GetLastMessage( ) )
               ALERTBOX( "Error", aModProject[ xFailConnection, xLAN ] )
               oSession:DisConnect()
               lADSDBE := .F.
               DbeSetDefault( "FOXCDX" )
          ELSE
               DbeInfo( COMPONENT_DATA , ADSDBE_TBL_MODE  , ADSDBE_CDX )
               DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE  , ADSDBE_CDX )
               DbeInfo( COMPONENT_DATA , ADSDBE_LOCK_MODE , 
ADSDBE_PROPRIETARY_LOCKING )
               DbeInfo( COMPONENT_DATA , ADSDBE_RIGHTS_MODE, 
ADSDBE_IGNORERIGHTS )
          ENDIF
     ENDIF
ENDIF
Boris Borzic Re: Connecting to an computer via WAA
on Mon, 09 Jan 2006 23:20:45 +0100
"Toni Klammer" <a.klammer@weerterhof.nl> wrote in
news:wHTRVfWFGHA.5608@S15147418: 

> Thus, normaly I have an application which connects to the server via
> an network connection, now I want to use that same application to
> connect to the server using an internet connection (a connection via
> an IP adress!) 

You have 2 options; 

(1) use the "Advantage Internet Server" with your existing app.

(2) create a true web application using either WAA or Xb2.NET. For info 
on Xb2.NET and why it's supperior to WAA see here: 
http://www.sqlexpress.net/xb2net/DataFlow.htm

Below is some info re. ADS internet server taken from ADS help file:
>>>
Advantage Internet Server functionality is embedded into the Advantage 
Database Server and provides a simple, non-HTML solution to access data 
through the Internet using existing Advantage applications. Advantage 
Internet Server functionality allows remote users to experience the same 
security, integrity, and performance available with LAN-based access to 
the Advantage Database Server, with the added benefit of using the 
Internet as ones own Virtual Private Network (VPN). 

The unique non-HTML architecture of Advantage Internet Server 
functionality eliminates the need for rewriting current database 
applications in order to access data remotely. By simply obtaining access 
to the Internet via any local Internet service provider, remote users 
using the same database application that is used on the LAN can instantly 
access their database via Advantage Internet Server functionality and the 
Advantage Database Server.
Since Advantage Internet Server functionality is embedded into the 
Advantage Database Server, any computer running Windows NT/2000/2003, 
Linux, or NetWare 5 or greater, that has an Internet (TCP/IP) connection 
can host the Internet-enabled Advantage Database Server. The Advantage 
application executable resides on the remote or mobile users client PC 
that has obtained an Internet connection. This allows the remote client 
PCs to communicate with the Internet-enabled Advantage Database Server 
bringing real-time client/server access to existing Advantage 
applications.

Note:  The Advantage Internet Server is a VPN-type solution for use with 
desktop-based applications and is not designed for use with web server 
applications. If you are developing a web server application, a regular 
Advantage Database Server connection type should be used, rather than an 
Advantage Internet Server connection. See Advantage Server Types for 
details. 
<<<

Best regards,
Boris Borzic

news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools
Phil Ide
Re: Connecting to an computer via WAA
on Tue, 10 Jan 2006 11:57:16 +0000
Boris,

> For info 
> on Xb2.NET and why it's supperior to WAA see here: 
> http://www.sqlexpress.net/xb2net/DataFlow.htm

For info on why WAA is superior to Xb2.NET see me.

Naaa, just kidding 

However, Xb2.NET primarily acts as a web-server, whereas WAA sits in a
different architecture:

Xb2.NET topology:

   [Xb2.NET app] <----> [browser-client]

WAA topology:

   [WAA] <----> [web-server] <----> [browser-client]

Of course. Xb2.NET can also be programmed to work in the same topology as
WAA, but that will take a bit of work.

There are distinct advantages to both topologies, and which you choose is
dependant upon your needs.  Where Xb2.NET really scores over WAA is in the
areas that WAA wasn't designed to complement - sockets programming, http
control (including manipulation of http headers etc.), data translation
(i.e. charset -> urlencode etc.).

Xb2.NET is a library with many capabilities, including web-server
programming.  WAA is an application with a specific task, and whilst there
is overlap between these two, direct comparisons are dodgy.  If all you want
to do is serve up dynamic web pages (possibly using Ajax) then WAA is an
excellent choice.  If you want to do more, then Xb2.NET will begin to look
much more attractive.

I don't want to put anyone off buying Xb2.NET - I use it a lot myself and
absolutely swear by it, but I also use WAA for technical, historical and
legislative reasons, and I really hate to see it 'written-off' 

Regards,

Phil Ide

*******************************************
*   Xbase++ FAQ, Libraries and Sources:   *
*   goto: http://www.idep.org.uk/xbase    *
* --------------------------------------- *
* www.xodc.org.uk - openSource Dev-Center *
*******************************************

I will keep a special cache of low-tech weapons and train my troops in their
use. That way -- even if the heroes manage to neutralize my power generator
and/or render the standard-issue energy weapons useless -- my troops will
not be overrun by a handful of savages armed with spears and rocks.
          [Things I'd do as an Evil Overlord]
Toni KlammerRe: Connecting to an computer via WAA
on Tue, 10 Jan 2006 14:15:28 +0100
Hi Phil,

Can you help with my question?

I only want to connect to another computer for using the data on that 
computer.
The application is a 'normal' application that has nothing to do with 
ineternet or HTML, it just uses DBF-files.
The application uses ADSDBE so Advantage Database Server is installed on the 
server.
Normaly I use ADS.INI containing:
----------------------------
[MAIN-SERVER]
LAN_IP=192.168.0.1
LAN_PORT=2002
----------------------------

Can I, while using the WAA capabilities, connect to the server over the 
internet,
and if so, what action(s) do I have to take. What has to be in the ADS.INI 
and what part
of WAA has to be installed on the server side (and what on the client side)?
And how can I simply install those things???

Regards,


Toni Klammer

"Phil Ide" <phil@xodc.org.uk> schreef in bericht 
news:19t3qiy1suzld$.dlg@xodc.org.uk...
> Boris,
>
>> For info
>> on Xb2.NET and why it's supperior to WAA see here:
>> http://www.sqlexpress.net/xb2net/DataFlow.htm
>
> For info on why WAA is superior to Xb2.NET see me.
>
> Naaa, just kidding 
>
> However, Xb2.NET primarily acts as a web-server, whereas WAA sits in a
> different architecture:
>
> Xb2.NET topology:
>
>   [Xb2.NET app] <----> [browser-client]
>
> WAA topology:
>
>   [WAA] <----> [web-server] <----> [browser-client]
>
> Of course. Xb2.NET can also be programmed to work in the same topology as
> WAA, but that will take a bit of work.
>
> There are distinct advantages to both topologies, and which you choose is
> dependant upon your needs.  Where Xb2.NET really scores over WAA is in the
> areas that WAA wasn't designed to complement - sockets programming, http
> control (including manipulation of http headers etc.), data translation
> (i.e. charset -> urlencode etc.).
>
> Xb2.NET is a library with many capabilities, including web-server
> programming.  WAA is an application with a specific task, and whilst there
> is overlap between these two, direct comparisons are dodgy.  If all you 
> want
> to do is serve up dynamic web pages (possibly using Ajax) then WAA is an
> excellent choice.  If you want to do more, then Xb2.NET will begin to look
> much more attractive.
>
> I don't want to put anyone off buying Xb2.NET - I use it a lot myself and
> absolutely swear by it, but I also use WAA for technical, historical and
> legislative reasons, and I really hate to see it 'written-off' 
>
> Regards,
> -- 
> Phil Ide
>
> *******************************************
> *   Xbase++ FAQ, Libraries and Sources:   *
> *   goto: http://www.idep.org.uk/xbase    *
> * --------------------------------------- *
> * www.xodc.org.uk - openSource Dev-Center *
> *******************************************
>
> I will keep a special cache of low-tech weapons and train my troops in 
> their
> use. That way -- even if the heroes manage to neutralize my power 
> generator
> and/or render the standard-issue energy weapons useless -- my troops will
> not be overrun by a handful of savages armed with spears and rocks.
>          [Things I'd do as an Evil Overlord]
Phil Ide
Re: Connecting to an computer via WAA
on Tue, 10 Jan 2006 15:44:08 +0000
Toni,

> Can I, while using the WAA capabilities, connect to the server over the 
> internet,
> and if so, what action(s) do I have to take. What has to be in the ADS.INI 
> and what part
> of WAA has to be installed on the server side (and what on the client side)?
> And how can I simply install those things???

Well, much of your question is really an ADS question - but to install ADS
connection in WAA:

1. Use SQLExpress

or

2. Via ADSDBE, do a dbeLoad('ADSDBE') in your _register() function.

For the ini configuration, you'll need to ask someone who knows a bit more
about ADS.  However, this should configure Xbase++ for you.

Regards,

Phil Ide

*******************************************
*   Xbase++ FAQ, Libraries and Sources:   *
*   goto: http://www.idep.org.uk/xbase    *
* --------------------------------------- *
* www.xodc.org.uk - openSource Dev-Center *
*******************************************

I will not have a daughter. She would be as beautiful as she was evil, but
one look at the hero's rugged countenance and she'd betray her own father.
          [Things I'd do as an Evil Overlord]
Toni KlammerRe: Connecting to an computer via WAA
on Tue, 10 Jan 2006 18:50:31 +0100
Stupid me,

I ought to ask this question on the Advantage Newsgroup, but don't blame 
me!!!
Because on the newsgroups of Alaska are a lot of Smart guys, so I got 
confused 


regards,


Toni Klammer

"Phil Ide" <phil@xodc.org.uk> schreef in bericht 
news:167gzs7gfgkfc.dlg@xodc.org.uk...
> Toni,
>
>> Can I, while using the WAA capabilities, connect to the server over the
>> internet,
>> and if so, what action(s) do I have to take. What has to be in the 
>> ADS.INI
>> and what part
>> of WAA has to be installed on the server side (and what on the client 
>> side)?
>> And how can I simply install those things???
>
> Well, much of your question is really an ADS question - but to install ADS
> connection in WAA:
>
> 1. Use SQLExpress
>
> or
>
> 2. Via ADSDBE, do a dbeLoad('ADSDBE') in your _register() function.
>
> For the ini configuration, you'll need to ask someone who knows a bit more
> about ADS.  However, this should configure Xbase++ for you.
>
> Regards,
> -- 
> Phil Ide
>
> *******************************************
> *   Xbase++ FAQ, Libraries and Sources:   *
> *   goto: http://www.idep.org.uk/xbase    *
> * --------------------------------------- *
> * www.xodc.org.uk - openSource Dev-Center *
> *******************************************
>
> I will not have a daughter. She would be as beautiful as she was evil, but
> one look at the hero's rugged countenance and she'd betray her own father.
>          [Things I'd do as an Evil Overlord]
Phil Ide
Re: Connecting to an computer via WAA
on Wed, 11 Jan 2006 09:58:09 +0000
Toni,

> Stupid me,
> 
> I ought to ask this question on the Advantage Newsgroup, but don't blame 
> me!!!
> Because on the newsgroups of Alaska are a lot of Smart guys, so I got 
> confused 

Confusion is when you see the universe in it's natural state, and your mind
rebels at the thought 

The natural mode of the universe is chaos - order is an anomoly, or rather
just a specific mode of chaos, like a circle is a specific kind of oval.

Regards,

Phil Ide

*******************************************
*   Xbase++ FAQ, Libraries and Sources:   *
*   goto: http://www.idep.org.uk/xbase    *
* --------------------------------------- *
* www.xodc.org.uk - openSource Dev-Center *
*******************************************

My security keypad will actually be a fingerprint scanner. Anyone who
watches someone press a sequence of buttons or dusts the pad for
fingerprints then subsequently tries to enter by repeating that sequence
will trigger the alarm system.
          [Things I'd do as an Evil Overlord]
Thomas Braun Re: Connecting to an computer via WAA
on Wed, 11 Jan 2006 15:22:15 +0100
Phil Ide wrote:
 
> The natural mode of the universe is chaos - order is an anomoly, or rather
> just a specific mode of chaos, like a circle is a specific kind of oval.

Didn't you mean "a specific kind of a square"? ))

Thomas
Phil Ide
Re: Connecting to an computer via WAA
on Wed, 11 Jan 2006 15:54:26 +0000
Thomas,

>> The natural mode of the universe is chaos - order is an anomoly, or rather
>> just a specific mode of chaos, like a circle is a specific kind of oval.
> 
> Didn't you mean "a specific kind of a square"? ))

No - a square is a specific kind of a rhomboid, and a rhomboid is an
anomolous ovoid.  Get it?

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

I won't require high-ranking female members of my organization to wear a
stainless-steel bustier. Morale is better with a more casual dress-code.
Similarly, outfits made entirely from black leather will be reserved for
formal occasions.
          [Things I'd do as an Evil Overlord]
Robert MajorRe: Connecting to an computer via WAA
on Wed, 11 Jan 2006 12:53:31 -0500
Hi Phil, Thomas,

Euclid would probably say they are all anomalous straight
lines.

Einstein would probably say they depend on your perspective.

Heisenberg would probably say there is a statistical
probability that, at any one moment, a circle is a square.

Robert
Thomas Braun Re: Connecting to an computer via WAA
on Thu, 12 Jan 2006 09:55:16 +0100
Robert Major wrote:

> Heisenberg would probably say there is a statistical
> probability that, at any one moment, a circle is a square.

A circle is a square at the same time - but only if you don't watch it


Thomas
Toni KlammerRe: Connecting to an computer via WAA
on Wed, 11 Jan 2006 22:27:22 +0100
Back to the topic, please....  

You know: it was not stupid to post my question here.
The newsgroup of Extended Systems (The Advantage Thing) is probably asleep 
or it died.
Nobody answers, nobody writes (even no other topic or so).
Maybe it's only allowed to post there on Sundays I think,
or only when the total of day and month equals a prime number.

That means that I come back to you guys (are there any girls here????) to 
try to find the answer to my question!
I know that most people here are SMART GUYS, but sometimes I just like them 
to prove it !!!!


kind regards,


Toni Klammer

"Phil Ide" <phil@xodc.org.uk> schreef in bericht 
news:167gzs7gfgkfc.dlg@xodc.org.uk...
> Toni,
>
>> Can I, while using the WAA capabilities, connect to the server over the
>> internet,
>> and if so, what action(s) do I have to take. What has to be in the 
>> ADS.INI
>> and what part
>> of WAA has to be installed on the server side (and what on the client 
>> side)?
>> And how can I simply install those things???
>
> Well, much of your question is really an ADS question - but to install ADS
> connection in WAA:
>
> 1. Use SQLExpress
>
> or
>
> 2. Via ADSDBE, do a dbeLoad('ADSDBE') in your _register() function.
>
> For the ini configuration, you'll need to ask someone who knows a bit more
> about ADS.  However, this should configure Xbase++ for you.
>
> Regards,
> -- 
> Phil Ide
>
> *******************************************
> *   Xbase++ FAQ, Libraries and Sources:   *
> *   goto: http://www.idep.org.uk/xbase    *
> * --------------------------------------- *
> * www.xodc.org.uk - openSource Dev-Center *
> *******************************************
>
> I will not have a daughter. She would be as beautiful as she was evil, but
> one look at the hero's rugged countenance and she'd betray her own father.
>          [Things I'd do as an Evil Overlord]
Phil Ide
Re: Connecting to an computer via WAA
on Thu, 12 Jan 2006 10:25:48 +0000
Toni,

> Back to the topic, please....  
> 
> You know: it was not stupid to post my question here.

Please don't take offence - we were just having a mad moment, which happens
sometimes.

FWIW the reason some questions don't get answered is not out of apathy but
because (usually) no one has an authoritative answer.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

My Legions of Terror will be trained in basic marksmanship. Any who cannot
learn to hit a man-sized target at 10 meters will be used for target
practice.
          [Things I'd do as an Evil Overlord]