Viewing 3 posts - 1 through 4 (of 4 total)
Thanks for some ideas. I've downloaded the doc and will read up on this.
I'll dig and see if I can obtain the Sybase OLEDB provider....I'm not sure how much of...
March 2, 2006 at 5:19 pm
Identical.
The queries can be a simple as:
SELECT * FROM FOO WHERE TimeStamp > '3/2/2006'
Run this in SQL ---> 10 minutes later get the data.
Run this in Access [using...
March 2, 2006 at 5:15 pm
Thanks for the reply!
Tried both OpenQuery and OpenRowSet in SQL 200x and the net result is the same - the queries run slowly in SQL but run quickly in Crystal...
March 2, 2006 at 1:33 pm
Viewing 3 posts - 1 through 4 (of 4 total)