Oracle - unixODBC - wine - Win32 ODBC Apple

[Martin HEIN]

Hi folks,

I'm trying to connect some of our proprietory corporate Windows-based 
applictions via ODBC to our Oracle database by following as stated in 
the Wine User's Guide, Using ODBC, but it's to no avail! :(

I have setup

	* Oracle 10g Instant Client for Linux 10.1.0.3 
(/usr/local/oracle/10.1.0.3)
	* unixODBC 2.2.10 (/usr/local)
	* Oracle ODBC driver 0.5.4 (/usr)
	* CodeWeavers CrossOver Office 4.1 (/appl/os/CrossOver/cxoffice)

My environment looks like

	* ORACLE_BASE=/usr/local/oracle
	* ORACLE_VER=10.1.0.3
	* ORACLE_HOME=$ORACLE_BASE/$ORACLE_VER
	* TNS_ADMIN=$ORACLE_HOME/etc
	* LIB_ODBC_DRIVER_MANAGER=/usr/local/lib/libodbc.so

My configuration files are located under

	* tnsnames.ora: $ORACLE_HOME/etc
	* odbcinst.ini: /usr/local/etc
	* odbc.ini: /usr/local/etc

Using 'sqlplus' (Oracle; SQL*Net) or 'isql' (unixODBC; ODBC) to connect 
from the Unix command line to one of the configured databases works 
perfectly fine! But unfortunately I can't get unixODBC and wine working 
together! :(

Cheers,
Martin

--------------------------------------------------
T-Mobile Austria GmbH
Ing.Martin HEIN
Information Technologies / Services
Knowledge Management & Process Automation / Senior Manager

Rennweg 97-99
A-1030 Vienna
Fon: [phone]
Fax: [phone]
Mobile: [phone]
E-Mail: Martin.HEIN(a)T-Mobile.at
Web: http://www.T-Mobile.at
--------------------------------------------------
NOTICE AND DISCLAIMER:
This email (including attachments) is confidential.  If you have 
received this email in error please notify the sender immediately and 
delete this email from your system without copying or disseminating it 
or placing any reliance upon its contents.
--------------------------------------------------

[Bill Medland]

On January 21, 2005 02:26 am, Martin HEIN wrote:
> Hi folks,
>
> I'm trying to connect some of our proprietory corporate Windows-based
> applictions via ODBC to our Oracle database by following as stated in
> the Wine User's Guide, Using ODBC, but it's to no avail! :(
>
> I have setup
>
> * Oracle 10g Instant Client for Linux 10.1.0.3
> (/usr/local/oracle/10.1.0.3)
>   * unixODBC 2.2.10 (/usr/local)
>   * Oracle ODBC driver 0.5.4 (/usr)

Aha.  It's out nbow is it?  Can you give me a URL?
> * CodeWeavers CrossOver Office 4.1 (/appl/os/CrossOver/cxoffice)
>
> My environment looks like
>
> * ORACLE_BASE=/usr/local/oracle
>   * ORACLE_VER=10.1.0.3
>   * ORACLE_HOME=$ORACLE_BASE/$ORACLE_VER
>   * TNS_ADMIN=$ORACLE_HOME/etc
>   * LIB_ODBC_DRIVER_MANAGER=/usr/local/lib/libodbc.so
>
> My configuration files are located under
>
> * tnsnames.ora: $ORACLE_HOME/etc
>   * odbcinst.ini: /usr/local/etc
>   * odbc.ini: /usr/local/etc
>
> Using 'sqlplus' (Oracle; SQL*Net) or 'isql' (unixODBC; ODBC) to connect
> from the Unix command line to one of the configured databases works
> perfectly fine! But unfortunately I can't get unixODBC and wine working
> together! :(
>
> Cheers,
> Martin

Try running with 
export WINEDEBUG=odbc

See if the debug tells you any more.

-- 
Bill Medland
mailto:billmedland(a)mercuryspeed.com
http://webhome.idirect.com/~kbmed

[MediaHost (TM)]

I used to connect with native win32 ODBC  and Oracle ODBC drivers to a 
Oracle server....how about that? Why use unixODBC for wine?

Martin HEIN wrote:
> Hi folks,
>
> I'm trying to connect some of our proprietory corporate Windows-based 
> applictions via ODBC to our Oracle database by following as stated in 
> the Wine User's Guide, Using ODBC, but it's to no avail! :(
>
> I have setup
>
> * Oracle 10g Instant Client for Linux 10.1.0.3 
> (/usr/local/oracle/10.1.0.3)
> * unixODBC 2.2.10 (/usr/local)
> * Oracle ODBC driver 0.5.4 (/usr)
> * CodeWeavers CrossOver Office 4.1 (/appl/os/CrossOver/cxoffice)
>
> My environment looks like
>
> * ORACLE_BASE=/usr/local/oracle
> * ORACLE_VER=10.1.0.3
> * ORACLE_HOME=$ORACLE_BASE/$ORACLE_VER
> * TNS_ADMIN=$ORACLE_HOME/etc
> * LIB_ODBC_DRIVER_MANAGER=/usr/local/lib/libodbc.so
>
> My configuration files are located under
>
> * tnsnames.ora: $ORACLE_HOME/etc
> * odbcinst.ini: /usr/local/etc
> * odbc.ini: /usr/local/etc
>
> Using 'sqlplus' (Oracle; SQL*Net) or 'isql' (unixODBC; ODBC) to 
> connect from the Unix command line to one of the configured databases 
> works perfectly fine! But unfortunately I can't get unixODBC and wine 
> working together! :(
>
> Cheers,
> Martin
>
> --------------------------------------------------
> *T-Mobile Austria GmbH*
> *Ing.Martin HEIN*
> Information Technologies / Services
> Knowledge Management & Process Automation / Senior Manager
>
> Rennweg 97-99
> A-1030 Vienna
> *Fon*: [phone]
> *Fax*: [phone]
> *Mobile*: [phone]
> *E-Mai*l: Martin.HEIN(a)T-Mobile.at
> *Web*: http://www.T-Mobile.at
> --------------------------------------------------
> */NOTICE AND DISCLAIMER: /*/
> This email (including attachments) is confidential. If you have 
> received this email in error please notify the sender immediately and 
> delete this email from your system without copying or disseminating it 
> or placing any reliance upon its contents./
> --------------------------------------------------

-- 
Regards
 
Signer:      Eddy Nigg
Company: StartCom Linux at www.startcom.org <http://www.startcom.org/>
                MediaHost^(TM) at www.mediahost.org 
<http://www.mediahost.org/>
Skype:      startcom <callto://startcom/>
Phone:      [phone]