Re: db2_connect

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Rob is your script running on IBM i under Zend Server?  If it is then all you need is something like this:

	$conn = db2_connect ( "*LOCAL", "", "" );
	
	if (! $conn) {
	    
		print 'Connection failed. SQL Err:' . db2_conn_error () . '<br>' . db2_conn_errormsg ();
		return FALSE;  
	}
	
}
> On Nov 11, 2015, at 4:46 PM, Rob <rob.couch@xxxxxxxxxxxxxx> wrote:
>
> No clue what I am doing wrong....
>
> Here is my first test script .... https://sv1.americanfirstfinance.com:8158/kwik/aff_test/aff.php
>
> Not sure what I am doing wrong when trying to connect to DB2.... I have tried many things...
>
> How does one validate which db driver is installed.  I am hoping IBM_DB2 is installed.  Just do not know how to check.  Does it require ssh?  Does the Green Screen give you the same functionality as ssh?
>
> <?php
>  $db2Conn = db2_connect( 'MyDB2DB', 'Usr', 'Pwd', DB2_I5_NAMING_OFF );
>  //$db2Conn = db2_connect( 'MyDB2DB', 'Usr', 'Pwd', DB2_I5_NAMING_OFF );
>  //$db2Conn = db2_connect( '', 'Usr', 'Pwd', DB2_I5_NAMING_OFF );
>  //$db2Conn = db2_connect( '', '', '', DB2_I5_NAMING_OFF );
>  //$db2Conn = db2_connect( 'DATABASE=MyDB2DB;HOSTNAME=localhost;PORT=8158;PROTOCOL=TCPIP;UID=Usr;PWD=Pwd;', null, null, DB2_I5_NAMING_OFF );
>  //$db2Conn = db2_connect( 'DATABASE=MyDB2DB;HOSTNAME=localhost;PORT=8158;PROTOCOL=TCPIP;UID=Usr;PWD=Pwd, '', '', DB2_I5_NAMING_OFF );
>
>  if ( false === $db2Conn )
>  {
>    echo 'Failed To Connect. '.db2_conn_errormsg() ;
>  }
>  else
>  {
>    echo 'Connection Completed!' ;
>    db2_close( $db2Conn ) ;
>  }
> ?>
>
>
> It is not working......
>
> Am I just that brain dead?
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> -- 
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com