How to operate dbase database, odbc, dao, ado under VC?

lubinwsw10

Hello everyone, I want to use VC to split (* .dbf) files into N dbf files according to a certain field. This involves database operations. I do n’t want to use odbc because it requires that a new data source be created in the odbc source . But with
ADO found that the connection string could not be found. Doesn't ADO consider the dbase database anymore? I also saw the best method on the Internet is to use DAO. I use it like this in VB. It is more convenient. I do n’t know how to use it under VC?

rsq666

May only use ODBC or DAO.

pretendersam

Using ODBC, the data source created during installation is to write the registry according to the location where the user installs:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

lubinwsw10

Thank you for your suggestions, but if you use ODBC, it will automatically complete the work of building a data source in the odbc data source of the control panel. There is a problem, the location of the data source may be different according to the user's situation.

javatyro

Use ODBC SDK API.
With SQLDriverConnect, there is no need to set up a data source.
Specify the connection string as "Driver={Microsoft dBASE Driver (*.dbf)};DBQ=x:\your path; DriverID=277;".

pretendersam

The location can be determined when installing the software, Install Shelled has this function.

lubinwsw10

I missed one place. The part of operating the database is finally written as a dll for other applications to use

lubinwsw10

How to operate dbase with dao, how to open dbase database

javatyro

MSDN: DAO is best used with databases that the Microsoft Jet database engine can read....Best performance is with Microsoft Jet (.MDB) databases.

ODBC is recommended to operate dbase.