pear db.php and non-dbo owned tables...
| From: | Newsom, Tim W - CIQ-2 | Date: | Thu, 21 Aug 2003 23:22:46 +0000 |
| Subject: | pear db.php and non-dbo owned tables... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-160366@lists.php.net to get a copy of this message | ||
I am having a problem with a script I wrote..
Behavior:
The script will login to a MSSQL server, correctly do sp_help, correctly query on tables owned by
DBO. However we have some tables owned by someone other then DBO.. call it A1. Any table specified
as A1.tablename will not return a result using the pear db.php. Using the MS tools or anyother MS
product that can access the database returns data from these tables... Any idea if php cares that
the data be owned by 'DBO' vs someone else?
Thanks,
-- Tim
<<Newsom, Tim W - CIDQ-2.vcf>>