can't querry the linked server help pls

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I want to querry a Dbase database on my SQL server so I make a odbc DSN to link the Dbase file and than add a linked server in SQL7 use the ODBC datasource call DY and than I can see all the table at SQL7 but when I use "select * from DY...clients" it cause a server:msg 7313, level 16, state 1, line 1 ,invalid schema or catalog specified for provider 'msdasql' any one can help me pls !!

-- Anonymous, March 27, 2001

Answers

HKWKH,

Try fully qualifying it. SQL Server cannot resolve it without the database name.

Hope this helps,

Eric

-- Anonymous, March 28, 2001


how to fully qualifying ? can give me sample pls ?

-- Anonymous, March 28, 2001

HKWKH,

To "fully qualify" means to use all 4 parts of the 4 part naming convention. For example, myServer.myDB.dbo.myTable.

Hope this helps,

Eric

-- Anonymous, March 29, 2001


myServer.myDB.dbo.myTable this is link a SQL server but if Dbase thought ODBC what is the four part ? I know that is "linked server.paht.???.table" dbo is use at SQL if use in Dbase thought ODBC what is the ??? part ?

-- Anonymous, March 29, 2001

Refer to article Q270119 in support.microsoft.com

-- Anonymous, April 20, 2001


Moderation questions? read the FAQ