SQL 7 DTS export to VFP- any help appreciated 
Author Message
 SQL 7 DTS export to VFP- any help appreciated

Does anyone here know of a way to successfully export a SQL Server 7 table
with  into FoxPro?  I've spent too long trying to get this to work.

Now I find out you can't DTS to Visual FoxPro if you tag any of the SQL
fields as being a Memo; according to Microsoft's site, it's not possible to
DTS "BLOB" fields to VFP since Fox doesn't support dynamic cursors.  Yet for
some reason I am able to do the same DTS to a dBase5 table!  Doesn't make
sense why VFP would be so restricting in this regard, if dBase can handle
things, but what do I know.

Would anyone know if it's possible to DTS (including memo fields) to a
FoxPro 2.6 table?  I could live with that.  Or, if there's a trick or two to
get DTS to export to VFP with memo fields, I'd love to hear it.  Thanks.



Mon, 01 Jul 2002 03:00:00 GMT
 SQL 7 DTS export to VFP- any help appreciated

Larry -
Have you tried from the other direction ??? VFP database container into your
SQL 7 database ?
This is referenced in the Purple Enterprise Edition Book - sorry, can't
remember the author - but basically you create a VFP database, then set up a
sql_connection back to the SQL database, and then create a remote view from
the SQL 7 database.table into your VFP database.[remote view] .   Once you
fire the remote view - you then have the contents of the table.

I think this might work for you - let me know what happens or if you get
stuck.
mondo regards [Bill]

--
========================================
William Sanders, Programmer/Analyst[VFP/SQL]
TALON Development Team, MIS Department [281-618-3100 X 3516]
EAGLE Global Logistics, 15350 Vickery Drive, Houston TX 77032

Quote:

>Does anyone here know of a way to successfully export a SQL Server 7 table
>with  into FoxPro?  I've spent too long trying to get this to work.

>Now I find out you can't DTS to Visual FoxPro if you tag any of the SQL
>fields as being a Memo; according to Microsoft's site, it's not possible to
>DTS "BLOB" fields to VFP since Fox doesn't support dynamic cursors.  Yet
for
>some reason I am able to do the same DTS to a dBase5 table!  Doesn't make
>sense why VFP would be so restricting in this regard, if dBase can handle
>things, but what do I know.

>Would anyone know if it's possible to DTS (including memo fields) to a
>FoxPro 2.6 table?  I could live with that.  Or, if there's a trick or two
to
>get DTS to export to VFP with memo fields, I'd love to hear it.  Thanks.



Mon, 01 Jul 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DTS Export to VFP - error

2. Good Reporting Tool for VB to SQL (Currently Use Crystal) or Crystal w/SQL Help Appreciated

3. DTS Export: How to have nulls export as blanks on fixed width export

4. HELP sql server 7 DTS Import, Export, repiclation

5. Ado Help Please Help any help is appreciated

6. EXPORT ERROR - ASSISTANCE APPRECIATED

7. EXPORT ERROR - ASSISTANCE APPRECIATED

8. Counting occurances of a datatypes in a database - HELP on SQL for this appreciated

9. Sql 6.5 Disaster Recovery - Any help appreciated

10. SQL 6.5 Transaction Log Problem - Help would be appreciated

11. SQL*Net listener problem - Help appreciated

12. VFP application export problem - second call for help


 
Powered by phpBB® Forum Software