:hi: Hi! does anybody here has an idea how to connect my program faster using ADO in a DBF database file format... below is my code but still the connection is very slow when i open multiple dbf files... tnx 4 your help

or can you share to me your sample programs using ADO in connecting DBF database files

With con
.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = D:\MyDB;Extended Properties=dBASE IV;"
.Open
End With

note:

dbf files has 300, 000 records...

I'm opening 5 dbf files at once..

tnx mga bro in advance :thanks:

:hi: Hi! does anybody here has an idea how to connect my program faster using ADO in a DBF database file format... below is my code but still the connection is very slow when i open multiple dbf files... tnx 4 your help

or can you share to me your sample programs using ADO in connecting DBF database files

With con
.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = D:\MyDB;Extended Properties=dBASE IV;"
.Open
End With

note:

dbf files has 300, 000 records...

I'm opening 5 dbf files at once..

tnx mga bro in advance :thanks:

DBF? anu yun? JOKE :peace:

Basically, mabagal talaga yan.. thats a Thing of the Past... Why don't you explore the capacities of the MySQL... Mas ok itong gamitin mas Stable at mas mabilis... Still, it depends how you structure your DB..:)

:hi: Hi! does anybody here has an idea how to connect my program faster using ADO in a DBF database file format... below is my code but still the connection is very slow when i open multiple dbf files... tnx 4 your help

or can you share to me your sample programs using ADO in connecting DBF database files

With con
.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = D:\MyDB;Extended Properties=dBASE IV;"
.Open
End With

note:

dbf files has 300, 000 records...

I'm opening 5 dbf files at once..

tnx mga bro in advance :thanks:

Bro, mabagal talaga interconnectivity ng VB saka DBF files, bakit nde mo nalang sa VFP gawin mas mpapadali trabaho mo

DBF? anu yun? JOKE :peace:

Basically, mabagal talaga yan.. thats a Thing of the Past... Why don't you explore the capacities of the MySQL... Mas ok itong gamitin mas Stable at mas mabilis... Still, it depends how you structure your DB..:)

:thanks: bro

ganito kasi yun eh...
existing na kasi ang database ko na dbf (may 300,000 records na sa company namin), all i want to do is to make a query program using visual basic...
is there any possible way to make my program faster?
pls :help:

tanx a lot...

Bro, mabagal talaga interconnectivity ng VB saka DBF files, bakit nde mo nalang sa VFP gawin mas mpapadali trabaho mo

Salamat bro...
di pa kasi marunong gumamit nang fox pro eh...
all i wanna do right now is just to make a program in VB6 and using DBF files format... nakagawa na akong ng program kaso mabagal ang respond niya... any advice :help:

:thanks: bro

ganito kasi yun eh...
existing na kasi ang database ko na dbf (may 300,000 records na sa company namin), all i want to do is to make a query program using visual basic...
is there any possible way to make my program faster?
pls :help:

tanx a lot...

Ganun talaga yan bro, lalo na sa situation nyo... 300,000 records na pala.. Better bro, Migrate it to mySQL.. Total Libre naman ito... Pangit kasi ang Indexing ng DBF, kaya mabagal... Kasi parang isang malaking Text File lang sya... Tapos may mga bugs yung kanyang Binary search kaya hindi sya ok kung pang maramihang records..:)

Ganun talaga yan bro, lalo na sa situation nyo... 300,000 records na pala.. Better bro, Migrate it to mySQL.. Total Libre naman ito... Pangit kasi ang Indexing ng DBF, kaya mabagal... Kasi parang isang malaking Text File lang sya... Tapos may mga bugs yung kanyang Binary search kaya hindi sya ok kung pang maramihang records..:)

correct ka bro, may mga bugs ang binary search nya.... Pano ko mag migrate? meron bang software na mag convert from dbf to MySQL database? dami na kasing records ang dbf namin eh.. :thanks:

Based on my experience mabagal tlaga yang ganyang setup.

Regarding on sa bilis ng search the best ang foxpro (this was proven) when it comes to search kung ggmitin mo native codes nya. Pero kung ggmit ka ng SQL query mabagal talaga to.

May i suggest use this instead:

With con
.ConnectionString = "Provider = VFPOLEDB;Data Source = D:\MyDB;Extended Properties='';User ID='';Password='';Mask Password=false;Cache Authentication=false;"
.Open
End With

ang Microsoft.Jet.OLEDB.4.0 kasi is for MS ACCESS(MDB).

No idea sa migration ng MySQL pero sa SQL Server 2005 may wizard na sya for migrating from DBF files.

correct ka bro, may mga bugs ang binary search nya.... Pano ko mag migrate? meron bang software na mag convert from dbf to MySQL database? dami na kasing records ang dbf namin eh.. :thanks:

Bro, try mo munang convert it to CSV then from CSV Convert mo sya sa MySQL...:D

Based on my experience mabagal tlaga yang ganyang setup.

Regarding on sa bilis ng search the best ang foxpro (this was proven) when it comes to search kung ggmitin mo native codes nya. Pero kung ggmit ka ng SQL query mabagal talaga to.

May i suggest use this instead:

With con
.ConnectionString = "Provider = VFPOLEDB;Data Source = D:\MyDB;Extended Properties='';User ID='';Password='';Mask Password=false;Cache Authentication=false;"
.Open
End With

ang Microsoft.Jet.OLEDB.4.0 kasi is for MS ACCESS(MDB).

No idea sa migration ng MySQL pero sa SQL Server 2005 may wizard na sya for migrating from DBF files.

thanks bro.. i'll try this one..

Bro, try mo munang convert it to CSV then from CSV Convert mo sya sa MySQL...:D

thanks bro... wala kasi akong converter eh..
yung demo version ng converter is limited lang ang ma convert na records :D

thanks bro... wala kasi akong converter eh..
yung demo version ng converter is limited lang ang ma convert na records :D

Kung macoconvert mo ito sa CSV, then use the attached file to convert it to mySQL

Kung macoconvert mo ito sa CSV, then use the attached file to convert it to mySQL

demo version pa rin ang converter na to... still has limitations...
at wala pa rin akong converter sa dbf to csv... anyways thanks for the post... :D

Based on my experience mabagal tlaga yang ganyang setup.

Regarding on sa bilis ng search the best ang foxpro (this was proven) when it comes to search kung ggmitin mo native codes nya. Pero kung ggmit ka ng SQL query mabagal talaga to.

May i suggest use this instead:

With con
.ConnectionString = "Provider = VFPOLEDB;Data Source = D:\MyDB;Extended Properties='';User ID='';Password='';Mask Password=false;Cache Authentication=false;"
.Open
End With

ang Microsoft.Jet.OLEDB.4.0 kasi is for MS ACCESS(MDB).

No idea sa migration ng MySQL pero sa SQL Server 2005 may wizard na sya for migrating from DBF files.


na try ko na to pero may error na lumabas
PROVIDER NOT FOUND OR PROVIDER NOT PROPERLY INSTALLED

baka hindi supported ang VFPOLEDB sa VB 6.
:thanks: for your help

Based on my experience mabagal tlaga yang ganyang setup.

Regarding on sa bilis ng search the best ang foxpro (this was proven) when it comes to search kung ggmitin mo native codes nya. Pero kung ggmit ka ng SQL query mabagal talaga to.

May i suggest use this instead:

With con
.ConnectionString = "Provider = VFPOLEDB;Data Source = D:\MyDB;Extended Properties='';User ID='';Password='';Mask Password=false;Cache Authentication=false;"
.Open
End With

ang Microsoft.Jet.OLEDB.4.0 kasi is for MS ACCESS(MDB).

No idea sa migration ng MySQL pero sa SQL Server 2005 may wizard na sya for migrating from DBF files.


:thanks: LETHALJAM okey na poh cya... kelangan ko lang pala ng VFPOLEDB provider.... :thanks: solved na po cya :D

:thanks: din kay hmx_ryan :thumbsup: