April 4, 2008 at 12:48 pm
I used OPENROWSET to connect to non SQL Server database, the connection worked but the query only returned 2 rows, it supposed to have hundreds or rows. I read the microsoft OPENROWSET info, it said it might return 1 row, how do I make it to return all the rows.
The same thing happened when I created a linked server and I used OPENQUERY.
SELECT *
FROM OPENROWSET('MSDASQL', 'Dsn=app;Uid=loner;Pwd=loner', 'SELECT * FROM table')
Thanks
April 4, 2008 at 12:50 pm
What is the data source you are connecting to? There could be settings that need to be made on the source or on the connection based on the source.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 4, 2008 at 1:00 pm
It is a third party reporting tool called Webtrends.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply