How to get the database driver from DSN

[ep2829]

I have a DSN. How do I know which driver (eg Access, SQL) it is using?

Thanks for any help

[nexus]

control pannel
odbc data sorce adminstrator

click the tab for the dsn your using(ie user,system,file)

youshould see the listed dsns and the driver there usnig

all dsn stuff is kept and administrated here!

[ep2829]

I mean is there any way to use VB Codes to do that?

[nexus]

IN THAT CASE DEBUG.PRINT THE ACTIVE CONECTION CONECTION STRING PROPERTY

THIS WILL DISPLAY THE COMPLEATE CONECTION STRING