Determining the oledbconnection is from oracle database
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all, I am constructing a oledbconnection using the connection string which obtained through data link properties dialog. After getting a connection string we can easily create oledbconnection irrespective of the database. My problem is I should know the oledbconnection is with an oracle database. How can I know? The only way I know is checking the database provider in the connection string that it is from oracle. But what is the problem with this, this is always possible only if we know all the oracle oledb providers. That also will fail, if they change the version in future. Without using the provider in the connection string, is there any other way to determine whether the connection is with an oracle database? Thanks.