Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
From: dag.wanvik@oracle.com (Dag H. Wanvik)
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Unable to connect to Derby 10.8.2.2 with IBM DB2 v 9.7 Data
 Client
References: <007901ccb99e$2fbcb790$8f3626b0$@com>
Date: Thu, 15 Dec 2011 01:06:38 +0100
In-Reply-To: <007901ccb99e$2fbcb790$8f3626b0$@com> (Janardhan Mallela's
	message of "Tue, 13 Dec 2011 19:20:30 +0530")
Message-ID: <x6aa6u7l69.fsf@oracle.com>
User-Agent: Gnus/5.110017 (No Gnus v0.17) Emacs/23.1 (usg-unix-v)
MIME-Version: 1.0
Content-Type: text/plain

Janardhan Mallela <jmalyala@zetainteractive.com> writes:

> Hi,
>
>  
>
> My need is to connect to Derby through PHP. I am unable to connect to Derby
> 10.8.2.2 with IBM DB2 v 9.7 Data Client using PHP. But I am able to connect
> to Derby 10.4.2.2 with same IBM DB 2 connector.  Following is the error I am
> getting. Let me know, if anyone got this problem. It would be helpful to me,
> if any workaround provided. 

Derby 10.8 (it's been this way for some time) only supports the Derby
client driver, so you are out of luck if you need to use the newer Derby
drivers, I'm afraid.

Thanks,
Dag


>
>  
>
>  
>
> At Derby:
>
>  
>
> org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because
> of a Distributed Protocol Error:  DRDA_Proto_PRCCNVRM; CODPNT arg  = 106e;
> Error Code Value = 12
>
>         at org.apache.derby.impl.drda.DRDAConnThread.rdbnamMismatch(Unknown
> Source)
>
>         at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown
> Source)
>
>         at
> org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown
> Source)
>
>         at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
> Source)
>
>        at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
>
>  
>
> At IBM DB2 Client:
>
> SQLSTATE[08001] SQLDriverConnect: -30020 [IBM][CLI Driver] SQL30020N
> Execution of the command or SQL statement failed because of a syntax error
> in the communication data stream that will affect the successful execution
> of subsequent commands and SQL statements:  Reason Code "0x1245"("0212")"".
> SQLSTATE=58009
>
>  
>
>  
>
>  
>
> Regards,
>
> Janardhan Mallela | Tech Lead
>
>  
>
> zetainteractive
>
> Elite Plaza, Somajiguda, Hyderabad, AP 500082
>
> T +91 40 40309000 |Ext-247
>
> www.zetainteractive.com
>
>  
>
> Follow Zeta Interactive:
>
>  <http://blog.zetainteractive.com/> blog_24x24
> <http://www.facebook.com/ZetaInteractive> facebook_24x24
> <http://twitter.com/zetainteractive> twitter_24x24
> <http://www.linkedin.com/companies/18763> linkedin_24x24
>
> Zeta_EmailQRCode
>
>  
>
>  
>
>