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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to