how to connect to msaccess through VB using ADODC

1 New Member

Hi,

i'm facing one problem from 3 days.i'm unable to connect to MSAcess using ADODC control in VB please reply as soon as possible.

Aug 23 '07 #1

Subscribe Reply

7868

vinci

New Member

Hi,

i'm facing one problem from 3 days.i'm unable to connect to MSAcess using ADODC control in VB please reply as soon as possible.

i guess u already added the ADODC control on your form...

first thing u do is to right click the control and select the ADODC properties
then u choose whether ul use connection string, ODBC, or UDL

connection string(CS) is the easiest so will do CS:
select "use connection string" radio button then click build

select the path of ur access dbase..if ur dbase has a uname and password , just type in the uname/pwd on the field provided...

then in the provider tab u select "Microsoft Jet 4.0 Ole DB Provider" then click ok...

basically thats how u connect to ur access dbase...

hope u got it! Enjoy Coding!

Aug 24 '07 #2

slapshock

New Member

Add the MIcrosoft ADO Data control 6.0 (OLEDB) in your component, then after that drag it to your form then right click the adodc control then,

1.Select adodc properties
2.select the Use connection string, then click build and select yor database for the connection
3.then in the provider tab u select "Microsoft Jet 4.0 Ole DB Provider"
3.then go to the recordsource tab, then choose the commandtype to adcmdtext
4.and then in command text sql, type the query e.g. Select * from tablename

5. then click apply and ok
6.then you are now connected to your database

Happy Coding..

Slapshock

Aug 24 '07 #3

Dököll

2,364

Recognized Expert Top Contributor

Additional info just in case of a report:

http://www.thescripts.com/forum/thre...65-adodc1.html

You may find added examples through Search term above, simply add adodc or ado.

Good luck with the project!

Aug 24 '07 #4

Similar topics

5985

AdoDc control peculiar problem

by: Raoul Watson | last post by:

I have a form with an AdoDc control associated to a datagrid. The AdoDC uses a "ConnectionString" such as "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=..." this is where the problem begins. The data source will not be known until the user selects the database. What is really weird is that if the source is not placed during design time, during run time the form upon loading will generate an error ("Failed to

Visual Basic 4 / 5 / 6

121936

connect to an access database using javascript

by: kartheek | last post by:

hi friends, can any one out here help me by giving me the code to connect to an MSACCESS database using javascript.

Javascript

1804

how to bind datacombo with msaccess

by: taimoor | last post by:

hello to every one i m in learning process now i want to know that how we bind the data combo with msacees like we bind text box with msaccess using adodc or data environment or code library

Visual Basic 4 / 5 / 6

2049

how to connect to an Access DB from a webfarm?

by: GNoter | last post by:

Scenario: I've a WebFarm with 2 web servers which are NLBs (network load balanced). Web1 and Web2; they are not part of a domain. I have a third server, Server3, which is part of a domain and on the same physical network, and it has an MSAccess database which is used on the external webfarm as well as on the internal intranet. I can connect via the intranet because the DB file is on the same box from which the intranet is being served...

.NET Framework

1539

Can i connect a Access database without using DataControl or ADODC..?

by: jackvel | last post by:

Hi Dudes... I want to connect the Access database with VB 6.0 without using DataControl and ADODC.. Which option should i use.? Plz send me the detailed procedure of doing the same.. Plz help me, i need it urgently.. Thanks..

Visual Basic 4 / 5 / 6

1584

To connect VB Programming 6 and MS-Access

by: Zelalem | last post by:

Help me to connect VB Programming 6 and MS-Access without using ADODC. Thank you in advance

Visual Basic 4 / 5 / 6

2384

unable to connect oracle9i with vb6

by: Mishika9486 | last post by:

Hi pals.. i hav developed an application in vb nd am tryin to connect using oracle.. it gives the following error using ADODC and ODBC "test connection failure because of an error in initializing provider.driver for oracle]" please help..

Visual Basic 4 / 5 / 6

3121

how to connect vb to access db....

by: vikas1111 | last post by:

How to connect visual basic to access database without using adodc...

Visual Basic 4 / 5 / 6

2015

HI good day to all... i have a problem on how to connect the 2 tables in a database?

by: psyvanz | last post by:

Im a college student, my program is a computerized enrollment system, Im using MS ACCESS database in connecting my VB6 program form. Inside i'd created two tables, named "tbstudentinfo" and "tbstudentfees". In my 1st table i renamed my fieldname to STUDENTNUMBER and STUDENTNAME on the second fieldname, then below i entered (0001) for studnumber and (Paul) for studname. The 2nd table is almost the same with the 1st table but i added another...

Visual Basic 4 / 5 / 6

9728

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10648

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10389

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10402

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10135

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9205

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5554

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3867

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3018

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General