Connecting Database

Posted Date: 30 May 2008	Resource Type: Code Snippets	Category: Visual Studio
Author: Pravyn	Member Level: Silver
Rating:	Points: 10

Establishing a Connection between Visual Basic & Database

Connection Code for connecting VB with Access & SQL using ADO.

Dim Conn As New ADODB.Connection (In Declaration)

(In Form)
(For Access)
Set Conn = New Connection
Conn.Open = "Provider=Microsoft.Jet.OLEDB.3.51;" _
& "Data Source = C:\Microsoft Visual Studio\Vb98\table.mdb"

(FOR SQL)
Conn.ConnectionString = "Provider=SQLOLEDB;Server=ServerNT;" _
& "User ID=pravyn;Password=*****;Data Source=Pubs"

Connection Code for connecting VB with Access using DAO.

Dim rs as Recordset
Dim db as Database

db=OpenDatabase(E:/........)
rs = db.recordset("....")

Responses

Author: Kapil Dhawan 18 Jun 2008

Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Show specific page from the multiple Image file in the pictureBox
	Previous Resource: Shortcuts for Visual Studio
	Return to Discussion Resource Index
	Post New Resource
	Category: Visual Studio

Post resources and earn money!

More Resources