Hi,

We are using xBase++ and Advantage Database Server for Application
development. Is there any to connect to ADS other than \\IP:Port
combination

My requirement is as follows.

One of the customer restructured their hardware and network
infrastructure. They sepeared Application Server (App Server) and
Database Server (DB Server). Now we have put the executables in App
Server. Ant put the ADS and Data in DB Server. Now the  application
connect to ADS through the 6262 port of DB Server.

Now they says that Client application should not connec to DB Server
directely. Client should connect to App Server only. And only App
server should connect to Database. Basically they want us to create a
middle layer which serves the requests from the client. This is not an
easy task for us.

Is there any tools or middle wares to do this task ?

Regards
Kiron

Hi, yo can trie with this example.....

      oConn := DacSession():New( "DBE=ADSDBE;"                       +;
                                 "SERVER=\\MYSERVER\DATA\MYAPLICATION;" +;
                                 "UID=nameuser;"                   +;
                                 "PWD=userpassword;"                     +;
                                 "Compression=Allways;"              +;7
                                 "DefaultType=Clipper;"              +;
                                 "Rows=False;"                       +;
                                 "Language=OEM:ads_ascii;"           +;
                                 "AdvantageLocking=OFF;"             +;
                                 "Locking=Record;"                   +;
                                 "MemoBlockSize=512;"                +;
                                 "MaxTableCloseCache=5;"             +;
                                 "ServerTypes=7;"                    +;
                                 "TrimTrailingSpaces=False"           )7
in ads_cfg.ini
[Settings]
ServiceName=Advantage
ADS_SERVER_TYPE = 7
RETRY_ADS_CONNECTS = 1
MAX_CONNECTIONS = 100
MAX_TIMEOUTS = 40
COMPRESSION = Always

[DRIVERS]

[MyServer]
LAN_IP=10.0.0.101     <- your server IP



"Jacob John" escribió en el mensaje de 
noticias:66taqehtlv4ds1umtn7bouv8ksgrjmb2rh@4ax.com...

Hi,

We are using xBase++ and Advantage Database Server for Application
development. Is there any to connect to ADS other than \\IP:Port
combination

My requirement is as follows.

One of the customer restructured their hardware and network
infrastructure. They sepeared Application Server (App Server) and
Database Server (DB Server). Now we have put the executables in App
Server. Ant put the ADS and Data in DB Server. Now the  application
connect to ADS through the 6262 port of DB Server.

Now they says that Client application should not connec to DB Server
directely. Client should connect to App Server only. And only App
server should connect to Database. Basically they want us to create a
middle layer which serves the requests from the client. This is not an
easy task for us.

Is there any tools or middle wares to do this task ?

Regards
Kiron

Sorry for having misunderstood the situation, in other words..., instead of 
sending the queries to the database directly, you would send it to another 
place..., where an application on the server resolves them and this app 
returns them ?



"Jorge L. Borlando"  escribió en el mensaje de 
noticias:49a25e1c$8d31850$54434@news.alaska-software.com...

Hi, yo can trie with this example.....

      oConn := DacSession():New( "DBE=ADSDBE;"                       +;
                                 "SERVER=\\MYSERVER\DATA\MYAPLICATION;" +;
                                 "UID=nameuser;"                   +;
                                 "PWD=userpassword;"                     +;
                                 "Compression=Allways;"              +;7
                                 "DefaultType=Clipper;"              +;
                                 "Rows=False;"                       +;
                                 "Language=OEM:ads_ascii;"           +;
                                 "AdvantageLocking=OFF;"             +;
                                 "Locking=Record;"                   +;
                                 "MemoBlockSize=512;"                +;
                                 "MaxTableCloseCache=5;"             +;
                                 "ServerTypes=7;"                    +;
                                 "TrimTrailingSpaces=False"           )7
in ads_cfg.ini
[Settings]
ServiceName=Advantage
ADS_SERVER_TYPE = 7
RETRY_ADS_CONNECTS = 1
MAX_CONNECTIONS = 100
MAX_TIMEOUTS = 40
COMPRESSION = Always

[DRIVERS]

[MyServer]
LAN_IP=10.0.0.101     <- your server IP



"Jacob John" escribió en el mensaje de
noticias:66taqehtlv4ds1umtn7bouv8ksgrjmb2rh@4ax.com...

Hi,

We are using xBase++ and Advantage Database Server for Application
development. Is there any to connect to ADS other than \\IP:Port
combination

My requirement is as follows.

One of the customer restructured their hardware and network
infrastructure. They sepeared Application Server (App Server) and
Database Server (DB Server). Now we have put the executables in App
Server. Ant put the ADS and Data in DB Server. Now the  application
connect to ADS through the 6262 port of DB Server.

Now they says that Client application should not connec to DB Server
directely. Client should connect to App Server only. And only App
server should connect to Database. Basically they want us to create a
middle layer which serves the requests from the client. This is not an
easy task for us.

Is there any tools or middle wares to do this task ?

Regards
Kiron

Imho without more insight the company demands three tier app? So xbase client that does display and io, printing ..., a middle application server with routines that do comm with REST or SOAP protocol and communicate with database server?

It can be done, but it will be a lot of tweaking the code (no more open dbf but request for data to app server and displaying it locally), but you can client and routines for app server (as long as application server is Windows based) with xbase and its tools.

Personally in that case would go with xb2net and select one of protocols to build upon. It is mature product that works quite well.

But it also depends on budget and time constraints in comparision with application size. But on upper side you can charge way more for such solution too.

Did you discuss RDS/RDP solution where app runs on server and users go there thru RDP client?

"Jorge L. Borlando" <jlborlando@yahoo.com.ar> wrote in message news:b576000$5b7868d4$5447d@news.alaska-software.com...
>Sorry for having misunderstood the situation, in other words..., instead of 
>sending the queries to the database directly, you would send it to another 
>place..., where an application on the server resolves them and this app 
>returns them ?
>
>
>
>"Jorge L. Borlando"  escribió en el mensaje de 
>noticias:49a25e1c$8d31850$54434@news.alaska-software.com...
>
>Hi, yo can trie with this example.....
>
>      oConn := DacSession():New( "DBE=ADSDBE;"                       +;
>                                 "SERVER=\\MYSERVER\DATA\MYAPLICATION;" +;
>                                 "UID=nameuser;"                   +;
>                                 "PWD=userpassword;"                     +;
>                                 "Compression=Allways;"              +;7
>                                 "DefaultType=Clipper;"              +;
>                                 "Rows=False;"                       +;
>                                 "Language=OEM:ads_ascii;"           +;
>                                 "AdvantageLocking=OFF;"             +;
>                                 "Locking=Record;"                   +;
>                                 "MemoBlockSize=512;"                +;
>                                 "MaxTableCloseCache=5;"             +;
>                                 "ServerTypes=7;"                    +;
>                                 "TrimTrailingSpaces=False"           )7
>in ads_cfg.ini
>[Settings]
>ServiceName=Advantage
>ADS_SERVER_TYPE = 7
>RETRY_ADS_CONNECTS = 1
>MAX_CONNECTIONS = 100
>MAX_TIMEOUTS = 40
>COMPRESSION = Always
>
>[DRIVERS]
>
>[MyServer]
>LAN_IP=10.0.0.101     <- your server IP
>
>
>
>"Jacob John" escribió en el mensaje de
>noticias:66taqehtlv4ds1umtn7bouv8ksgrjmb2rh@4ax.com...
>
>Hi,
>
>We are using xBase++ and Advantage Database Server for Application
>development. Is there any to connect to ADS other than \\IP:Port
>combination
>
>My requirement is as follows.
>
>One of the customer restructured their hardware and network
>infrastructure. They sepeared Application Server (App Server) and
>Database Server (DB Server). Now we have put the executables in App
>Server. Ant put the ADS and Data in DB Server. Now the  application
>connect to ADS through the 6262 port of DB Server.
>
>Now they says that Client application should not connec to DB Server
>directely. Client should connect to App Server only. And only App
>server should connect to Database. Basically they want us to create a
>middle layer which serves the requests from the client. This is not an
>easy task for us.
>
>Is there any tools or middle wares to do this task ?
>
>Regards
>Kiron

Hi,

>Imho without more insight the company demands three tier app? So xbase client that does display and io, printing ..., a middle application server with routines that do comm with REST or SOAP protocol and communicate with database server?

Actually management changed and new IT team came in place. So its a
matter of existence.
>
>It can be done, but it will be a lot of tweaking the code (no more open dbf but request for data to app server and displaying it locally), but you can client and routines for app server (as long as application server is Windows based) with xbase and its tools.

I know. We already have some middleware which is using xb2net. It
works well also. But it is not easy to convert all the modules in a
small time frame. We have 16 operational modules. Its huge
application.
>
>Personally in that case would go with xb2net and select one of protocols to build upon. It is mature product that works quite well.
>
>But it also depends on budget and time constraints in comparision with application size. But on upper side you can charge way more for such solution too.
>
>Did you discuss RDS/RDP solution where app runs on server and users go there thru RDP client?

Yes. But they are not ready to buy that much RDP licences. Also they
are not recommeding RDP.

So we are looking for a generalised middleware.

Regards
Kiron
>
>"Jorge L. Borlando" <jlborlando@yahoo.com.ar> wrote in message news:b576000$5b7868d4$5447d@news.alaska-software.com...
>>Sorry for having misunderstood the situation, in other words..., instead of 
>>sending the queries to the database directly, you would send it to another 
>>place..., where an application on the server resolves them and this app 
>>returns them ?
>>
>>
>>
>>"Jorge L. Borlando"  escribió en el mensaje de 
>>noticias:49a25e1c$8d31850$54434@news.alaska-software.com...
>>
>>Hi, yo can trie with this example.....
>>
>>      oConn := DacSession():New( "DBE=ADSDBE;"                       +;
>>                                 "SERVER=\\MYSERVER\DATA\MYAPLICATION;" +;
>>                                 "UID=nameuser;"                   +;
>>                                 "PWD=userpassword;"                     +;
>>                                 "Compression=Allways;"              +;7
>>                                 "DefaultType=Clipper;"              +;
>>                                 "Rows=False;"                       +;
>>                                 "Language=OEM:ads_ascii;"           +;
>>                                 "AdvantageLocking=OFF;"             +;
>>                                 "Locking=Record;"                   +;
>>                                 "MemoBlockSize=512;"                +;
>>                                 "MaxTableCloseCache=5;"             +;
>>                                 "ServerTypes=7;"                    +;
>>                                 "TrimTrailingSpaces=False"           )7
>>in ads_cfg.ini
>>[Settings]
>>ServiceName=Advantage
>>ADS_SERVER_TYPE = 7
>>RETRY_ADS_CONNECTS = 1
>>MAX_CONNECTIONS = 100
>>MAX_TIMEOUTS = 40
>>COMPRESSION = Always
>>
>>[DRIVERS]
>>
>>[MyServer]
>>LAN_IP=10.0.0.101     <- your server IP
>>
>>
>>
>>"Jacob John" escribió en el mensaje de
>>noticias:66taqehtlv4ds1umtn7bouv8ksgrjmb2rh@4ax.com...
>>
>>Hi,
>>
>>We are using xBase++ and Advantage Database Server for Application
>>development. Is there any to connect to ADS other than \\IP:Port
>>combination
>>
>>My requirement is as follows.
>>
>>One of the customer restructured their hardware and network
>>infrastructure. They sepeared Application Server (App Server) and
>>Database Server (DB Server). Now we have put the executables in App
>>Server. Ant put the ADS and Data in DB Server. Now the  application
>>connect to ADS through the 6262 port of DB Server.
>>
>>Now they says that Client application should not connec to DB Server
>>directely. Client should connect to App Server only. And only App
>>server should connect to Database. Basically they want us to create a
>>middle layer which serves the requests from the client. This is not an
>>easy task for us.
>>
>>Is there any tools or middle wares to do this task ?
>>
>>Regards
>>Kiron

Hi,

Yes. I am looking for a generalised Middleware which is installed in
the App Server and can handle all the Database request between the
application and ADS.

Is there anything like that ?

Regards
Kiron



On Tue, 15 Oct 2019 10:13:15 -0300, "Jorge L. Borlando"
<jlborlando@yahoo.com.ar> wrote:

>Sorry for having misunderstood the situation, in other words..., instead of 
>sending the queries to the database directly, you would send it to another 
>place..., where an application on the server resolves them and this app 
>returns them ?
>
>
>
>"Jorge L. Borlando"  escribió en el mensaje de 
>noticias:49a25e1c$8d31850$54434@news.alaska-software.com...
>
>Hi, yo can trie with this example.....
>
>      oConn := DacSession():New( "DBE=ADSDBE;"                       +;
>                                 "SERVER=\\MYSERVER\DATA\MYAPLICATION;" +;
>                                 "UID=nameuser;"                   +;
>                                 "PWD=userpassword;"                     +;
>                                 "Compression=Allways;"              +;7
>                                 "DefaultType=Clipper;"              +;
>                                 "Rows=False;"                       +;
>                                 "Language=OEM:ads_ascii;"           +;
>                                 "AdvantageLocking=OFF;"             +;
>                                 "Locking=Record;"                   +;
>                                 "MemoBlockSize=512;"                +;
>                                 "MaxTableCloseCache=5;"             +;
>                                 "ServerTypes=7;"                    +;
>                                 "TrimTrailingSpaces=False"           )7
>in ads_cfg.ini
>[Settings]
>ServiceName=Advantage
>ADS_SERVER_TYPE = 7
>RETRY_ADS_CONNECTS = 1
>MAX_CONNECTIONS = 100
>MAX_TIMEOUTS = 40
>COMPRESSION = Always
>
>[DRIVERS]
>
>[MyServer]
>LAN_IP=10.0.0.101     <- your server IP
>
>
>
>"Jacob John" escribió en el mensaje de
>noticias:66taqehtlv4ds1umtn7bouv8ksgrjmb2rh@4ax.com...
>
>Hi,
>
>We are using xBase++ and Advantage Database Server for Application
>development. Is there any to connect to ADS other than \\IP:Port
>combination
>
>My requirement is as follows.
>
>One of the customer restructured their hardware and network
>infrastructure. They sepeared Application Server (App Server) and
>Database Server (DB Server). Now we have put the executables in App
>Server. Ant put the ADS and Data in DB Server. Now the  application
>connect to ADS through the 6262 port of DB Server.
>
>Now they says that Client application should not connec to DB Server
>directely. Client should connect to App Server only. And only App
>server should connect to Database. Basically they want us to create a
>middle layer which serves the requests from the client. This is not an
>easy task for us.
>
>Is there any tools or middle wares to do this task ?
>
>Regards
>Kiron

Hi Kiron

When I use DBFCDX precisely, I have an app on the server that executes tasks 
that clients demand (up to here similar to what you would need... I 
think.....) but the communication between the app and the client is done 
with temporary files located in a shared folder -

This app runs an application that resolves the client's request (in a 
multi-threaded way) and controls its execution with the Pablo Bottle's 
TRunProcess () utility, in this way I can meet several requests at once

Finally, I understand that this proposal would have to change the use of 
temporary files by a dialogue via socket or DCOM, which I do not have

If the proposal serves or interests you, I ask you to continue privately

regards



"Jacob John" escribió en el mensaje de 
noticias:84tdqe9gq7ljm04071ucrjdh9l4579fhom@4ax.com...

Hi,

Yes. I am looking for a generalised Middleware which is installed in
the App Server and can handle all the Database request between the
application and ADS.

Is there anything like that ?

Regards
Kiron



On Tue, 15 Oct 2019 10:13:15 -0300, "Jorge L. Borlando"
<jlborlando@yahoo.com.ar> wrote:

>Sorry for having misunderstood the situation, in other words..., instead of
>sending the queries to the database directly, you would send it to another
>place..., where an application on the server resolves them and this app
>returns them ?
>
>
>
>"Jorge L. Borlando"  escribió en el mensaje de
>noticias:49a25e1c$8d31850$54434@news.alaska-software.com...
>
>Hi, yo can trie with this example.....
>
>      oConn := DacSession():New( "DBE=ADSDBE;"                       +;
>                                 "SERVER=\\MYSERVER\DATA\MYAPLICATION;" +;
>                                 "UID=nameuser;"                   +;
>                                 "PWD=userpassword;"                     +;
>                                 "Compression=Allways;"              +;7
>                                 "DefaultType=Clipper;"              +;
>                                 "Rows=False;"                       +;
>                                 "Language=OEM:ads_ascii;"           +;
>                                 "AdvantageLocking=OFF;"             +;
>                                 "Locking=Record;"                   +;
>                                 "MemoBlockSize=512;"                +;
>                                 "MaxTableCloseCache=5;"             +;
>                                 "ServerTypes=7;"                    +;
>                                 "TrimTrailingSpaces=False"           )7
>in ads_cfg.ini
>[Settings]
>ServiceName=Advantage
>ADS_SERVER_TYPE = 7
>RETRY_ADS_CONNECTS = 1
>MAX_CONNECTIONS = 100
>MAX_TIMEOUTS = 40
>COMPRESSION = Always
>
>[DRIVERS]
>
>[MyServer]
>LAN_IP=10.0.0.101     <- your server IP
>
>
>
>"Jacob John" escribió en el mensaje de
>noticias:66taqehtlv4ds1umtn7bouv8ksgrjmb2rh@4ax.com...
>
>Hi,
>
>We are using xBase++ and Advantage Database Server for Application
>development. Is there any to connect to ADS other than \\IP:Port
>combination
>
>My requirement is as follows.
>
>One of the customer restructured their hardware and network
>infrastructure. They sepeared Application Server (App Server) and
>Database Server (DB Server). Now we have put the executables in App
>Server. Ant put the ADS and Data in DB Server. Now the  application
>connect to ADS through the 6262 port of DB Server.
>
>Now they says that Client application should not connec to DB Server
>directely. Client should connect to App Server only. And only App
>server should connect to Database. Basically they want us to create a
>middle layer which serves the requests from the client. This is not an
>easy task for us.
>
>Is there any tools or middle wares to do this task ?
>
>Regards
>Kiron