OleDb FoxPro Problems!

[ChrisWise]

Hi,

I was using the code below to pull up records from an access database which worked fine, but I now want to do the same to a foxpro 7 database.

It connects to the foxpro dbase but after stepping through the code I found it crashes at

"dgPrevious.DataSource = cmdSelect.ExecuteReader"

the error is "Object reference not set to an instance of an object."



Dim con As OleDb.OleDbConnection
Dim cmdSelect As OleDb.OleDbCommand


Call OpenConnection() ' Own procedure

sqlquery = "SELECT Datereq, NetLogin, Title, Status, RequestId FROM " & tbname

cmdSelect = New OleDb.OleDbCommand(sqlquery, con)


dgPrevious.DataSource = cmdSelect.ExecuteReader


dgPrevious.DataBind()


Thanks

Chris

[J Staniforth]

By experience I find that if there is a problem with db connection it fails after code for connection but when you apply it.
Can you post the code for Call OpenConnection() ?
I suspect there is a problem here (perhaps).