find what type of DataBase I'm connecting to

[Dibs]

Hi,

is there anyway of telling what type of database I'm connecting to? we've
upgraded a product to vb.net so its using ADODB and ODBC. The database is
going to be either Access, SQLServer or Oracle. The only thing I've come up
with so far is to check the registry for the driver but I can't be sure what
ODBC driver they'll use.
Any Clues?

Thanks

 

[Paul Clement]

¤ Hi,
¤
¤ is there anyway of telling what type of database I'm connecting to? we've
¤ upgraded a product to vb.net so its using ADODB and ODBC. The database is
¤ going to be either Access, SQLServer or Oracle. The only thing I've come up
¤ with so far is to check the registry for the driver but I can't be sure what
¤ ODBC driver they'll use.
¤ Any Clues?

You could try checking the Provider property of the connection object, although I'm not sure how the
data source is being selected to begin with.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)