November 6, 2003 at 10:21 am
I'm having trouble getting sp_tables to return results via an ODBC connection to SQL 2000. The problem originally reared it's head while using Seagate Info to modify reports. The list of tables and views was not being returned from the database. If I modify the connection method to bypass ODBC and connect directly to SQL Server using the same credentials, it works perfectly.
This is a newly installed server that is not in production. The environment is as follows:
SQL2000 SP3
MDAC 2.8
NT-Only Security
Login with SA rights and permission to 'everything'.
ODBC DSN using credentials above.
The applications and tests I've performed have all been run locally on the server. SP_Tables executes and returns results properly within Query Analyzer. I'm able to connect to another SQL 2000 Server and run sp_tables without any trouble.
My conclusions:
Can anyone offer ideas on where I might look or what I might try to resolve this? If all else fails, I can start from scratch and re-install everything.
Thanks,
Kevin
Edited by - Kevin Post on 11/06/2003 10:22:34 AM
November 10, 2003 at 12:00 pm
This was removed by the editor as SPAM
November 10, 2003 at 6:00 pm
On the other server, same MDAC?
Andy
November 11, 2003 at 8:30 am
Yes... I'm starting over and rebuilding the server later this week. I'm convinced something was simply 'broken' in the server setup. I just wish I could determine what it is so I won't need to do it all over.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply