Finding the oracle connection

[sssyed_in]

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 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.

[pepesmith]

I may be late in informing you .. but
let me say this

Microsoft has released a data provider specific to Oracle and Oracle has also released their own .NET data provider (ODP.NET available at oracle.com).

You dont need to use the OLEDB, you only need is odp which is native of oracle

Thank you

:D

[sssyed_in]

Thanks for your info.

I was told about odp.net earlier. But the problem is it will support only oracle 9 or higher versions.

My problem is I have to connect with a database by oledb connection. After connecting I should know whether it is an oracle connection without parsing connection string.

Thanx.