>We need to convert data from an SQL Anywhere database to VFP. Can someone give us advice on how to connect to the SQL Anywhere database and start the conversion process.
You can download from sybase ISQL.exe:
OUTPUT TO filename
... [ FORMAT output_format ]
... [ ESCAPE CHARACTER character ]
... [ DELIMITED BY string ]
... [ QUOTE string [ ALL ] ]
... [ COLUMN WIDTHS (integer,...) ]
alternatively you can access from odbc (get the full odbc client installed from their cd). Create a data source in odbc panel. then from vfp:
iConnect = sqlconnect()
sqlexec(iConnect,
"select * from this_bloody_server_table","a_good_old_vfp_cursor")
ASA is a very credible and unexpensive partner to vfp, not only for a one shot download. We have a significant vfp app running asa as a back-end
good luck
Précédent
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