$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.