By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Cannot link table from SQL Server 2000

P: n/a
Something strange has happened on my computer. I am unable to link tables
from SQL Server 2000. I have tried from Access 97 and 2000, but keep
getting the error "The Microsoft Jet database engine could not find the
object 'tablename'..."

I have SQL Server 7 and SQL Server 2000 installed as an instance on the same
computer. Linking has always worked fine previously, but something has
obviously changes in the meantime. I tried to cleanup the registry, played
around w/ network config. and client config, checked port numbers, etc. I
am able to link to SQL 7, just not SQL 2000 anymore, not even the Northwind
db. The ODBC DSN connects and tests fine. And I can perform these tasks on
any other computer in our office, just mine is hosed. I can connect from my
machine to another SQL Server 2000 machine, but cannot connect from another
computer to my SQL Server 2000 (which leads me to believe there is
definitely something screwy w/ my SQL 2000 instance/connectivity).

Any help will be greatly appreciated (before I have to breakdown and call
Microsoft).

Thank you,
Tom

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Problem solved. Using Microsoft KB Article 290991 - HOW TO Manually remove
SQL Server 2000 default, named, or virtual instance, I cleaned both SQL 7
and 2000 from my machine, then reinstalled both. Everything works as it
should again. A little bloody, but at least everyone's happily working
together again.

"tskelley" <ts******@1nospam1otps.com> wrote in message
news:Cr********************@comcast.com...
Something strange has happened on my computer. I am unable to link tables
from SQL Server 2000. I have tried from Access 97 and 2000, but keep
getting the error "The Microsoft Jet database engine could not find the
object 'tablename'..."

I have SQL Server 7 and SQL Server 2000 installed as an instance on the same computer. Linking has always worked fine previously, but something has
obviously changes in the meantime. I tried to cleanup the registry, played around w/ network config. and client config, checked port numbers, etc. I
am able to link to SQL 7, just not SQL 2000 anymore, not even the Northwind db. The ODBC DSN connects and tests fine. And I can perform these tasks on any other computer in our office, just mine is hosed. I can connect from my machine to another SQL Server 2000 machine, but cannot connect from another computer to my SQL Server 2000 (which leads me to believe there is
definitely something screwy w/ my SQL 2000 instance/connectivity).

Any help will be greatly appreciated (before I have to breakdown and call
Microsoft).

Thank you,
Tom

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.