Re: Invalid InterBase link resource

Yes it is correct. I copied and past it from InterBase documentation. Any SQL statement raises the same exception! Delbono wrote: > Is INTEGER correct? > > Isn't it INT NOT NULL? > > My experience is MySql, notInterbase, but whenever I encounter that warning > (1st one), it's always a worng SQL syntax. > > Regards. > Nicola > > ----- Original Message ----- > From: "Sergey Nikiforov" <sergey@pcsrevenuecontrol.com> > To: <php-windows@lists.php.net> > Sent: Wednesday, September 13, 2000 6:22 PM > Subject: [PHP-WIN] Invalid InterBase link resource > > > Code: > > <?php > > $host = "192.168.0.15:php.gdb"; > > $username = "sergey"; > > $password = "nik"; > > $dbh = ibase_connect ($host, $username , $password); > > $stmt = 'CREATE TABLE T1 (P1 INTEGER NOT NULL PRIMARY KEY)'; > > $sth = ibase_query ($dbh, $stmt); > > ibase_close ($dbh); > > ?> > > > > execute: > > Warning: 0 is not a valid InterBase link resource in > > C:\Inetpub\wwwroot\interBase.php on line 7 > > > > Warning: InterBase: invalid database handle (no active connection) in > > C:\Inetpub\wwwroot\interBase.php on line 7 > > ---------------- > > Please tell me what is the reason? > > Sergey Nikiforov. > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net