Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps in connecting to database?
- 3 Answers
- 11629 Views
- IBM, Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sanket pandit
An alternate, and preferred way, to using the DriverManager class is to use a DataSource object.
This is for SQ L Ans.
1. The data source is registered on the server side, which stores connection information, like: host, port, sid, credentials (optional), driver to use, etc.
2. The application gets a handle on the data source through a JNDI lookup.
3. The DataSource object is a connection factory and you can invoke .getConnection()
One of the reasons it is preferred over the DriverManager is because it is more flexible. The connection in
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does executereader return?
Which is the best method to get two values from the database?
What is a serialized object?
What is the difference between SqlCommand and SqlCommandBuilder?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is the use of sqldatareader class?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What is untyped dataset?
Define executenonquery?
How is it possible to get 2 tables of data at a time by using data reader?
What does sqldatareader return?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
Explain the difference in record set and dataset?
What are the benefits of using of ADO.NET in .NET 4.0?
Explain how do you connect to sql server database without using sqlclient?
