Cannot find installable ISAM, You cannot enumerate Table Names in ODBC directmode...

[gaddu]

I m trying to connect VB and oracle using DAO. I set the properties of DAO as follows :

Connect:ODBC;DATABASE=oracle;UID=xxx;PWD=xxx;DSN=oracle;"
DatabaseName: Oracle
Default Type: 2-UseJet
When I click on Recordsource I get the error:
Cannot find Installable ISAM

When I change the Default Type to 1-UseODBC and then click on record source I get the error msg:
You cannot enumerate Table Names in ODBC directmode(Default type set to ODBC Directmode)


Have any idea????

[antares686]

Take a look here and see if the info applies or helps.

FAQ - "Uninstallable ISAM" (http://www.negia.net/~vbbook/faq/isam.htm)