Loadrunnner scripting query

[amaithani]

scenario
1. i want to make a connection to SQL Server 2005 database
2. after connecting to the database i want to execute an SQL query and retrieve the data

i have written code in MS SQL protocol which is as follows.
i am still not able to connect to the database.

can somebody help me out in this. i'll be greatful

#include "lrd.h"

static LRD_INIT_INFO InitInfo = { LRD_INIT_INFO_EYECAT};

static LRD_DEFAULT_DB_VERSION DBTypeVersion[] =
{
{ LRD_DBTYPE_ODBC, LRD_DBVERSION_NONE}
};

static void FAR * SQLServerEnv1;
static void FAR * SQLServer;
static LRD_CONNECTION * Con1;
static LRD_CURSOR * Csr1;




vuser_init()
{

lrd_init(&InitInfo, DBTypeVersion);

/* lrd_initialize_db(LRD_DBTYPE_ODBC, 3, 2);

lrd_env_init(LRD_DBTYPE_ODBC, &SQLServerEnv1, 0, 0);

lrd_server_attach(SQLServer, "database_name", -1, 0, 0); */

lrd_open_connection(&Con1, LRD_DBTYPE_ODBC, "userID", "password", "SFCVMQASQ21", "", 3, 0, 0);


}

thanks in advance.

Regards,

Anoop