help in C code using client lib function of sybase

[ashok rajagopal]

We are getting return code = 0 in our code while executing the below function.



ex_use_db is called from our program which in turn executes function ex_execute_cmd() and the database connection is failing here. It goes into the ex_error of the If condition.



the same functions are being invoked by the sample program provided by CS reference manual by sybase and that does not go into the ex_error. (It is giving a return code = 1)

Any idea of what is going wrong ?

[teknomage1]

I think you'll need to post some code. Check all your input parameters and any global variables that are referenced to start. Make sure the sample is linking to the same libraries, check any settings that might affect the functions in question. If all else fails, Sybase is bound to have a support plan.

[ashok rajagopal]

if( (ret=ex_connect(context,&connection,"SO_PLATE",gszSqlUser,gszSqlPassword,gszDBServer)) != CS_SUCCEED)
      {
         fLogError("SO_PLATE - Unsuccessful LOGIN on database.");
         fLogError("SO_PLATE - Unsuccessful OPEN on database PMLL.");
                         //return 0;
                         exit(ERREXIT);
      }
              strcpy(sql_string, "USE pmll_test");
              strcat(sql_string,gszDBName);
//it is at this point that i am having the errors.  
      if((ret = ex_execute_cmd(connection,sql_string)) != CS_SUCCEED);
      {
                          fLogError("SO_PLATE - Unsuccessful USE on database PMLL.");
                          //return 0;
                          exit(ERREXIT);
              }

I just wanna know something. the datavalue for connection is being passed as &connection to ex_connect. The data type is CS_CONNECTION *connection. Will the changes that are being made inside the function 'ex_connect' be reflected in the rest of the code ? ex_connect takes in as second parameter a datatype of 'CS_CONNECTION **'

The error i am getting is cos, ct_cmd_alloc function is failing... would like to have some help on how to fix, and what might be the problem....

[redhead]

Are you sure it shouldn't be:

              strcpy(sql_string, "USE pmll_test ");
              strcat(sql_string,gszDBName);

Note the added space after pmll_test, since when adding gszDBName you'll and up with a string that says "USE pmll_testgszDBName" and since I have no idear what your database name is that you want to use, I'mm guessing it's in this part the error occures.