[unixODBC-support] cant connect MS SQL with Oracle

[Nick Gorham]

Вадим Р.Исмагилов wrote:
> AIX 6.1 Oracle 10.2.0.4 MS SQL Server 2005
>   

Ok, thought so, support can help you.

It will probably be a missmatch between 32 and 64 bit.
> -----Original Message-----
> From: Nick Gorham <nick.gorham at easysoft.com>
> To: "Вадим Р.Исмагилов"<admin1 at mail.ru>
> Date: Tue, 12 Jan 2010 13:37:30 +0000
> Subject: Re: cant connect MS SQL with Oracle
>
>   
>> Вадим Р.Исмагилов wrote:
>>     
>>> next problem
>>>
>>>
>>> SQL>  select 1 from dual at TST;
>>>  select 1 from dual at TST
>>>                     *
>>>   
>>>       
>> What platform is this on?
>>
>> It may be best sending this to the main support desk 
>> support at easysoft.com now the holiday period is over.
>>
>> I would try
>>
>> file /usr/local/easysoft/unixODBC/lib/libodbc.so
>>
>> ldd /usr/local/easysoft/unixODBC/lib/libodbc.so
>>
>> And see what response both those commands give.
>>
>>
>>     
>>> ERROR at line 1:
>>> ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
>>> [Generic Connectivity Using ODBC][C077] Could not find symbol 'SQLAllocConnect'
>>> in dynamic library
>>> [C079] Failed to load dynamic library
>>> '/usr/local/easysoft/unixODBC/lib/libodbc.so'
>>> ORA-02063: preceding 3 lines from TST
>>>
>>> -----Original Message-----
>>> From: Nick Gorham <nick.gorham at easysoft.com>
>>> To: Vadim <admin1 at mail.ru>, support <support at easysoft.com>
>>> Date: Tue, 29 Dec 2009 23:26:00 +0000
>>> Subject: Re: cant connect MS SQL with Oracle
>>>
>>>   
>>>       
>>>> Vadim wrote:
>>>>     
>>>>         
>>>>> why it's not present in documentation and know bugs?????
>>>>>   
>>>>>       
>>>>>           
>>>> Yes, you are right, it should be in the docs.
>>>>
>>>> -- 
>>>> Nick
>>>>     
>>>>         
>>>>> -----Original Message-----
>>>>> From: Nick Gorham [mailto:nick.gorham at easysoft.com]
>>>>> Sent: Tuesday, December 29, 2009 6:11 PM
>>>>> To: "Вадим Р.Исмагилов"
>>>>> Subject: Re: cant connect MS SQL with Oracle
>>>>>
>>>>>
>>>>> Вадим Р.Исмагилов wrote:
>>>>>   
>>>>>       
>>>>>           
>>>>>> doing
>>>>>> 1. run install, choise integrated to product odbc, licensing
>>>>>> 2. configuring oracle
>>>>>> 3. run sqlplus
>>>>>> SQL>  select * from dual at TST;
>>>>>>  select * from dual at TST
>>>>>>                     *
>>>>>> ERROR at line 1:
>>>>>> ORA-28500: connection from ORACLE to a non-Oracle system returned this
>>>>>>     
>>>>>>         
>>>>>>             
>>>>> message:
>>>>>   
>>>>>       
>>>>>           
>>>>>> [Generic Connectivity Using ODBC][C078] Dynamic library
>>>>>> '/usr/local/easysoft/unixODBC/lib/libodbc.so' was not found
>>>>>> ORA-02063: preceding 2 lines from EMPIBANK2
>>>>>>
>>>>>> compile version unixODBC 2.1.15 pre
>>>>>>
>>>>>>   SQL> SQL> select * from dual at TST;
>>>>>> ERROR at line 1:
>>>>>> ORA-28500: connection from ORACLE to a non-Oracle system returned this
>>>>>>     
>>>>>>         
>>>>>>             
>>>>> message:
>>>>>   
>>>>>       
>>>>>           
>>>>>> [Generic Connectivity Using ODBC][C077] Could not find symbol
>>>>>>     
>>>>>>         
>>>>>>             
>>>>> 'SQLAllocConnect'
>>>>>   
>>>>>       
>>>>>           
>>>>>> in dynamic library
>>>>>> [C079] Failed to load dynamic library
>>>>>> '/usr/local/easysoft/unixODBC/lib/libodbc.so'
>>>>>> ORA-02063: preceding 3 lines from TST
>>>>>>
>>>>>> reading part 5.2 unixODBC on AIX
>>>>>> recomendation
>>>>>> ar -tv libodbc.a
>>>>>> and nofing creates
>>>>>>
>>>>>>     
>>>>>>         
>>>>>>             
>>>>> Hi,
>>>>>
>>>>> You need to set the 64 or 32 bit more before extracting from the
>>>>> archive. If you have the 32 version try
>>>>>
>>>>> export OBJECT_MODE=32
>>>>> ar -tv libodbc.a
>>>>>
>>>>> or substitute 64 if its 64 bit you need.
>>>>>
>>>>> --
>>>>> Nick Gorham
>>>>> Easysoft Limited
>>>>>
>>>>>
>>>>>   
>>>>>       
>>>>>           
>>>   
>>>       
>
>
>