SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting "Data source name not found and no default driver specified"

user9937293Sep 23 2009 — edited Sep 24 2009

Hi all,

I'm trying to create a connection in SQL Developer (1.5.0.53) to an Access MDB using the Access Tab on the "New / Select Database Connection" window. I navigate to my MDB and then click the Test button and this is what I get:
"Status : Failure - Test failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

I do have the 1.6 JVM.

Not a show stopper, but would like to see how SQL Developer works with Access tables, so any help would be appreciated.

TIA,

Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2009

Added on Sep 23 2009

#access, #sql-developer

1 comment

2,050 views