Opening ODBC with CDaoDatabase::open()
I created a System DSN called MyDB and I want to connect to it using
CDaoDatabase db;
db.Open("", FALSE, FALSE, "ODBC;DSN=MyDB);
I get the message: "You cannot use ODBC to import from, export to, or link am external Microsoft Jet or ISAM database table to your database."
I've searched a lot of forums and can't seem to find a correct way to make this work.
Thank you for any hint on this...
FN
Re: Opening ODBC with CDaoDatabase::open()
I have the same problem?
when I use CDatabase its OK but when I use CDaoDatabase I have the error message?
Thank you
Re: Opening ODBC with CDaoDatabase::open()
DAO is intended to work with Microsoft Access/Jet database only.
Re: Opening ODBC with CDaoDatabase::open()
I am sorry, Igor, but it is NOT correct!
DAO works pretty good with some other DB, such as: - Microsoft FoxPro®, versions 2.0, 2.5, and 2.6 ;
- dBASE III®, dBASE IV®, and dBASE 5.0®;
- Paradox™, versions 3.x, 4.x, and 5.x;
- ODBC data sources, including but not limited to Microsoft SQL Server, SYBASE® SQL Server, and ORACLE® Server;
- Microsoft Excel version 3.0, 4.0, 5.0, and 7.0 worksheets;
- Lotus® WKS, WK1, WK3, WK4 spreadsheets;
- Text files;
- ...
See DAO External: Working with External Data Sources
Re: Opening ODBC with CDaoDatabase::open()
Really? Sorry for my ignorance. :)