trying to use unixODBC with sas9.3 on AIX

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

trying to use unixODBC with sas9.3 on AIX

c2dove

To support:

     unixODBC mgr installed and valid connections in odbc.ini test via isql

 

Tried to get this working with the SAS/Access module and got the following errors

Could not load /sas93/software/SASFoundations/9.3/sasexe/sasodb

Dependent module /usr/local/unixODBC/lib/libodbc.a(odbc.so)  could not be loaded. Member odbc.so is not found in archive load module /sas93/software/SASFoundations/9.3/sasexe/sasodb

 

 

Using the following lib statement in SAS  libname mydblib odbc datasrc=CIDDQ user=wc1a password=mypassword

 

ldd sasodb

sasodb needs:

         /usr/local/unixODBC/lib/libodbc.a(odbc.so)

ar: 0707-109 Member name odbc.so does not exist.

dump: /tmp/tmpdir9765012/extract/odbc.so: 0654-106 Cannot open the specified file.

         /usr/lib/libc_r.a(shr_64.o)

         /unix

         /usr/lib/libcrypt.a(shr_64.o)

         /usr/lib/libc.a(shr_64.o)

 

Suggestions please!?!?!


---------------------------------------------------------------------
Call 1.888.FC DIRECT (1.888.323.4732) or visit us on the web at www.firstcitizens.com today to take advantage of our great products and services.
This electronic mail and any files transmitted with it are confidential and are intended solely for the use of individual or entity to whom they are addressed. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that if you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.
First Citizens Bank - Helping our customers achieve a lifetime of success. Visit us on the web at www.firstcitizens.com - Member FDIC
---------------------------------------------------------------------


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|

Re: trying to use unixODBC with sas9.3 on AIX

Nick Gorham-2
On 11/09/14 20:13, Dove, Charles wrote:

To support:

     unixODBC mgr installed and valid connections in odbc.ini test via isql

 

Tried to get this working with the SAS/Access module and got the following errors

Could not load /sas93/software/SASFoundations/9.3/sasexe/sasodb

Dependent module /usr/local/unixODBC/lib/libodbc.a(odbc.so)  could not be loaded. Member odbc.so is not found in archive load module /sas93/software/SASFoundations/9.3/sasexe/sasodb

 

 

Using the following lib statement in SAS  libname mydblib odbc datasrc=CIDDQ user=wc1a password=mypassword


Two possible things, either your build created a libodbc.so.1 in the .a, in which case its a simple matter of removing the .so.1 with ar, rename to .so and add back into the .a.

Or the lib contains a 32 bit .so and SAS is looking for a 64 bit one (or the other way around).

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support