Versions des environnements
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
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