ORacle Connection String

[Guest]

I used the IDE to generate the connection string and it generated the following

Provider=OraOLEDB.Oracle;Persist Security Info=False;User ID=SomeID;Data Source=EDSSP.DDDDD;EXTENDED PROPERTIES=''

Now when I take this text and create a connection object with it, I get an error on the "Provider" attribute with the following message...."Keyword not supported: 'provider'". Why does it not like the value on the connection string. The IDE generated it and it was able to connect to the database ok. What am I missing?

 

[Miha Markic [MVP C#]]

Hi Jim,

IDE uses OleDb connection strings.
However if you use such string with specific provieder then the Provider
part isn't necessary because it is implicitly defined.
Just leave the provider part out.
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

I used the IDE to generate the connection string and it generated the following:

Provider=OraOLEDB.Oracle;Persist Security Info=False;User ID=SomeID;Data

Source=EDSSP.DDDDD;EXTENDED PROPERTIES='';

Now when I take this text and create a connection object with it, I get an

error on the "Provider" attribute with the following message...."Keyword not
supported: 'provider'". Why does it not like the value on the connection
string. The IDE generated it and it was able to connect to the database ok.
What am I missing?