Error, please help

i want to use dbf as database n i already set the connection as below coding but it give me error

:confused: Set conn = New ADODB.Connection

conn.ConnectionTimeout = 10
conn.ConnectionString = "Provider=VFPOLEDB.1;Data
Source=C:\HelpDesk\Database\HelpdeskDb.dbc;"
conn.Open


Error message : Provider cannot be found. It may not be properly installed.
Is this becasue some referrence i didn't add in or component is missing???? please help.....

Foung -

On the website I sent you to for the connection string it mentions this:

The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it's OLE DB Provider.


I hadn't noticed that before - and I don't know if you can get the DLL any other way?! :(

Assuming you DO have it installed... you have an error in your connection string:


'it should be this....
conn.ConnectionString = "Provider=vfpoledb;Data Source=C:\HelpDesk\Database\HelpdeskDb.dbc;"

i didn't install VFP7 but i do have vfp6 so can it be work???



Foung -

On the website I sent you to for the connection string it mentions this:




I hadn't noticed that before - and I don't know if you can get the DLL any other way?! :(

Assuming you DO have it installed... you have an error in your connection string:


'it should be this....
conn.ConnectionString = "Provider=vfpoledb;Data Source=C:\HelpDesk\Database\HelpdeskDb.dbc;"