Multiple ODBC Connections?

[rebies]

I was wondering if you can connect to the same database multiple times? I have been trying the following with no luck. And, yes permissions are set so I can write to the database.. My problem is I keep getting the error: "Warning: 2 is not a valid ODBC result resource in c:\inetpub\wwwroot\hdtvpub\getinfo\1.php on line 4"

---

1. $connectionstring = odbc_connect("customdigi", "", "");
2. $Query = "SELECT Hyperlink, EntryNumber, Site FROM TVlistings";
3. $queryexe = odbc_do($connectionstring, $Query);
4. while(odbc_fetch_row($queryexe)) {
5. $Hyperlink = odbc_result($queryexe, 1);
6. $EntryNumber = odbc_result($queryexe, 2);
   7.
7. // More code
8. $connectionstring2 = odbc_connect("customdigi", "", "");
9. $Query2 = "UPDATE TVlistings SET Price = $price WHERE Hyperlink LIKE '$Hyperlink'";
10. $queryexe2 = odbc_do($connectionstring2, $Query2);
11. odbc_close($connectionstring2);
12. }
13. odbc_close($connectionstring);