Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the syntax code for oldb to connect oracle

Answers were Sorted based on User's Feedback



what is the syntax code for oldb to connect oracle..

Answer / srinivas.kinthada

i think oldb is not correct it's may b.
it is oledb

using system.data.oledb;
oledbconnection cn=new
oledbconnection("uid=<username>;pwd=<password>;server=<servername>");
cn.open();

Is This Answer Correct ?    2 Yes 0 No

what is the syntax code for oldb to connect oracle..

Answer / raghavendra.v

it is not oldb it may be oledb

using System.Data.Oledb;

Oledbconnection cn=new OleDbConnection
("Provider=Msdaora.1;uid=<username>;pwd=<pwd>;server=<server
name>");
cn.open();

Is This Answer Correct ?    1 Yes 1 No

what is the syntax code for oldb to connect oracle..

Answer / sudha

first add the namespace

using system.Data.oledb;

OledbConnection cntn = new OledbConnection("Provider =
Microsoft.jet.oledb.12.0;datasource = (local);Integrated
security = SSPI,persistent Security = false");

provider = it depends on version of Microsoft Access like if
it is 2003 - 4.0 & if it is 2007 - 12.0

dataource - u can make it as local or provide the path to ur
database

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More ADO.NET Interview Questions

What is aggregating data ?

0 Answers  


What are the steps you will take to improve performance?

0 Answers  


Explain the namespaces in which .net has the data functionality class.

0 Answers  


Explain how to pass multiple tables in datasets simultaneously?

0 Answers  


What are the benefits of using of ADO.NET in .NET 4.0?

0 Answers  






Explain the role of data provider in ado.net?

0 Answers  


What are the steps to connect to a database?

0 Answers  


Explain how to find the given query is optimised one or not?

0 Answers  


What is ado.net connection?

0 Answers  


What are the two fundamental objects in ADO.NET?

6 Answers  


OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,


Can you edit data in the Repeater control?

9 Answers  






Categories