Wednesday, June 29, 2011

How to Connect Database Using ODBC (Object Database Configuration/Connectivity)



This ODBC method is applicable to Visual Basic .Net and Visual Basic 6.0 using MS Access Databse (.mdb). Please follow the instructions below on how to setup database.
1.  Click Start button, and select Control Panel


2. Once the control panel open, please double click Administrative Tools.
Note: If you can't locate the the administrative tools, please select Classic View at the left side of the control panel pane.

 
 
 
 
 
 
 
 
 
 
 
 
 
 



3. Under the Administrative Tools, double click to select the Data Sources (ODBC) as shown the image below.  After selecting the Data Sources, the ODBC panel window will display.



4. Now we are going to add new datasebase, click Add button and new window willl appear "Create New Data Source", select the Driver do Microsoft Access (*.mdb) for MS Access, click Finish Button.


5. We're almost done, let's configure the ODBC for MS Access, under Data Source Name, type the  MyDatabase, please leave blank the description it's optinal. Now, let's select the path of your database .mdb once you found it select OK button.


6. The image shown below that the Database .mdb is successfully located. Click OK button to Finish the configuration. (MS Access Database Configuration done).

7. Done! You are now ready to connect your visual basic program using this ODBC setup.



16 comments:

Cegonsoft said...

your screenshots and step by step given process is very useful for me and all the beginners ,,,thank you
Cegonsoft

arya said...

thank you for the information is very helpful at all

sap upgrade tools said...

This post gives the exact description of how to connect database to ODBC. Each step is explained in detail with screenshot so you can easily follow them while connecting database to ODBC.The information on this blog is very useful.

perumal said...

Information given clearly with step by step screenshot...really good job.

Unknown said...

hi i m try this tutorial but my problem is not solve plz help me some body as soon as posible.......

KPH Media India said...

I really like your blog, because this info is very useful for us. It can be difficult to get the top SSC Coaching in Chandigarh these days. Due to Covid's policies and limitations, you cannot visit, go out, or attend a demo class. So, we have already done all the hard work for you and have used KPH media India to list their cost structure, batch times, complete address, contact information, infrastructure photographs, and entire course syllabus on their website.

StarshipPhantom101 said...

Eskişehir
Denizli
Malatya
Diyarbakır
Kocaeli
EKM02C

CyberSeeker007 said...

görüntülüshow
ücretli show
HYİ0U

QuantumPioneer said...

giresun evden eve nakliyat
balıkesir evden eve nakliyat
maraş evden eve nakliyat
kastamonu evden eve nakliyat
kocaeli evden eve nakliyat
KQX2

D8602Paul63FB1 said...

A04B7
Rize Parça Eşya Taşıma
Gölbaşı Parke Ustası
Sakarya Evden Eve Nakliyat
Adana Lojistik
Giresun Şehirler Arası Nakliyat
Ağrı Şehir İçi Nakliyat
Tekirdağ Cam Balkon
Bayburt Şehir İçi Nakliyat
Artvin Evden Eve Nakliyat

21F38ThomasF8DF7 said...

AAEE4
Çanakkale Lojistik
AAX Güvenilir mi
Sakarya Parça Eşya Taşıma
Denizli Evden Eve Nakliyat
Baby Doge Coin Hangi Borsada
Antalya Rent A Car
Ünye Yol Yardım
Poloniex Güvenilir mi
Kocaeli Şehirler Arası Nakliyat

Kick Rail | Manufacturer from China | Aotons said...

Aotons Kick Rail can prevent the forklift truck from passing through and colliding from the bottom, and can be used as the ground pallet storage or the limiter of forklift truck. It can also be integrated into the traffic barrier or pedestrian safety barrier system. According to the impact test, it can resist the impact of 6-ton forklift at the speed of 5km/h without damage.

Custom Packaging Tubes for Electronics from China said...

As a cylinder packaging manufacturer with over 10 years of experience, Hopak custom electronic packaging with high-quality paper tubes. Whether you sell electronics or electronics parts, Hopak packaging tubes for electronics will represent the value of your brand. Different from other suppliers, Hopak only utilizes first-class paper material to keep your fragile electronic products safe from scratches and damage in general. Create a functional and good-looking electronic packaging solution that will display your advanced tech

Bump Test Machine Manufacturer from China said...

Linkotest offers PC-controlled pneumatic shock testers known as Bump Test Machines. These machines are designed to ensure accurate and repeatable shock testing for both laboratory and production environments. They are capable of testing samples weighing up to 1000 kg (depending on the model).
Equipped with shock pulse programmers, these machines can generate short and long duration half sine shock pulses. This functionality allows them to meet strict automotive, military, and industrial specifications, as well as customized testing requirements. The generated waveforms comply with various military standards, such as MIL-STD-202, MIL-STD-750, MIL-STD-810, and MIL-STD-883.

Low Voltage Motor Control Center said...

The low voltage motor control center (MCC) is an integrated electrical control equipment used to start, stop, and protect motors. It provides centralized control and power distribution for motors in industrial and commercial applications. The low voltage MCC consists of a frame, busbars, circuit breakers, starters, control devices, interlocking devices, cable ducts, etc.

Máquina de caja corrugada said...

BM2508-SE es un fabricante de cajas multifuncional Máquina de caja corrugada
completamente automático con ranurado y marcado horizontal, corte y plegado vertical, corte horizontal, todo en una máquina compacta. En comparación con el modelo BM2508-Plus, el modelo BM2508-SE es una máquina de versión económica, que es de gran importancia para todos los usuarios bajo la epidemia. Para reducir el presupuesto y los gastos, está equipada con un alimentador de borde delantero de 900 mm, 2 ruedas de hendido verticales y un módulo de troquelado de orificio de mano retirado.

Post a Comment

 
Powered by Blogger