Recordset syntax for FoxPro while using ADODB..

[bengalliboy]

Hi,
I got the connection working but could not open the record set... I know I should not use the file name for source rather jus path for opening a new connection.. but how does the recordset work? Here is my code. Thanks.

'path_fox is the path of my data file
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
.ActiveConnection = cnDb
.Source = path_fox
'I get error when I try to open this :
.Open

 

[vbaprogammer]

Just a quick guess:

The connection string is very sensitive to spaces. Make sure they are omitted, such as in "SourceDB = ".

I've never seen connection coding using a "With" statement. Not that it wouldn't make sense, though. Try coding without it and let us know.

 

[bengalliboy]

Thanks to all. It is working for me now.
All I was missing an SQL statement. The connection string should be some thing like this:

With rsDb
.Source = "SELECT * FROM tableName"
.ActiveConnection = cnDb
.Open

Happy Holiday@