Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hi Bob
>>
>>I am trying to make a remote view on the SQL Server.
>>
>>Can I make such a view against a FoxPro table?
>>
>>
>>Kenneth
>
>So, you are trying to make an SQL Server View (not called a remote view which is confusing me.)
>
>If that is what you are trying to do, yes, you can create a linked server to the FoxPro table, then create a view that looks at the linked vfp table.
>
>BOb
Can the vfp table be on a different box?
The problem I have, I can't get ado to work if my web server and vfp tables are on different boxes. I could have SQL Server and vfp tables on the same box and link my web server to the SQL Server. This is the long way round but all the data is still in vfp tables and my vfp app updates vfp tables.
Thanks Anthony
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement