>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only