[unixODBC-support] Re: unixODBC-support Digest, Vol 34, Issue 11

Даниил Меграбян danil.megrabjan at gmail.com
Mon Jul 2 09:15:07 BST 2007


Excuse me for my long reply. I leave my office for some time.

I fix my odbcinst.ini and in trace file i have bellow:

[ODBC][13741][__handles.c][444]
		Exit:[SQL_SUCCESS]
			Environment = 0x80521258
[ODBC][13741][SQLSetEnvAttr.c][182]
		Entry:
			Environment = 0x80521258
			Attribute = SQL_ATTR_ODBC_VERSION
			Value = 0x3
			StrLen = 0
[ODBC][13741][SQLSetEnvAttr.c][349]
		Exit:[SQL_SUCCESS]
[ODBC][13741][SQLAllocHandle.c][346]
		Entry:
			Handle Type = 2
			Input Handle = 0x80521258
[ODBC][13741][SQLAllocHandle.c][464]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x805f7120
[ODBC][13741][SQLSetConnectAttr.c][318]
		Entry:
			Connection = 0x805f7120
			Attribute = SQL_ATTR_AUTOCOMMIT
			Value = 0x1
			StrLen = -6
[ODBC][13741][SQLSetConnectAttr.c][500]
		Exit:[SQL_SUCCESS]
[ODBC][13741][SQLSetConnectAttr.c][318]
		Entry:
			Connection = 0x805f7120
			Attribute = SQL_ATTR_ODBC_CURSORS
			Value = (nil)
			StrLen = -6
[ODBC][13741][SQLSetConnectAttr.c][500]
		Exit:[SQL_SUCCESS]
[ODBC][13741][SQLDriverConnect.c][678]
		Entry:
			Connection = 0x805f7120
			Window Hdl = (nil)
			Str In = [Driver=Adaptive Server Anywhere
9.0;ServerName=web9;DatabaseName=infin_web;CharSet=utf8;ConnectionName=InfinTrio;CommLinks=tcpip...][length
= 188]
			Str Out = 0xbfbd4b48
			Str Out Max = 1023
			Str Out Ptr = 0xbfbd4b44
			Completion = 0
		UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][13741][SQLDriverConnect.c][1487]
		Exit:[SQL_SUCCESS]
			Connection Out [Driver=Adaptive Server Anywhere
9.0;UID=bagroff;PWD=777777;Datab...]
[ODBC][13741][SQLAllocHandle.c][511]
		Entry:
			Handle Type = 3
			Input Handle = 0x805f7120
[ODBC][13741][SQLAllocHandle.c][873]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x8063ced8

And in php debug: PDO::__construct(): SQLSTATE[IM001]: Driver does not
support this function: driver does not support setting attributes

2007/6/19, unixodbc-support-request at easysoft.com
<unixodbc-support-request at easysoft.com>:
> Send unixODBC-support mailing list submissions to
>         unixodbc-support at easysoft.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> or, via email, send a message with subject or body 'help' to
>         unixodbc-support-request at easysoft.com
>
> You can reach the person managing the list at
>         unixodbc-support-owner at easysoft.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of unixODBC-support digest..."
>
>
> Today's Topics:
>
>    1. Sybase ASA 9 unixODBC driver ( ?????? ???????? )
>    2. Re: Sybase ASA 9 unixODBC driver (Nick Gorham)
>    3. Re: RE: Repost - Install questions (HAS)
>    4. Re: RE: Repost - Install questions (HAS)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 18 Jun 2007 16:37:32 +0400
> From: " ?????? ???????? " <danil.megrabjan at gmail.com>
> Subject: [unixODBC-support] Sybase ASA 9 unixODBC driver
> To: unixodbc-support at easysoft.com
> Message-ID:
>         <6b7f16a0706180537r211b5279ud595adc7f113a347 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hello2All!
>
> OS: SLED10
> PHP 5.2.1 + PDO_ODBC
> unixODBC 2.2.11
>
> > cat /etc/unixODBC/odbcinst.ini
> [ODBC Drivers]
> Adaptive Server Anywhere 9.0=Installed
> Trace           = Yes
> TraceFile       = /tmp/unixODBC.trace
> LogFile         = /tmp/unixODBC.log
> ForceTrace      = Yes
> Pooling         = No
>
> [Adaptive Server Anywhere 9.0]
> Description=Sybase SQL Anywhere 9.0.2
> Driver=/opt/sybase/SYBSsa9/lib/libdbodbc9.so
> Setup=/opt/sybase/SYBSsa9/lib32/libdbodbc9.so
> UsageCount=1
> TraceFile=/tmp/asa90.unixODBC.trace
>
> I have some troubles with persistent connection on Sybase ASA 9 unixODBC driver.
>
> [php code]
> $dbc = new PDO('odbc:Driver=Adaptive Server Anywhere
> 9.0;ServerName=web9;DatabaseName=web_db;CharSet=utf8;ConnectionName=MyWebApp;CommLinks=tcpip(Host=dbsrv;Port=49153)',
> 'bagroff', '777777', array(PDO::ATTR_PERSISTENT => true));
> [/php code]
>
> If i use connection attribute ( PDO::ATTR_PERSISTENT => true ) from
> php_debug i receive error message like this:
>
> [php debug]
> Debug Warning: PHPDocument1 line 2 - PDO::__construct():
> SQLSTATE[IM001]: Driver does not support this function: driver does
> not support setting attributes.
> [/php debug]
>
> But, despite everything in Sybase Central I'll see, that my connection
> exists (even when php script ending execution).
>
> If i try to connect in the next time with such script. PHP do not
> initialize new connection, it use early created.
>
> When my trouble?
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 18 Jun 2007 13:35:11 +0100
> From: Nick Gorham <nick.gorham at easysoft.com>
> Subject: Re: [unixODBC-support] Sybase ASA 9 unixODBC driver
> To: Support for the unixODBC project <unixodbc-support at easysoft.com>
> Message-ID: <46767BFF.6030207 at easysoft.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Даниил Меграбян wrote:
>
> > Hello2All!
> >
> > OS: SLED10
> > PHP 5.2.1 + PDO_ODBC
> > unixODBC 2.2.11
> >
> >> cat /etc/unixODBC/odbcinst.ini
> >
> > [ODBC Drivers]
> > Adaptive Server Anywhere 9.0=Installed
> > Trace = Yes
> > TraceFile = /tmp/unixODBC.trace
> > LogFile = /tmp/unixODBC.log
> > ForceTrace = Yes
> > Pooling = No
>
> Thats a bit mixed up, the tracing goes into a [ODBC] section, and
> unixODBC doesn't need the [ODBC Drivers] section, use
>
> [ODBC]
> Trace = Yes
> TraceFile = /tmp/unixODBC.trace
> ForceTrace = Yes
> Pooling = No
>
> >
> > [Adaptive Server Anywhere 9.0]
> > Description=Sybase SQL Anywhere 9.0.2
> > Driver=/opt/sybase/SYBSsa9/lib/libdbodbc9.so
> > Setup=/opt/sybase/SYBSsa9/lib32/libdbodbc9.so
> > UsageCount=1
> > TraceFile=/tmp/asa90.unixODBC.trace
> >
> > I have some troubles with persistent connection on Sybase ASA 9
> > unixODBC driver.
>
> I haven't any direct experence of that, but allowing the logging to work
> may well help.
>
> --
> Nick Gorham
> Easysoft Limited
> http://www.easysoft.com, http://www.unixODBC.org
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 18 Jun 2007 06:52:23 -0700 (PDT)
> From: HAS <howard.stein at fmr.com>
> Subject: Re: [unixODBC-support] RE: Repost - Install questions
> To: unixodbc-support at easysoft.com
> Message-ID: <11176045.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> > SQL> select count(*) from tcadbo.actions_stg
> > [IM003][unixODBC][Driver Manager]Specified driver could not be loaded
> > [ISQL]ERROR: Could not SQLAllocStmt
>
> Still looking for a solution, I noticed this article, different OS but same
> description of problem and qutie a few people:
> http://forums.oracle.com/forums/thread.jspa?threadID=340030&tstart=0
>
> I did a dltest and got
>
> bash-3.00$ ./dltest /export/home/tcaadmin/howard/ic/libsqora.so.10.1
> SQLAllocStmt
> SUCCESS: Loaded /export/home/tcaadmin/howard/ic/libsqora.so.10.1
> ERROR: ld.so.1: dltest: fatal: SQLAllocStmt: can't find symbol
>  Could not find SQLAllocStmt
>
> So is the real error that it can't find the function in the library?
>
> --
> View this message in context: http://www.nabble.com/Repost---Install-questions-tf3908337.html#a11176045
> Sent from the unixODBC - Support mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 18 Jun 2007 07:48:50 -0700 (PDT)
> From: HAS <howard.stein at fmr.com>
> Subject: Re: [unixODBC-support] RE: Repost - Install questions
> To: unixodbc-support at easysoft.com
> Message-ID: <11177178.post at talk.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> > SQL> select count(*) from tcadbo.actions_stg
> > [IM003][unixODBC][Driver Manager]Specified driver could not be loaded
> > [ISQL]ERROR: Could not SQLAllocStmt
>
> Moments ago I got my account activated to go onto Oracle's metalink site, I
> immediately found something about a bug and it was identical except it was a
> different OS.  The people having the issue claimed if they used the Easy
> soft driver for Oracle it worked fine.  Oracle's response was that the OS in
> question was not supported and to use a third party driver.  However,
> according to Oracle, Solaris on sparc 64 should be supported so i've asked
> them to reopen the bug.  We'll see what they have to say.
>
> --
> View this message in context: http://www.nabble.com/Repost---Install-questions-tf3908337.html#a11177178
> Sent from the unixODBC - Support mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
>
> End of unixODBC-support Digest, Vol 34, Issue 11
> ************************************************
>


-- 
Daniil A Megrabjan | email danil.megrabjan at gmail.com | icq 4545450


More information about the unixODBC-support mailing list