Hi,
Remote views use ODBC. Since you are using sqlexec, you must have a DSN defined for your mssql server database. You can use the same DSN for remote views.
Create a new project, create a database within the project, then create a remote view of your sql server database using your DSN in the list of "available data sources".
You will need a key field for the view and check off "send updates".
Good luck.
Paul de Niverville
>Hi, I'm currently using the SQLEXEC to put the data into SQL and was wondering how exactly do you do a remote view on SQL tables? Does it has to do something with ODBC?
>
>Charles
>
>
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