topic Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06) in Administration and Deployment

How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

kaushalsolanki — Mon, 29 Jul 2019 12:43:47 GMT

Dear All,

Request you to guide me how i can have a odbc connectivity with ASE Sybase.

Thanks,

Kaushal

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

SASKiwi — Tue, 30 Jul 2019 05:04:08 GMT

I'm assuming you are using SAS 9.4. This link will get you started with configuration (page 61):

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

kaushalsolanki — Tue, 30 Jul 2019 05:51:37 GMT

Thank you for the response, i assume we need a odbc driver for specific database (ASE Sybase).

Please guide me which odbc drivers i need to install for having ODBC connection.

Regards,

Kaushal Solanki

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

SimonDawson — Tue, 30 Jul 2019 12:00:22 GMT

This is a question you might ask in the SAP Q&A Forum. There are not likely to be very large numbers of folks in the SAS community using SAP ASE with ODBC, the SAP community likely has significantly more people using SAP ASE with ODBC who might give you advice. SAS would be just like all other applications interacting with SAP ASE via ODBC so advice from the SAP community about their ODBC configurations for other applications will be applicable to your SAS deployment too.

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

SASKiwi — Wed, 31 Jul 2019 20:00:06 GMT

@kaushalsolanki - I am sure you can do a Google search for available ODBC drivers as well as I can as that is the only way I can answer your question. You could also open a track with SAS Tech Support to see if they have any more specific advice.

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

kaushalsolanki — Wed, 21 Aug 2019 08:48:19 GMT

Thank you for the response.

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

SASKiwi — Wed, 21 Aug 2019 19:58:49 GMT

@kaushalsolanki - have you got it working yet?

Re: How to configure SAS/ACCESS Interface to ODBC Connection on Linux with a ASE Sybase (16.0.02.06)

kaushalsolanki — Thu, 22 Aug 2019 03:01:47 GMT

@SASKiwi - Haven't yet, tried through data flux as well.