ODBC [Visual FoxPro Driver] Syntax error?

[bengalliboy]

Hi,
I am trying to access a foxpro table using ADODB and am getting this error: ODBC Synttax error or Access Violation.

I do have an ODBC driver for this table, and noone else is opening this table. There should not be any access violation but...?
Can any one figure it out what am I doing wrong? TIA. Here is the code...

Set cnDb = New ADODB.Recordset
connStr = "Driver=Microsoft Visual Foxpro Driver; " + _
"UID=;SourceType=DBF; SourceDB = " & "c:\mytest\datafile.dbf"
cnDb.Open connStr

 

[JoaoTL]

Hi, try this links.

Get the latest Visual FoxPro ODBC driver at

http://www.microsoft.com/data/

http://support.microsoft.com/support/kb/articles/Q165/4/92.ASP

http://support.microsoft.com/support/kb/articles/q172/5/92.asp?FR=0

Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[Guest_imported]

Thanks, pointing to the file path did help. I can open the connection without any trouble... I am facing another problem now, When I try to open a new recordset using my existing connection, I am getting error... wondering, for .source should I use the file name again or just path. Just path does not work... am I missing some thing?

connStr = "Driver=Microsoft Visual Foxpro Driver; " + _
"UID=;SourceType=DBF; SourceDB = " + path_fox
cnDb.Open connStr
cnDb.CommandTimeout = 0
Set rsDb = New ADODB.Recordset
With rsDb
.Source = path_fox
.ActiveConnection = cnDb
.Open