Invalid Descriptor Index

[Rigel]

Hi Everyone,

Why do I get an "invalid descriptor index" when I call this function?
What is an "invalid descriptor index"?

CSQLSet is subclass of CRecordset


CDatabase *db = new CDatabase();
db->Open( "ODBC;DSN=MS Access Database;DBQ=tysql.mdb", FALSE, FALSE );

CSQLSet set(db);
set.Open(AFX_DB_USE_DEFAULT_TYPE,_T("SELECT prod_name FROM Products"));

[Vanaj]

Try looking HERE (http://www.connectionstrings.com/)for connection strings