How to establish a connection to the ADI server without Server lib

[Former Member]

Kindly Looking forward Technical Assistance and our requirement as
followed below:

I am developing a tiny tool to read Employee's Clock in/out data from adi
file format  in one of our customer system and they were installed client
setup to store data in adi file format without Advantage Architect
Database Server where they are generating the report in excel and also
able to access the data from their software application.

Now similarly we want to read this data as per our software requirement to
integrate Attendance and Employee service  using jdbc driver to read data
where in this case we tried to establish a connection as suggested in the
portal and its not working properly.

Kindly guide me the basic requirement to establish the adi database
connectivity and also please suggest me the version and application
requirement detail.

[michael_loop]

According to the Advantage help file. "Once the driver is installed, you can connect from your application to the Advantage Database Server with a connection URL through the JDBC driver manager."

The database server is required because the JDBC driver needs a host and a port to connect to. Without the Advantage Database Server, you would be making a local connection. There is no server or port for the JDBC driver to connect to.

Excel would be using ODBC or OLEDB. Architect uses Delphi drivers. All of these support local server connections.

I hope this helps,

Mike Loop
Senior Product Support Engineer
SAP Product Support