Create linked server?

[christer102]

How do I create a linked server to a DBASE database. I have the ODBCD connection set up. Does anyone have an example?

 

[manmaria]

Are you using SQL05? Did you try using the "Microsoft OLE DB Provider for ODBC Drivers"? I never created a linked server to DBASE, but you can give the Data source name as the User DSN name for DBASE.
HTH

 

[nomadicalloy]

All you need the DBASE driver when you create the link server.



My Programming Blog

http://www.xpherion.com/wp/?cat=2

 

[christer102]

The problem is that I have the problem with formatting. I can create the linked server, but then I am getting an ODBCD error when running the query. So I think the DBASE driver is incorrect. I also tried a DSN Name, but that's giving the same problem.


EXEC master.dbo.sp_addlinkedserver @server = 'TTBBd',
@srvproduct=N'Haha', @provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=N'TAM66', @provstr=N'Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\abc.DBF;Extended Properties=dBase IV;User ID=Admin; Password=;'

select * from
OPENQUERY( ttbb, 'SELECT * FROM abc')

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].


I have both SQL 2K and 05.