computergiants
asked on
Connection String for Classic ASP and Miva Merchant 5.5 DBF files
Recently upgraded our Miva Merchant to 5.5 from 4.14. We run the product detail page using classic ASP but I am unable to successfully connect to the Miva 5.5 DBF files using the old connection string. When I go to the hosting server and test the connection string using a UDL file, I receive a "Test connection failed because of an error in initializing provider. Unrecognised database format " error message.
The old and new connection strings are below:
Thanks!
The old and new connection strings are below:
Thanks!
OLD 4.14 site connection string in ASP
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 - 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;"
Last Comment
ASKER
The path was correct for the new 5.5 data source. It appears that is the only thing you changed from the old to the new connection string is the path.
Maybe I need a new ODBC driver?
Maybe I need a new ODBC driver?
Try replacing the / with \
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
PHP
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
125K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window