ORacle Connection String


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

Advertisements

M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top