I had this same issue, and what fixed it for me was removing the "USE
<database_name>" clause at the top of the query.
I.E., my query looked like this:
USE Northwind
SELECT * FROM MyTable
If I just export from the correct database, I can do away with the USE
Northwind statement and simply have my query looking as-such:
SELECT * FROM MyTable
Then it worked for me.
Hope this helps in time!
Thanks,
Spen
Rinu Varghese <anonymous (AT) devdex (DOT) com> wrote
Quote:
Hello!
I need help with one of my SQL 7 severs. I'm trying to export data
based on a query to a text or excel file. When I execute it, I'm
getting an invalid pointer message.
Any input is greatly appreciated.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! |