String ConnectionString = "Provider=MSDAORA;Data Source=xxx;User ID=xxx; Password=xxx;";

String ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["xxx"].ConnectionString.ToString();

I end up with an error eventhough xxx is defined in my web.config as a standard connectin string. Any ideas on what I am doing wrong?

Here is what is in web.config

Here is the call I make in the Page_Load (VB)
         Dim strConn As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString

and C#
        string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

Hope this helps
Irinel

String ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XXX"].ConnectionString;
OleDbConnection DBConnection = new OleDbConnection(ConnectionString );
OleDbDataAdapter DBAdapter;
DataSet ResultsDataSet = new DataSet();

An OLE DB Provider was not specified in the ConnectionString.  An example would be, 'Provider=SQLOLEDB;'.

Line 194:   
Line 195:     
Line 196:   OleDbConnection DBConnection = new OleDbConnection(ConnectionString );
Line 197:   OleDbDataAdapter DBAdapter;

 2. Define a SqlClient connection and keep the connection string format you already have 
          ConnectionString ="Data Source=myServer;Password=myPassword;User ID=myUser;Initial Catalog=pubs"

Hope this helps
Irinel

<add name="xxx" connectionString="Data Source=xxx.com;Persist Security Info=True;User ID=xxx;Password=xxx" providerName="System.Data.OracleClient" />

And I am not sure sure how to apply your recommendation. I have

Line 194:   

Line 196:   OleDbConnection DBConnection = new OleDbConnection(ConnectionString );
Line 197:   OleDbDataAdapter DBAdapter;

irinelc,

I had the same problem and when I try to follow what u suggested, I get this error

"Type or Namespace ConfigurationManager does not exist in System.Configuration.."

Am I missing to include an assembly ref? Please guide me with a way out.

My datasource is oracle, I'm using an OleDbprovider for connection.

TIA,

Elektra

Hi

What Framework version are you on?

Irinel

i am using .net v.1.1.4322

also, i see a problem with the provider i use for connection. With oledbdrivers installed on my machine, can u help me why i get the error as:

TNS couldn't resolve service name.

this is my connection string:

using System.Data.OleDb;
...
OleDbConnection  oracleConn = new OleDbConnection();
oracleConn.ConnectionString = "Provider=\"OraOLEDB.Oracle.1\";
                              User ID=scott;Password=tiger;
                              Data Source=yourSource;
                              Extended Properties="";
                              Persist Security Info=False";
oracleConn.Open();

 Thank you. This has solved my access connectivity problem.

Regards,

-Sunny.