I am beta testing for SP2010 and SPD2010. I am trying to connect an Oracle DB and I am not given the option in the 'Provider Name' of the 'Configure Database Connection' dialog box. Is there a fix to this?
SPD 2010 Connection Config Screen Shot
http://s290.photobucket.com/albums/ll253/jeremy__31/SP2010%20and%20SPD2010/?action=view¤t=SPD2010_Oracle_Screen_Shot_1.jpg
I downloaded and installed the Oracle .NET OLD DB component for Oracle 11g and I am still unable to connect to the oracle server.
Oracle 11g .NET OLD DB component URL
http://www.oracle.com/technology/software/tech/dotnet/utilsoft.html
However, 'Use custom connection string' does list 'Microsoft .NET Framework Data Provider for Oracle' and after using a valid connection string, but am still unable to connect.
Data Source={Server Name];User ID={user name];Unicode=True