Link to Dbase IV with SQL Server 2012

[LonnieJohnson]

Can this be done? I know dbase IV is old. Can you create a linked server to this file format? I need to run a script to update some data that I run on some of our sql server tables on a dBase IV table.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[drlex]

Have you tried following the steps enumerated in the MS TechNet document on this topic?

http://technet.microsoft.com/en-us/library/aa337084.aspx

soi là, soi carré

 

[LonnieJohnson]

Hello drlex,

Thanks for the quick response. Yes I did actually. Found it in a Google search. I did not see the jet provider. Figured I needed to install something which may be more work than what I need all this for. Thanks. I was hoping for a more simple solution through Enterprise Manager.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[SQLScholar]

This link may help you

[URL unfurl="true"]http://www.dbforums.com/microsoft-sql-server/1214500-linked-server-sql-dbase-db4.html[/url]

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[LonnieJohnson]

Thanks SQLScholar,

I will try that as soon as possible. I am in the Midwest and the snow storm has knocked out my computer at work and I have lost my remote connection.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

Thanks SQLScholar,

I went to that link and it did not help. Looks like they could not get it to work after reading through the posts. I tried it too and was a no go for me either. I appreciate the tip though. I will keep looking.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[fredericofonseca]

look at this one.

http://7explications.wordpress.com/category/sql-server/linked-server/

and make sure that on your server you do have the correct drivers installed - 64bit version may be required

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886