database connectivity
2007-01-04 05:28:10 · 5 answers · asked by Anonymous in Computers & Internet ➔ Software
When I was coding planetsourcecode.com was the best place I found for snippets of code to use.
2007-01-04 05:31:32 · answer #1 · answered by Phil W 2 · 0⤊ 0⤋
U want to connect to which Database ORAcle,SQL Server or MS Access etc...
Dim constr as String'constr =connect ot which database
Dim con as new ADODB.Connection
Dim rs as new ADODB.RecordSet
constr="Provider=MSDAORA.1;Password=123456789;User ID=ravi;Data Source=MEDAORCL;Persist Security Info=True"
con.ConnectionString=constr
con.open
rs.open "Select * from emp",con, adOpenStatic, adLockBatchOptimistic
2007-01-05 05:51:23 · answer #2 · answered by Ravi Nanjunda Rao 3 · 0⤊ 0⤋
U want to connect to which Database ORAcle,SQL Server or MS Access etc...
Dim constr as String'constr =connect ot which database
Dim con as new ADODB.Connection
Dim rs as new ADODB.RecordSet
constr="Provider=MSDAORA.1;Pas... ID=ravi;Data Source=MEDAORCL;Persist Security Info=True"
con.ConnectionString=constr
con.open
rs.open "Select * from emp",con, adOpenStatic, adLockBatchOptimisti
2007-01-08 05:30:59 · answer #3 · answered by irfan 3 · 0⤊ 0⤋
Take data control from the toolbox & connect it to the your database,u have to make that database in the add -in-menu>New >Acess 7.0 . and set that database name to the data control's propety i.e. Data1.databasename=" students.mdb"
and then the database u have create table in that same as above
and then set data1.recordsource="students"
2007-01-05 00:31:28 · answer #4 · answered by nicky c 1 · 0⤊ 0⤋
Hey,
Check out this link for making DB Connection in VB6.
http://www.vbexplorer.com/VBExplorer/wrox/sample1061.asp
2007-01-05 00:51:18 · answer #5 · answered by ur_nice_friend_4ever 2 · 0⤊ 0⤋