Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS version and issues whiting ORACLE

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS version and issues whiting ORACLE
  • Date: Tue, 01 Dec 2009 22:21:22 +0100

Please read again my message then after checking everything send your
odbc.ini, odbcinst.ini and freetds.conf

freddy77

Il giorno mar, 01/12/2009 alle 07.35 -0800, Absalom Alcaraz ha scritto:
> Freddy77,
>
> As you can see below, isql can connect successfully:
> [ODBC][10992][1259680819.703982][SQLAllocHandle.c][482]
> Exit:[SQL_SUCCESS]
> Output Handle = 0x97856a0
> [ODBC][10992][1259680819.704611][SQLConnect.c][3614]
> Entry:
> Connection = 0x97856a0
> Server Name = [ITEST][length = 4 (SQL_NTS)]
> User Name = [userid][length = 9 (SQL_NTS)]
> Authentication = [********][length = 8 (SQL_NTS)]
> UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
> 'UCS-2LE'
>
> [ODBC][10992][1259680819.757160][SQLConnect.c][4188]
> Exit:[SQL_SUCCESS]
>
>
> Here is the connection string from the Oracle environment and it didn't
> worked:
> [ODBC][11324][1259681024.308960][SQLAllocHandle.c][482]
> Exit:[SQL_SUCCESS]
> Output Handle = 0x8360958
> [ODBC][11324][1259681024.309053][SQLDriverConnect.c][687]
> Entry:
> Connection = 0x8360958
> Window Hdl = (nil)
> Str In = [DSN=ITEST;UID=userid;PWD=********][length
> = 35 (SQL_NTS)]
> Str Out = 0xbfff86e0
> Str Out Max = 1020
> Str Out Ptr = 0xbfff86de
> Completion = 0
> UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
> 'UCS-2LE'
>
> DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data
> source
>
> [ODBC][11324][1259681024.327598][SQLDriverConnect.c][1267]
> Exit:[SQL_ERROR]
>
> I believe that is something wrong in my freetds.conf or my odcb.ini or
> odbcinst.ini. unless you have a different idea.
>
> Gracie.
>
>
>
>
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
> Sent: Monday, November 30, 2009 10:33 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] FreeTDS version and issues whiting ORACLE
>
> Il giorno lun, 30/11/2009 alle 10.04 -0800, Absalom Alcaraz ha scritto:
> > I installed FreeTDS to connect to a SQL Server in RedHat 3 with Oracel
> > 10g version 1.
> > I can connect and run select statements using isql.
> > I created the HS Oracle connection and started the listener. I can ping
> > successfully the database.
> >
> > When I connect to Oracle and execute a select statement, I got the
> > following error:
> > ERROR at line 1:
> > ORA-28500: connection from ORACLE to a non-Oracle system returned this
> > message:
> > [Generic Connectivity Using ODBC]DRV_InitTdp: errors.h (2059): ;
> > [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL
> > State:
> > S1000; SQL Code: 0)
> > ORA-02063: preceding 2 lines from ISATLK
> >
> > I contacted ORACLE. They review my configuration files and they told me
> > that my configuration is fine. Oracle advised me that the odbc driver is
> > not compatible with 10.1 of HS Connectivity. Suggest you contact FreeTDS.
> >
> > My questions are as follows:
> >
> >
> > - How can identify if I am using the latest and correct ODBC
> > driver version compatible with Oracle database 10 release 1?
> >
> > - Do I missing a step?
> >
> > Any ideas are appreciated.
> >
> > Thanks.
> >
>
> I'd enable unixODBC tracing, ie adding these lines to /etc/odbcinst.ini
>
> [ODBC]
> Trace=Yes
> TraceFile=/tmp/sql.txt
>
> keep in mind that this configuration slow down A LOT ODBC, enable it,
> issue a connect and that remove this configuration.
>
> You should see SQLConnect/SQLDriverConnect log and also look at file
> owner. Is possible that odbc connection is correct but not for Oracle
> account. To remove this possibility you should try to move odbc
> configuration from user ($HOME/.odbc.ini) to system one
> (usually /etc/odbc.ini). A way to do so is rename user file (ie: mv
> ~/.odbc.ini ~/.odbc.ini.save) and configure system file in order to make
> isql happy. Note also that system configuration files for unixODBC
> should be readable by everyone.
>
> $ ls -l /etc/odbc*
> -rw-r--r-- 1 root root 0 2008-09-01 09:15 /etc/odbc.ini
> -rw-r--r-- 1 root root 40 2009-03-06 20:56 /etc/odbcinst.ini
>
> to see configuration files you can use odbcinst
>
> $ odbcinst -j
> unixODBC 2.2.11
> DRIVERS............: /etc/odbcinst.ini
> SYSTEM DATA SOURCES: /etc/odbc.ini
> USER DATA SOURCES..: /home/freddy/.odbc.ini
>
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page