hi all,

i am trying to use ado.net to connect to a database, access 2k thru a dsn. ( the one that we make from the administration tasks in control panel)

now after researching and many threads in many sites including this one. i found this bad news

ADO . net doesn't support the ODBC layer, in other words i cannt use the class oledbconnection in connecting thru a dsn name.

so i decided to go around the problem.

i do know how to connect if i have the full path of the access database ( ex. : c:\docs\data.mdb) , thru thr microsoft.jet engine of course.


so the important question, if i have the dsn name, how could i extract the file path from it. so i can overpass it and open my connection depending on the pass it points to

help me out experienced people.

i need help


THX IN ADVANCE & BST RGDS