PHP/SQL Login problem
| From: | Jeremy Reed | Date: | Mon, 07 Jan 2002 17:05:16 +0000 |
| Subject: | PHP/SQL Login problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15504@lists.php.net to get a copy of this message | ||
I am having problems connecting and pulling data from a local SQL server. I
have set up a user and, as far as I can tell, all the settings for the user
are correct. However, when I try to pull data using the user, I get empty
result sets--almost as if I don't have SELECT permissions. When I log in
via Query Analyzer with the same login/pass, I am able to pull the data with
no problems. Also, when I use the same code but log into an offsite
database, the code works fine (except for the lag of pulling large amounts
of data--which is what I'm trying to avoid)
The only thing I can figure that might be affecting it is the ownership.
The owner of the DB is 'dbo'--because this is a straight copy of a database
on an offsite server.
Any help would be greatly appreciated.
Best regards,
Jeremy Reed