Thanks Kevin, That correction works for me as well now.
Funny, why the .chm doesn't mention nothing about the credentials, and the option of taking out the Integrated Security parameter. BTW, I have made my wrapper dual purpose 1] Via Managed Provider 2] Via OLEDB Both work now with different respective connection strings. Now for the fun part, getting ref cursors from both flavours! See you later... Regards, Raj -----Original Message----- From: Kevin Hector [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 12:07 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] System.Data.OracleClient.OracleConnection >Has anybody had success yet with the Oracle Managed >Provider connection string? Yes it worked for me. I have 8.1.7 Enterprise Edition installed on my w2k server workstation. Using the default starter db (SID=ORADB1) my connection string is connStr="Data Source=ORADB1;User ID=scott;Password=tiger"; Out of interest, can you connect to the database using the server explorer in VS.NET? Also, can you connect to the database in your code using System.Data.OleDb.OleDbConnection using connection string connStr="Provider=MSDAORA.1; Data Source=ORADB1;User ID=scott;Password=tiger"; Kevin _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
