Interbase Connect

[samharwin]

I am having some difficulty connecting to an interbase db residing remotely. The db is running on a windows 2k professional box. The ip of the box is 192.168.1.6 and the db file resides in: c:\PCFWEB_DB\PCFWEB_DB.gdg

Here's the code I'm using:

$dbh = ibase_pconnect('192.168.1.6:c:\PCFWEB_DB\PCFWEB_DB.gdb', 'username_here', 'password_here', '', '100', '1');
$stmt = 'SELECT * FROM TESTTABLE';
$sth = ibase_query($dbh, $stmt);


    while ($row = ibase_fetch_object($sth))
    {
              echo $row->TITLE, "\n";
     }
ibase_free_result($sth);
ibase_close($dbh);

Not sure if anyone can help, but thanks in advance anyway.

[rsilvs]

Hi,

You may try this one...

I tried this and it works fine for me...

I think you dont have to include the '100' and 1 in your ibase_pconnect()...

here it goes....

ibase_pconnect("192.168.1.6:c:\PCFWEB_DB\PCFWEB_DB.gdb", "username_here", "password_here");

    if (ibase_errmsg())
    {
        echo "error: " . ibase_errmsg();
        $_POST["PASSW"] = "";
        exit;
    }

   $stmt = "SELECT * FROM TESTTABLE";
   $sth = ibase_query($stmt);


  while ($row = ibase_fetch_object($sth))
 {
  echo "$row->TITLE \n";
  }
  ibase_free_result($sth);
  ibase_commit();


  regards, 

  >>>nald<<<