RE: [PHP-DB] connecting SQL 7.0
| From: | Andrew Hill | Date: | Tue, 02 Oct 2001 18:04:57 +0000 |
| Subject: | RE: [PHP-DB] connecting SQL 7.0 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12928@lists.php.net to get a copy of this message | ||
If you attempt to echo out a Resource Id it tells you it's name :)
This should still work in an exec.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: LeTortorec, Jean-Louis [mailto:JLeTortorec@healthcore.com]
> Sent: Tuesday, October 02, 2001 2:10 PM
> To: 'php-db@lists.php.net'
> Subject: [PHP-DB] connecting SQL 7.0
>
>
> $a=odbc_connect("mydsn","myid","mypwd") or die("Database is
> down");
> echo "$a";
>
>
> When I execute this script, I got $a being "Resource id #1".
> but $a should be an integer in order to do a query like
> $b=odbc_exec($a,"select * from mytable");
>
>
> the dsn I created is a system DSN, as suggested my a member of the mailing
> list.
> I run PHP4.0 and Apache 1.3 under W2000.
>
> Any suggestion?
>
> Thanks.
>
>