Thank you for help.
i try to use OpenRowSet() but have a error message
1)
exec sp_addlinkedserver @server=N'CSTSERVER',
@srvproduct ='',
@provider = N'MSDASQL',
@datasrc=N'DBF'
2)
exec sp_addlinkedsrvlogin @rmtsrvname=N'CSTSERVER',
@useself = N'FALSE',
@locallogin = NULL,
@rmtuser = N'',
@rmtpassword =N''
first two work fine
3)
select * from [CSTSERVER].[Q:\FPDEV\COMMON\sqlappinspect]..[helpdb]
here i have an error
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
>>Hello All !
>>I have VFP 8.0/SQL Server SPT application.
>>I'm wondering is there any way to use BULK INSERT command for loading DBF file into a SQL Server table ? All examples I've seen were about loading text files and not the DBF.
>>TIA
>>Mariam
>
>Mariam,
>It's because dbf files do not need BULK INSERT command. See OpenRowSet() - or search here for samples.
>Cetin
Previous
Next
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