Hi,

I tried a lot of things to connect a linked server to an ODBC for dBase IV
and I didn't get any successfull result. I have the path, the files names and
sysadmin access to my SQL server. I got a lot confused on all connection
string that news group use to connect to an ODBC for dBase. Does someone can
help me creating my Linked Server or tell me a link or doc that explain it
carefully?

Here is my last try:

EXEC master.dbo.sp_addlinkedserver @server = @LinkedServerName,
@srvproduct=N'Haha', @provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=N'eTimeDB', @provstr=N'Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=S:\DBFFiles;Extended Properties=dBase IV;User ID=Admin; Password=;'

but this doesn't work:

select * from
OPENQUERY( ETimeODBC04, 'SELECT * FROM EMP')

Thanks a lot in advance.

David

I'm using a SQL Server 2005 server

"David Parenteau" wrote:

> Hi,
>
> I tried a lot of things to connect a linked server to an ODBC for dBase IV
> and I didn't get any successfull result. I have the path, the files names and
> sysadmin access to my SQL server. I got a lot confused on all connection
> string that news group use to connect to an ODBC for dBase. Does someone can
> help me creating my Linked Server or tell me a link or doc that explain it
> carefully?
>
> Here is my last try:
>
> EXEC master.dbo.sp_addlinkedserver @server = @LinkedServerName,
> @srvproduct=N'Haha', @provider=N'Microsoft.Jet.OLEDB.4.0',
> @datasrc=N'eTimeDB', @provstr=N'Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=S:\DBFFiles;Extended Properties=dBase IV;User ID=Admin; Password=;'
>
> but this doesn't work:
>
> select * from
> OPENQUERY( ETimeODBC04, 'SELECT * FROM EMP')
>
> Thanks a lot in advance.
>
> David