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]