Re: [DOTNET] System.Data.OracleClient.OracleConnection

2002-05-16 Thread Raj Chanian
erent 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: [D

Re: [DOTNET] System.Data.OracleClient.OracleConnection

2002-05-16 Thread Kevin Hector
>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=tig

Re: [DOTNET] System.Data.OracleClient.OracleConnection

2002-05-16 Thread Raj Chanian
Raj -Original Message- From: Kevin Hector [mailto:[EMAIL PROTECTED]] Sent: 15 May 2002 20:42 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] System.Data.OracleClient.OracleConnection Set Integrated Security=no (or false, or just leave it out since false is the default). afaik, you either use Integ

Re: [DOTNET] System.Data.OracleClient.OracleConnection

2002-05-15 Thread Kevin Hector
Set Integrated Security=no (or false, or just leave it out since false is the default). afaik, you either use Integrated Security, or you supply an oracle username/password. >m_Connection = "Data Source=ORCL;User ID=" + userId + ";Password=" + >password +";Integrated Security=yes";

[DOTNET] System.Data.OracleClient.OracleConnection

2002-05-15 Thread Raj Chanian
Hi Dotnetters, I have managed to set up my connection string to point to the OracleService. However I am getting invalid user/name password on the following line //Open the Connection to the Managed DataSource oracleConnection.Open(); Here is a snippet of my code OracleConnection orac