ORacle Connection String

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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

Jim Heavey said:
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
Click to expand...
Source=EDSSP.DDDDD;EXTENDED PROPERTIES='';
Now when I take this text and create a connection object with it, I get an
Click to expand...
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?
 
Back
Top