IP Networking

i am working on informix database
can any body helps me with coding how to connect to it on solaris

i believe your question is how to connect to informix database.

it can be done in many ways.

let me explain the two ways.
if u are using dbaccess tool.

you can connect by

dbaccess <dbname@serverinstance> - <<EOF 2> <someerror.log>
select data1, data2 from <tb1>;
EOF

if u r connecting through program
prepare the statements
EXEC SQL prepare selSTMT from 'select data1, data2 from <tb1>;

and then execute the statement as
EXEC SQL execute selSTMT into :var1, :var2;

now the selected values would be in the two var1, var2 host variables.

I have not explained in detail as i am not clear with your requirement.
Please let me know if you have any more questions.

the problem is that i have a request that i retrieve from the stack. this request has to get checked in the database. if it is there fine otherwise update the database. now the problem is that you have to connect t to the database first and then check for the data right?

i am sending you the connect function.i just want to know how you r connecting your solaris program to the database which is on the client side
is it through socket programming or are there any other methods to connect to the data base


int nRetVal = 0;

SQLSetConnectOption(m_hDBC, (UWORD)SQL_OS_UID, 0, m_strUserName);
SQLSetConnectOption(m_hDBC, (UWORD)SQL_OS_PWD, 0, m_strPassword);

nRetVal = SQLConnect(m_hDBC, m_strDSN, strlen(m_strDSN), m_strSchema, strlen(m_strSchema));
if(nRetVal != SQL_SUCCESS)
{
m_bConnected = false;
return HandleError(nRetVal, "SQLConnect", "");
}

if(m_hStmt) nRetVal = SQLFreeStmt(m_hStmt);

nRetVal = SQLAllocStmt(m_hDBC, &m_hStmt);
if(nRetVal != SQL_SUCCESS)
{
return HandleError(nRetVal, "SQLAllocStmt", "");
}

m_bConnected = true;
return nRetVal;
}

Its very true that u have to connect to the database first and then check for the values.

In case if u are going for a direct connect without any client-server applications, that becomes very simple,

in your program simply go for

EXEC SQL connect to :dbName;

Else if your connection needs to be established through client-server

Prepare the above statement

EXEC SQL prepare connString from 'connect to :dbName';

then pass the above prepared statement to the client or where ur dB resides.

Once a prepared statement is received, instruct your client to execute the received prepared statement and send back the SQLCODE to the server which had sent the prepared statement.

I believe this is your requirement, if I am wrong in understanding ur question or requirement please let me know about that with more details.

Thanks