For my projects in Visual Studio 2003 in my connection strings I would use the MSDAORA (MS OLE DB Provider for Oracle) provider and it worked fine.
Now with Vis Studio 2005 that provider connection type no longer works correctly. I can't seem to find a provider that works correctly with a Oracle 8.0.6 client. Does anyone know the correct provider I need or the drivers that I need. I have tried ODBC and OLEDB but nothing is working properly.
I have an 8.0.6 database but maybe I need a newer Oracle Client software
Any experience in this delima would be appreciated.
Thanks,
Oracle 8.0.6 connection in VS 2005
EwaRJ
What is the error you get
Is your VS 2005 on the same machine as VS 2003 If so, then I am assuming the provider is working okay outside of VS 2005. If this is a new machine where you have installed 2005, then make sure the provider works okay by itself. You can do this by creating a DataLinks file on the desktop. Create a text file with the extension .udl (make sure it doesn't save as .udl.txt). Double-click that file, and configure the connection there in the same way that you are configuring. Click the Test Connection button and see if it works.
I wouldn't think that Oracle even supports that version anymore, but I don't know for sure. I would imagine they would want you to upgrade to something newer. However, as far as MSDAORA is concerned, it should work. In fact, it isn't even supported with versions later than 8i. See KB 244661 for info on that (http://support.microsoft.com/default.aspx scid=kb;EN-US;244661)
Aside from all of that, if you are writing an ADO.NET application, the recommended Oracle access method would be to use a managed provider, such as System.Data.OracleClient, or the version that Oracle and other vendors provide. These providers may have minimum client version requirements. System.Data.OracleClient requires 8.1.7 or higher.
Thanks,
Sarah