Can't run Advantage Local Server on remote desktop/server

[sudi...@gmail.com]

Hello,

I can't run Advantage Local server on remote Windows 10 or Windows Server 2012 using Microsoft Remote Desktop. Here is a sample program :

#include "ads.ch"

Proc Main

REQUEST ADS

RDDSETDEFAULT("ADS")

ADSSetFileType( ADS_CDX )

ADSSetServerType( ADS_LOCAL_SERVER )


USE ("C:\AdsTest\TEST.dbf") ALIAS "test" VIA "ADSCDX" NEW SHARED


ADSCreateSQLStatement("test",2)

ADSExecuteSQLDirect("select * from test"

test->(DBGOTOP())

Browse()

CLS

RETURN

Please copy it in C:\AdsTest folder and copy a dbf file named test.dbf file into it.

Thanks

aSudip

[Ella Stern]

It looks like the issue depends on the version of Advantage you are using, and also on the manner of the data usage:

http://ksho-star.blogspot.ro/2011/06/remote-desktop-connection-advantage.html
http://devzone.advantagedatabase.com/dz/Content.aspx?Key=17&RefNo=120202-2471

I'm not an Advantage user, I've just made a quick Google search. All the best.

[sudi...@gmail.com]

Hello Ella,

Thanks a lot. It solves the problem while adding following lines in ADS.INI and placing it in the application folder (as suggested by your given link)

[SETTINGS]
MTIER_LOCAL_CONNECTIONS=1

Best regards.

Sudip

[Ella Stern]

Great! :-)