PROBLEM UNIXODBC with Oracle 11g i386

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

PROBLEM UNIXODBC with Oracle 11g i386

Oscar Andres Mora Ibarra

dear Friend

 

I need help with the following problem

 

isql -v ORCL

isql: symbol lookup error: /usr/lib/oracle/11.2/client/lib/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW

 

version unixODBC -2.2.11-10 EL5.I386

ORACLE VERSION 11.2.0.1.0-1.I386

CENTOS 5.0 I386


Oscar Andrés Mora Ibarra

Técnico en Plataformas Informáticas.

Mobile Phone: +56 - 5 788 7991

Mobile Phone: +56 - 7 989 1411

Msn: [hidden email]

Msn: [hidden email]

Skype: omora23

Twitter: OscarMoraIbarra

Linkedin: http://www.linkedin.com/pub/oscar-andres-mora-ibarra/36/b49/894


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

Re: PROBLEM UNIXODBC with Oracle 11g i386

Nick Gorham-2
On 24/04/14 16:30, Oscar Andres Mora Ibarra wrote:

dear Friend

 

I need help with the following problem

 

isql -v ORCL

isql: symbol lookup error: /usr/lib/oracle/11.2/client/lib/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW

 

version unixODBC -2.2.11-10 EL5.I386

ORACLE VERSION 11.2.0.1.0-1.I386

CENTOS 5.0 I386


2.2.11 is dated 4-March-2005, I think you need a later version of the driver manager.

--
Nick

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

Re: PROBLEM UNIXODBC with Oracle 11g i386

Oscar Andres Mora Ibarra
thanks for the quick response, unixodbc recommend to work with oracle 11g

Oscar Andrés Mora Ibarra

Técnico en Plataformas Informáticas.

Mobile Phone: +56 - 5 788 7991

Mobile Phone: +56 - 7 989 1411

Msn: [hidden email]

Msn: [hidden email]

Skype: omora23

Twitter: OscarMoraIbarra

Linkedin: http://www.linkedin.com/pub/oscar-andres-mora-ibarra/36/b49/894




Date: Thu, 24 Apr 2014 16:44:00 +0100
From: [hidden email]
To: [hidden email]
Subject: Re: [unixODBC-support] PROBLEM UNIXODBC with Oracle 11g i386

On 24/04/14 16:30, Oscar Andres Mora Ibarra wrote:

dear Friend

 

I need help with the following problem

 

isql -v ORCL

isql: symbol lookup error: /usr/lib/oracle/11.2/client/lib/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW

 

version unixODBC -2.2.11-10 EL5.I386

ORACLE VERSION 11.2.0.1.0-1.I386

CENTOS 5.0 I386


2.2.11 is dated 4-March-2005, I think you need a later version of the driver manager.

--
Nick

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

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

Re: PROBLEM UNIXODBC with Oracle 11g i386

Nick Gorham-2
On 24/04/14 16:51, Oscar Andres Mora Ibarra wrote:
thanks for the quick response.

Well, the bottom line is the driver is expecting libodbcinst.so to be exporting SQLGetPrivateProfileStringW, it seems in your case its not, so either the recommendation was wrong, or its not finding the lib expect.

    ldd /path/to/driver/libdrv.so

And see what libodbcinst.so its finding.

Then try

    nm -s | grep GetPrivateProfileString

To see what its exporting.

"unixodbc recommend to work with oracle 11g"

Maybe, but not by me :-)

--
Nick

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

Re: PROBLEM UNIXODBC with Oracle 11g i386

Oscar Andres Mora Ibarra

i dont have libdrv.so and libodbcinst.so


[root@localhost lib]# ls
libclntsh.so       libocci.so       libsqora.so.11.1  orai18n-mapping.jar
libclntsh.so.11.1  libocci.so.11.1  ojdbc5.jar        ottclasses.zip
libheteroxa11.so   libociei.so      ojdbc6.jar        xstreams.jar
libnnz11.so        libocijdbc11.so  orai18n.jar
[root@localhost lib]# pwd
/usr/lib/oracle/11.2/client/lib
[root@localhost lib]# 


Oscar Andrés Mora Ibarra

Técnico en Plataformas Informáticas.

Mobile Phone: +56 - 5 788 7991

Mobile Phone: +56 - 7 989 1411

Msn: [hidden email]

Msn: [hidden email]

Skype: omora23

Twitter: OscarMoraIbarra

Linkedin: http://www.linkedin.com/pub/oscar-andres-mora-ibarra/36/b49/894




Date: Thu, 24 Apr 2014 17:27:37 +0100
From: [hidden email]
To: [hidden email]
Subject: Re: [unixODBC-support] PROBLEM UNIXODBC with Oracle 11g i386

On 24/04/14 16:51, Oscar Andres Mora Ibarra wrote:
thanks for the quick response.

Well, the bottom line is the driver is expecting libodbcinst.so to be exporting SQLGetPrivateProfileStringW, it seems in your case its not, so either the recommendation was wrong, or its not finding the lib expect.

    ldd /path/to/driver/libdrv.so

And see what libodbcinst.so its finding.

Then try

    nm -s | grep GetPrivateProfileString

To see what its exporting.

"unixodbc recommend to work with oracle 11g"

Maybe, but not by me :-)

--
Nick

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

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

Re: PROBLEM UNIXODBC with Oracle 11g i386

Nick Gorham-2
On 24/04/14 18:58, Oscar Andres Mora Ibarra wrote:

i dont have libdrv.so and libodbcinst.so

"libdrv.so" was meant to be a example of whatever driver you are using.

libodbcinst.so will ahve been installed when you installed the unixODBC package.

--
Nick

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

Re: PROBLEM UNIXODBC with Oracle 11g i386

Oscar Andres Mora Ibarra
I have many problems installing unixODBC ORACLE 11G x86 + x86, you have some document to install.

Atte.

Oscar Andrés Mora Ibarra

Técnico en Plataformas Informáticas.

Mobile Phone: +56 - 5 788 7991

Mobile Phone: +56 - 7 989 1411

Msn: [hidden email]

Msn: [hidden email]

Skype: omora23

Twitter: OscarMoraIbarra

Linkedin: http://www.linkedin.com/pub/oscar-andres-mora-ibarra/36/b49/894




Date: Thu, 24 Apr 2014 20:06:19 +0100
From: [hidden email]
To: [hidden email]
Subject: Re: [unixODBC-support] PROBLEM UNIXODBC with Oracle 11g i386

On 24/04/14 18:58, Oscar Andres Mora Ibarra wrote:

i dont have libdrv.so and libodbcinst.so

"libdrv.so" was meant to be a example of whatever driver you are using.

libodbcinst.so will ahve been installed when you installed the unixODBC package.

--
Nick

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

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