How to connect VB6 to a FoxPro database

[mariusseven]

I have this problem of connecting to a fox pro database. The system i am developing was a new one but the client wants to get data from the old database. Right now i am using VB6 as my front end and Ms SQL as m back end database.

[debasisdas]

You want to use both Foxpro and Sql Server for backend?

[QVeen72]

Hi,

Try this Connection String:

Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=c:\MyFol der;Extended Properties=dBAS E IV;

Regards
Veena

[mariusseven]

That's the idea. Because i want to fetch data from the old db (which is the foxpro)

You want to use both Foxpro and Sql Server for backend?

[mariusseven]

I'll try that this one, but i am using a connection that is not System DSN type. Its a sort of I.P. based.

Hi,

Try this Connection String:

Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=c:\MyFol der;Extended Properties=dBAS E IV;

Regards
Veena