CODEWITHSUNDEEP
databasedatabase-connectionadvantage-database-server
Khorkhe
Khorkhe

Reputation: 1126

connect to a database server without exposing a network share

this is quite simple to do in many databases, but I have not yet found a way to achieve this with Advantage in Server-mode over the network.

assume 2 PCs:

If the folder containing this database was shared via the OS (network share, with read/write permissions), then establishing connection is straight-forward.

I am however, precisely trying to avoid exposing a network share. In Firebird, for example, this can be done using connection path: SYSDBA@SERVER:C:\SomePrivateFolder\myapp.FDB

Isn't this the reason for exposing a port for the database (6262)?

What's interesting is that they offer something called "internet" connection. I highly doubt they would require a network share over the internet to access the database.

So, is this doable, and if so, would love a hint.

Thanks!

Edit:

following the answer below, adding more details.

SERVER contains 2 folders, each one with its ADV Dictionary:

I am able to connect to the second one using the connect path \\SERVER:6262\DataShared\mydata.add

to connect to the first one i've tried:

none of which worked.

Note that I am not calling the stored procedure directly, but using the Delphi ADS components, which certainly internally call that same stored procedure. I am certainly connecting as Remote (have the ADS Server launched on SERVER). For the other parameters, I am using TCP/IP as comm. type, and default ADSSYS / blank password.

with this setup in mind, what would the path be to connect to C:\Data\mydata.add on \\SERVER?

Thanks again

Upvotes: 1

Views: 361

Answers (1)

reinaldo Crespo
reinaldo Crespo

Reputation: 123

No need to expose your database on a shared folder. You'd only do that if using the LOCAL connection. If using INTERNET or REMOTE, then simply connect using API AdsConnect60(). Look it up on the help file.

UNSIGNED32 AdsConnect60( UNSIGNED8 *pucConnectPath,
UNSIGNED16 usServerTypes,
UNSIGNED8 *pucUserName,
UNSIGNED8 *pucPassword,
UNSIGNED32 ulOptions,
ADSHANDLE *phConnect );

Furthermore, you can hide the path where your data resides by using a server side Alias. Look it up on the help files. It is quite simple.

To simplify things, do this: Run ads server configuration utility, go to "Configuration Utility" tab and inside that, go to "File Locations" tab. Write down path for Error and Assert Log Path. Let's assume it is c:. Let's also assume server is 192.168.1.1.

Now create a file named AdsServer.ini in that path (c:) with section: [ServerAliases] and a line adsdata=c:\data. Now use API function AdsConnect60 like this: AdsConnect60( "\\192.168.1.1\Adsdata\Mydata.add", ADS_REMOTE_SERVER, "adssys", "password", ADS_DEFAULT, &hConn ) ;

If you are working from Delphi or some other language make sure you check out the clases that are already built wrappers for the API.

It is all really-really well documented: http://devzone.advantagedatabase.com/dz/WebHelp/Advantage11.1/index.html?ace_adsconnect60.htm

Upvotes: 2

Related Questions