Foxpro and crystal 9 - data location at runtime

I have upgraded to crystal 9, and am having problems with my vb code which
sets the database location. This code worked fine with crystal 8.

My reports use an ODBC connection to the foxpro data (free tables). In
crystal 8 I used this syntax :
crpDatabaseTable.SetLogOnInfo "Visual Foxpro Tables", "DBQ=" &
strNewLocation

Under Crystal 9 this doesnt seem to work and I get unable to logon errors.

I have also tried using the ole db provider for visual foxpro, and this
allows me to set the location in code without problems, however whenever
there is a date range clause in the record selection I get an error message
saying "Column 'DATETIME' is not found. On viewing the sql clause in the
crystal report, it has included this as part of the where clause, eg :
`TRANS`.`trandate`>=CONVERT(DATETIME, '01-01-2003', 110)

I have moved away from using direct connection to foxpro data due to
performance issues with the direct driver (odbc is much faster and uses
indexes better), so I dont want to go backwards if I can help it.

Has anyone been able to get odbc or oledb connections working with foxpro
tables, AND been able to set the data location at runtime successfully ?

HELLPPPP!!! PLEASE !!!

thanks:)


.