Linked server problems... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Linked server problems...

Author

Topic

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2002-05-12 : 15:56:37

I linked an ODBC database and I can see all the tables in Enterprise Manager...

The problem is the catalog says: C:\WINDOWS\SYSTEM32

How can I select from the tables on this Linked Server??

A usual linked server select would be: Select * from Server1.DB1.DBO.TABLE1

I very well cant say: Select * from Server1.[c:\windows\system32]..table1

Or can I???

Any help is greatly thanked!!!!

Daniel
SQL Server DBA

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2002-05-12 : 17:28:27

Can't you create it with a different name?

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2002-05-12 : 17:41:22

quote:

Can't you create it with a different name?

With a different Catalog? I thought that the catalog was specific to the db??

Daniel
SQL Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources