Home > database >  SQL the openrowset (' Visual FoxPro Driver or VFPOLEDB. 1 call the DBF, no problem, local LAN s
SQL the openrowset (' Visual FoxPro Driver or VFPOLEDB. 1 call the DBF, no problem, local LAN s

Time:09-29

- everyone a great god, please grant instruction. Thank you:
- everyone a great god, please grant instruction. Thank you:
- everyone a great god, please grant instruction. Thank you:
 
-=====SQL calls inside DBF, call the local DBF, calling on the LAN server DBF is not!!!!!! Please kindly great god teach, thank you, a great god taught, thank,,
Select * from openrowset (' MSDASQL ', 'Driver=Microsoft Visual FoxPro Driver; SourceDB=F: \ temp \ r \ okk; SourceType=DBF ', 'select * from ob_lsk1. DBF')
Normal
-Select * from openrowset (' MSDASQL ', 'Driver=Microsoft Visual FoxPro Driver; SourceDB=\ \ 192.168.18.168 $\ \ ylidate YLJ \ Data; SourceType=DBF ', 'select * from ob_lsk1. DBF') as bb
- returns the message "[Microsoft] [ODBC Visual FoxPro Driver] File 'ob_lsk1. DBF' does not exist.",

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Select * from openrowset (' VFPOLEDB. 1 ', 'F: \ temp \ r \ okk'; The 'admin'; 'gm123123 +', 'select * from ob_lsk1. DBF')
Normal
-Select * from openrowset (' VFPOLEDB. 1 ', '\ \ 192.168.18.169 \ temdata \ 20200810 \ Data \'; The 'admin'; 'gm123123 +', 'select * from ob_lsk1. DBF')
- OLE DB access interface "VFPOLEDB. 1" returned message "Invalid path or file name.",
- unable to initialize the link server "(null)" OLE DB access interface "VFPOLEDB. 1" data source object,

  •  Tags:  
  • VFP
  • Related