php - connecting to db2 through pdo_ibm module manually configured error SQL10007N -5005 -

-

i having difficulties connect remote db2 database using pdo_ibm, followed instructions on ibm configure pdo_ibm library , linux client since php not configured manually installed through apt-get not sure if current error might due missconfiguration or else.

my stage is: linux debian wheezy ibm db2 client 10.5 php 5.4.45 pdo_ibm 1.4

when try connect db2 following code:

<?php $usernamemaximo = '@user'; $passwordmaximo = '@password'; $connectionstringmaximo = 'ibm:driver={ibm db2 odbc driver};database=@databasename;hostname=@xx.xxx.xxx.xx;port=50002;protocol=tcpip;'; try {   $connection = new pdo($connectionstringmaximo, $usernamemaximo, $passwordmaximo, array(     pdo::attr_errmode => pdo::errmode_exception)   );   echo "success"; } catch (exception $e) {     var_dump($e); }

i following error

object(pdoexception)[2]   protected 'message' => string 'sqlstate=     , sqldriverconnect: -5005 [ibm][cli driver] sql10007n message "0" not retrieved.  reason code: "3". ' (length=123)   private 'string' (exception) => string '' (length=0)   protected 'code' => int 0   protected 'file' => string '/apps/html/tests/pdo_db2.php' (length=28)   protected 'line' => int 8   private 'trace' (exception) =>      array (size=1)       0 =>          array (size=6)           'file' => string '/apps/html/tests/pdo_db2.php' (length=28)           'line' => int 8           'function' => string '__construct' (length=11)           'class' => string 'pdo' (length=3)           'type' => string '->' (length=2)           'args' =>              array (size=4)               ...   private 'previous' (exception) => null   public 'errorinfo' => null

network/firewall check can connect through squirrel client, has faced same problem?

have tried alternative way provided here

the following example shows pdo_ibm dsn connecting db2 database cataloged db2_maximo in db2cli.ini:

$db = new pdo("ibm:dsn=db2_maximo", "", "");  [db2_maximo] database=sample protocol=tcpip port=50002 hostname=my-db2-machine uid=my-os-user pwd=my-os-password

Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more