Connection String for ASP pages to DBF file

[seank]

Hello,

I recently upgraded to 5.5 from 4.14 and host it on a windows box. For some reason the old connection string will not work with 5.5. When I attempt to connect it I get a "test connection failed because of an error in initializing provider. unrecognized database format" error message. I am using ASP pages to display various pages such as the product detail page and I need a connection string to work so I can bring the data back to the page.

The two connection strings are:

OLD 4.14
Application("DB_MIVA_Walkerswarehouse") = "Provider=MSDataShape; Provider=Microsoft.Jet.OLEDB.4.0; Data Source=X:/www.mysite.com/wwwroot/mivadata/Merchant2/00000002; Extended Properties=DBASE IV;"

NEW 5.5 string - won't work
Application("DB_MIVA5_Walkerswarehouse") = "Provider=MSDataShape; Provider=Microsoft.Jet.OLEDB.4.0; Data Source=X:/www.mysite.com/wwwroot/mivadata/Merchant5/s02; Extended Properties=DBASE IV;"

Thanks,

Sean

[eMediaSales]

Hi Sean,

For clean data sharing particularly with v5.5, you're best off using MySQL. DBF connectors won't be able to take advantage of the database indexes since they're proprietary. MySQL is much more flexible too.

best,
James

[seank]

Hello James,

I would like to continue to use the DBF files since my existing website was written to take advantage of those files in the 4.14 Miva Merchant system. If I move to MySQL now, then I will need to rewrite the entire website which is not something I am looking to do.

[seank]

Application("DB_MIVA5_Mysite") = "Provider=VFPOLEDB.1; Data Source=X:/www.mysite.com/wwwroot/mivadata/Merchant5/s02; Extended Properties=DBASE IV;"

works just fine!