Hi,
I am new in visual basic. i want to know how to connect and access data to MS Access or MS SQL database from a visual basic form.plz write me the code.
Regards,
chowdhury
4 2006
Hi,
Try to visit A1VBCode for sample projects. if you have questions, just post it here and we'll do our best to help you with it. About the sample codes, Sorry but i can't give you that. It's our rule here. We can't spoon feed people, I really want to give you a sample but... guess you should do your part first...
Best Regards,
Jeff
Hi
chowdhury
Welcome to TSDN.
You have reached the right place for knowledge shairing.
Here you will find a vast resource of related topics and code.
Feel free to post more doubts/questions in the forum.
But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
It will help Experts in the forum in solving/underestanding your problem in a better way.
Please follow the posting guidelines in every new post/reply.
please specify your post/question clearly.
Dont expect others to guess and solve your problem.
Please dont expect complete code here .
You can follow this link for more details regarding connection string.
Thsi is used to eatablish the connection with the database from vb6.0
also u can follow this link for a sample to connect to access/oracle database.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Julie |
last post by:
We have forms written in Visual Basic 6.0. They were previously
written for an Access database which was moved to SQL Server 2000.
Here's the connect string I used:
ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRIVER={SQL
SERVER};DATABASE=MPPhoto
The user visualbasic and the user logged in to the computer have full
rights to the database.
|
by: Linda Lee |
last post by:
I purchased Visual Basic .NET version 2003 Standard
I first try to connect Visual Basic .NET 2003 Standard to SQL Server
2000 Personal edition. When I go into Visual Basic .NET under Server
Explorer and try to add the connection, I received the following
message "Unable to connect to database. It is only possible to
connect to SQL Server Desktop Engine databases and Microsoft Access
Databases with this version of Visual Studio."
Then...
|
by: Marcus |
last post by:
Hello!
I'm trying to write a VB.NET program that connects to a AS/400 Server.
I've tried almost everything, but it will not connect.
I've tried to set up a DSN using the Client Access ODBC-driver
(v8.00.04.08) but with no result. I've also tried a DSN-less
connection.
From VB.NET i'm using oleDbConnection to create the connection. If I
don't supply a provider in the connection string, the program hangs
saying that a provider is...
|
by: Zvonko Tusek |
last post by:
Is there a way to use access database on web host (I have a web hosting
account) in visual basic.
I want to make Visual basic client applications that connect to internet and
work with access database on some web server.
Can it be done?
Tnx.
|
by: mayamorning123 |
last post by:
A comparison among six VSS remote tools including SourceOffSite ,
SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
To view the full article, please visit
http://www.BetterVssRemoting.com
Better VSS Remote Access Tool
This article makes a detailed comparison among SourceAnyWhere 4.0,
SourceOffSite 4.1, VSS Connect 1.5, SourceXT 2.1, VSS Remoting 2.5,
| |
by: Dave |
last post by:
I am trying to learn .NET with the standard edition of
VC++.NET 2003 Standard edition. When I use the wizard in
the toolbox to connect to a non-microsoft ODBC data
source, I get the error message "It is only possible to
connect to SQL Server Desktop Engine databases and
Microsoft Access databases with this version of Visual
Studio".
I've seen several postings regarding this on Visual Basic
that say you can do this in VB if you don't...
|
by: http://www.visual-basic-data-mining.net/forum |
last post by:
Hi, I am new here. I am facing a problem that I can't connect to MS Access
with my Web application written in VB.Net.
It gives me this kind of error:
The Microsoft Jet database engine cannot open the file 'E:\DATA1.mdb'. It is
already opened exclusively by another user, or you need permission to view
its data.
I try to connect to the DATA1.mdb through server pool, the connection is
tested successfully, but I can't connect to it...
|
by: Wade |
last post by:
Is it possible to connect to a SQL 2005 Express db using Visual Basic 2005
Express?
I cannot get past the connection.open statement without the error
"...Version=2.0.0.0; SqlClient.SqlClientPermissions;
PublicKeyToken=b77a5c561934e089 failed."
I have WinXP, SQL Express 2005, and VB 2005 Express all on same machine.
I've found hundreds of samples and tried most of them, but still get same
error.
|
by: Alex Hardin |
last post by:
Hey,
I'm trying to use the connect to database wizard to connect to a MySQL
database on my web server, 66.235.193.45 (I'm actually not sure if that
points specifically to my part of the server, if not, the domain that
goes right to is is www.freddyswebgraphics.com, which I have tried as
well), and everytime I try to test the connection I get this error
message.
Test connection failed because of an error in initializing provider....
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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...
|
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,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |