Database Connection

[nee123]

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.Connectio n

Dim cmd As ADODB.Command

please help
Nee123

[samah]

Did you add ADO library to your project??

[ramesh_tankala]

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

BY
RAMESH

[suresh_punniyakkodi]

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.Connectio n
Dim rs As New ADODB.RecordSet

con.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=D:\UserL ogin.mdb;Persis t Security Info=False"

con.CursorLocat ion = adUseClient

rs.Open "Login",con


<<Here, Your database access code>>


rs.Close
con.Close

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

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

Take Care,
Bye... Bye...

[bhar]

Hi,

Dim cn As ADODB.Connectio n

Set cn=New ADODB.Connectio n
cn.ConnectionSt ring="Provider= Microsoft.Jet.O LEDB.4.0;" & _
"DataSource=D:\ ProgramFiles\Mi croSoft Visual Studio\VB98\inv entory.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.Connectio n

Dim cmd As ADODB.Command

please help
Nee123

[AshishGupta]

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.Connectio n
Dim rs As New ADODB.RecordSet

con.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=D:\UserL ogin.mdb;Persis t Security Info=False"

con.CursorLocat ion = adUseClient

rs.Open "Login",con


<<Here, Your database access code>>


rs.Close
con.Close

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

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

Take Care,
Bye... Bye...