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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-03 : 08:26:08
|
| MarK writes "I have a linked server to a DBF file. SQL Has no problem with this, so far so good. The following line works in the Query Analyzer fine:SELECT TOP 5 * FROM OPENQUERY(MGF_UK_DBF, 'SELECT * FROM XCFD_UK')When I put it into a view, I can execute it but it won't let me save it:ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The Requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interfaceYesterday I managed to save it in a stored procedure, with a slight change " instead of '. Today it won't pass the syntax check whatever I try.I have tried the 4 part thing:MGF_UK_DBF.c:\SBPostion.???.XCFD_UKBut it doesn't like the catalog (it is correct, I used the sp_catalog command. I must admit I haven't a clue what the Schema should be.Any help would be gratefulMark" |
|
|
|
|
|
Using a linked Server to Query a DBF File - Problems with Querying