0
If you want to connect to any database, you need to follow certain methods. Start by creating a database connection, configuring, binding data and testing.
Different programming languages have different ways to connect. For example, in visual studio .Net, if you want to connect to any database then you need to follow the database configuaration wizard. That means you connect your application to a database by running the "data source configuration wizard" and selecting database on the "choose a data source type" page.
Another example: suppose you are using Java..
Regardless of whether you're trying to connect to Oracle, SQL Server, MySQL, Postgres, mSQL, Interbase (or any other JDBC data source), establishing a connection to a database with Java JDBC is a simple two-step process:
1)Load the JDBC driver.
2)Establish the JDBC connection to your database
You can also use Microsoft Access and once you have data objects such as tables, views, proceduers, etc. then you can connect by following the self explanatory wizards.
This answer might give you a generic idea since the question is a generic question.
If you need further assistance then send your query to:
palemjn@hotmail.com
Jitendra
**Grammar corrected by gbaughma**
Additional note from gbaughma: MS Access doesn't do stored procedures. ;)
What else can I help you with?
What is DSN in Web Designing?
A Data Source Name(DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it.
Does database software store information in HTML codes?
No, database software does not store data using Hyper Text Markup Language (HTML) codes. A common code used to access data is Structured Query Language (SQL). HTML is a formatting language that will tell a browser how to display the data retrieved from a database.
How do you validate and retrieve data from database?
How do you validate and retrieve data from database?" How do you validate and retrieve data from database?"
Differentiate DATA from a database?
A database is a collection of data. Data represents items that are stored within the database.
What is a DSN used for?
A DSN (Data Source Name) is used to connect an application to a database by defining the database connection parameters such as server location, database name, username, and password. It helps manage and streamline database connections within an application.
Difference between database and database instance?
In general, a database is a collection of related data. In more specific terms, a database is typically a collection of computer files, usually stored on disk, used to contain and manage this data. The logical structure of a database (as organized in tables, indexes, views, etc.) does not necessarily correspond directly to its physical structure (the data files, transaction log files, etc.). A database instance is the instantiation of memory structures and processes by a database management system manages the logical and physical structures and the data organized and stored therein. An application program must connect to and interact with the database instance in order to insert, retrieve, modify, and/or delete data stored in the database.
Enter on the database or in the database?
We would use in rather than on. Data is stored in a database, not on a database. Data is entered into a database not onto a database.
How do you connect to a database and table using ADODB?
How do you connect to a database and table using ADODB?
How do you design forms in object oriented database?
A database is about storing data, not about creating forms. You would create the forms in some programming language - NOT something directly related to the database server - than have your forms, or rather your program in general, connect to the database.
Why do Database Management is related to MS Access?
Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.
What is a connection string used for in computers?
A connection string in computing is a string that specifies how to connect to a data source and information about the data source. It is commonly used in database files.
What are to advantages of a database?
A database is a collection of interrelated data and the advantages of a database are ensured efficiency, standardized data, maintainable data, integrated data, reduced redundancy of data.
