Problem with linked server (dBASE)

• stevesaved

  SSC-Addicted

  Points: 468

  More actions

  August 5, 2003 at 3:36 am

  #83954

  I would like to use the linked server, but I'm having problems with it.

  Any help will be greatly appreciated:

  I created the linked server using:

  sp_addlinkedserver

  @server='PDMdBASE',

  @srvproduct='dBASE 4',

  @provider='MSDASQL',

  @datasrc='PDMdBASE'

  PDMdBASE is a System DSN (ODBC data source) which points to directory O:\ESPEC\PDM

  When I run: exec sp_catalogs PDMdBASE

  I get: O:\ESPEC\PDM

  When I run: SELECT * FROM PDMdBASE.[O:\ESPEC\PDM]..[ATAB]

  I get: Server: Msg 7314, Level 16, State 1, Line 1

  OLE DB provider 'PDMdBASE' does not contain table '`O:\ESPEC\PDM`\`ATAB`'. The table either does not exist or the current user does not have permissions on that table.

  I do not understand this error as ATAB.DBF exists in O:\ESPEC\PDM.

  Any clues?

  Thanks for your help.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 5, 2003 at 5:51 am

  #468609

  I'm not real big on DbaseIV linked servers, but I have used the following syntax to read the EMPLOYEE.DBF file out of the MS Office directory. You may be able to massage it for your purposes:

   
  
  SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
  
  'Data Source="D:\Program Files\Microsoft Office\Office\1033\";Extended Properties=DBASE IV')...[Employee]

  Cheers,

  - Mark

  
  Cheers,
  - Mark

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  September 19, 2003 at 9:33 pm

  #475142

  The syntax for linked Jet4 ISAM linked server is probably the issue, try:

  SELECT * FROM PDMdBASE...ATAB

  Basicly you have to use the 4 part table naming, and for Jet ISAM databases, only the Server and Table portions are supported.