The given below script procedure help us in connecting to the database where we can test both; the database and queries.
* The script procedure for database connection,
db_connect(“query1”,DRIVER={driver name};SERVER=server_name;
UID=uidname;PWD=password;DBQ=database_name “);
* The script procedure to execute the query,
db_excecute_query(“query1″,”write query u want to execute”);
-Condition to be mentioned-
* The script procedure to disconnect the connection with the database,