Database Connection

Did you add ADO library to your project??

HI..
PLZ TRY THE FOLOOWING POINTS
1)ADD ADO LIBRARY
2)Dim cn As NEW ADODB.Connection
3)Dim cmd As NEW ADODB.Command

BY
RAMESH

Hi,
Please follow the following Steps,

1. Projet menu -> Refences -> Select Microsoft ActiveX Data Objects 2.1 Library and click ok Button.

2. Use the following code,

Dim con As New ADODB.Connection
Dim rs As New ADODB.RecordSet

con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\UserLogin.mdb;Persist Security Info=False"

con.CursorLocation = adUseClient

rs.Open "Login",con


<<Here, Your database access code>>


rs.Close
con.Close

Here,
D:\UserLogin.mdb -> DataBase Location
Login -> Table Name

Note:
After finishing database access code you must close RecordSet(rs) and Connection(con).

Take Care,
Bye... Bye...

Hi,

Dim cn As ADODB.Connection

Set cn=New ADODB.Connection
cn.ConnectionString="Provider=Microsoft.Jet.OLEDB. 4.0;" & _
"DataSource=D:\ProgramFiles\MicroSoft Visual Studio\VB98\inventory.mdb"
CN.Open

Try This Title: "Develop an Inventory Management Application Uisng Microspft's Visual Basic" (Access as a backend)


Hope this helps.

Regards
bhar

Hi Everybody
I am tring to connect the vb code to ms access databse using ADO method.
and its gives the Compile Error : user defined Data type is not defined.
i have declared the following and complier highlights the declaration.

Dim cn As ADODB.Connection

Dim cmd As ADODB.Command

please help
Nee123

Thanks a lot for the code i m a new member and i was needing these code.
thanks again

Hi,
Please follow the following Steps,

1. Projet menu -> Refences -> Select Microsoft ActiveX Data Objects 2.1 Library and click ok Button.

2. Use the following code,

Dim con As New ADODB.Connection
Dim rs As New ADODB.RecordSet

con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\UserLogin.mdb;Persist Security Info=False"

con.CursorLocation = adUseClient

rs.Open "Login",con


<<Here, Your database access code>>


rs.Close
con.Close

Here,
D:\UserLogin.mdb -> DataBase Location
Login -> Table Name

Note:
After finishing database access code you must close RecordSet(rs) and Connection(con).

Take Care,
Bye... Bye...