Devart Forums

Few questions please on getting UniDAC 6.0.2 for XE7 to connect to Sybase ASE 16.0.

I've installed ASE on a virtual machine and have confirmed it's up and able to query from that machine, etc. I'm now trying to access that server from another machine on the network using UniDAC.

Questions...

1. Past posts seem to indicate a client has to be installed on the non-server machine. Is a client required, or is just a registered ODBC driver required?

2. A past post also seems to hint at support was coming for dealing with ASE sql.ini files. Was this ever delivered? I checked the history and could not reference it.

3. After trying to work with a registered ODBC driver copied from the ASE 16 install, I can get UniDAC to recognize that the driver is present -- but no success getting a connection, either via UniDAC or with testing from a DSN. I'm now in search of said client. Various posts say it's part of the "SDK", others say it's "PC Client", and yet others say that it's part of the ASE 16 full install. Can anyone shed any light here?

Thanks in advance.

Hello,

1) The client must be installed.
2) Yes, sql.ini is supported.
3) You need to install the complete ASE client.

The SAP download/search facility makes it very difficult to find what is needed, and there was a change between ASE 15.x and 16.x on what clients are available and how they are distributed. The needed client, if you want it separate from the ASE server install, is called the "SAP SDK for Adaptive Server Enterprise".

However, the magic bullet is simply the SAP Store. There one can find trials for all of the late version clients (don't know why it's a trial vs. just a download).

Link...
https://store.sap.com/sap/cpa/ui/resour ... 73286474-0

Thanks.

Yes, you can use this ODBC driver with UniDAC for work with a database.

Yes, after I installed this SDK, UniDAC detected the ODBC driver and had no trouble getting to the ASE server. Thanks.

If you have any further questions, feel free to contact us.