can't querry the linked server help plsgreenspun.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
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