7 replies to this topic

[Lop]

Anyone ever connected to Oracle from C#? How is this done?

[Crane]

You will need to use ODBC connection to do this. I don't have any tutorials or code examples to give you.

[brackett]

Oracle has a .NET client, I think. If not, you should use OleDb. ODBC should be your last choice.

[Lop]

I'm not sure what OleDb is. I went ahead and created a connection from ODBC but now you say I should use it as a last choice, why?

I've read several times that the microsoft oracle client is way to slow: http://msdn.microsof...racleclient.asp

So I'm now left with OleDb, can you explain this?

[brackett]

Lop said:

I'm not sure what OleDb is. I went ahead and created a connection from ODBC but now you say I should use it as a last choice, why?

I've read several times that the microsoft oracle client is way to slow: http://msdn.microsof...racleclient.asp

So I'm now left with OleDb, can you explain this?

There's an actual Oracle provided .NET client called ODP.NET - that's likely to be the fastest.

OleDb is the successor to ODBC, and is the preffered way of connecting to non-native clients. You, of course, still need an OleDb driver for your particular database server (Oracle, in this case). You could use Microsoft''s Oracle OleDb driver, but if you install the Oracle Client Tools, you can use Oracle's as well.

Programattically, the main difference is that there are no DSN's with OleDb and you use a different namespace. Use the System.Data.OleDb namespace, and get a connection string from connectionstrings.com and you should be all set.

Of course, I actually recommend using the ODP.NET client, but OleDb is good to know about anyway.

[Lop]

I'm just now doing more work on this project with Oracle. None of these methods (other than ODBC) will work on Oracle earlier than 8.1.7.....

[Ronin]

Use ODBC - you won't notice the difference in speed.