Opening ODBC with CDaoDatabase::open()

[fredn]

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

[khaldoun KASSEM]

I have the same problem?

when I use CDatabase its OK but when I use CDaoDatabase I have the error message?


Thank you

[Igor Vartanov]

DAO is intended to work with Microsoft Access/Jet database only.

[VictorN]

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

[Igor Vartanov]

Really? Sorry for my ignorance.