megha_maya

 Profile Answers by megha_maya 

• Mar 6th, 2008

 

1. connect to the database using a DSN/establish a connection
set con=Createobject("ADODB.connection")
2.open the connection
con.open "DSN=mention your data source name where it stored currently"
3. SQL - execute an SQL query
set rs=con.execute("select * from order where order_no < 5
4.get the result from the resultset and fetch the query
msgbox rs(order_no).value
5.finally close the connection.
con.close

if anything wrong kindly send the correct details

asreddy29

 Profile Answers by asreddy29 Questions by asreddy29

• Mar 17th, 2008

 

I guess the above one is correct

- by asreddy.