By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,583 Members | 617 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,583 IT Pros & Developers. It's quick & easy.

Connecting to Oracle using Data Access Application Block

P: n/a
Hi,
I have to connect to Oracle 10g Database using Data Access Application
block code i am using is

Connection string is contained in a file called orcle.config and it
contains

<configuration>
<connectionStrings>
<add name="CDF1" connectionString="Data
Source=swifthub;Server=synpune0330\swifthub;user
id=swift;password=swift" providerName="System.Data.OracleClient"/>
</connectionStrings>
</configuration>

In code to access i am using is

dbInstance = _DataAccessService.GetDatabase("CDF1", @".
\ExternalAssemblies\oracle.config");

string sqlStatement = "SELECT ID, QUEUENAME, QUEUETYPE FROM
QUEUE";
//Loading the DataSet with specified SQL Statement
dbInstance.LoadDataSet(CommandType.Text, sqlStatement,
fillGridData, new string[] { "NewUsers" });

It is not working Please suggest where am i wrong.

Thanks

Mar 5 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.