Create link to dBase?

Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.Using linked server is one of the ways, and I will probably go with that.
But am not sure where to get your BDE drivers...try Googling :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com> wrote
in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.|||I have googled for it but haven't found a way to get a copy yet.
I am open to any methods really. I really would prefer not to use BDE.
Thanks,
Marc.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OzhenZt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
> Using linked server is one of the ways, and I will probably go with that.
> But am not sure where to get your BDE drivers...try Googling :-)
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com>
wrote
> in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I was wondering what is the best way to link MS SQL server 2000 to dBase
IV.
> From what I can gather, we should create a linked server and use the MS
Jet
> 4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
> dBase files.
> Is this the correct way? If so, does anyone know where to get a working
> version of BDE?
> Thanks,
> Marc.
>
>