Re: Multiple Recordsets

In article <006f01bfdc69$3c75e7a0$0264640a@redtrainint.com>, bsouther@greavesinc.com ("Ben Souther") wrote: > 1. The MS SQL functions: When I downloaded PHP the DLL for MS SQL = > wasn't included. I've been through the Zend site several time and can't = > seem to find a place to download it from. If anyone has this DLL or = > knows where it can be downloaded, I would appreciate some help. Maybe it's one of the ones on http://download.swwwing.com/php4/modules/ > 2. The ODBC functions in PHP: These functions are great except that I = > haven't found a way to retrieve multiple recordsets using them. An = > odbc_next_recordset() function would have solved all of my problems. If = > anyone has found a way to retrieve multiple recordsets with these = > functions, I would appreciate some help Look through the docs for whichever ODBC client[s] you're using? > 3. ADO: I can instantiate the object just fine. I can also view its = > properties. For some reason, the "open" function won't work. > > Here is the code I've been using: > > $Conn =3D new com("ADODB.Connection") or die('Can't instantiate ADO'); > = > // This is successful. > print "ADO Version: ".$Conn-> version.; // This also works. > $Conn->Open("myDSN") or die('Can't open the DSN'); This line > fails. Is it remotely possible that Open is case sensitive?... Is there anything in $php_errormsg? Any other way to get a COM error message out of PHP? (Check the manual) -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)