DaniWeb Forum Index > Software Development > C++

C++ RSS

How to receive data from SQL database by ODBC class

Please support our C++ advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2008

Posts: 1

Reputation: alanliao09 is an unknown quantity at this point

Solved Threads: 0

alanliao09 alanliao09 is offline

Offline

Newbie Poster

How to receive data from SQL database by ODBC class

Sep 3rd, 2008

I am currently using the ODBC class for c++ to connect and query a SQL database. I am calling a stored procedure within the database like so:

 Help with Code Tags 
 C++ Syntax (Toggle Plain Text) 
try{
		myCon->Open();
		OdbcCommand^ myCmd = gcnew OdbcCommand(MySP,myCon); //MySp is my store procedure and myCon is the SQL server connection string
		myCmd->Parameters->Add("xml",OdbcType::Char,200); 
		myCmd->Parameters->default[0]->Direction=ParameterDirection::ReturnValue;
		OdbcDataReader^ myReader = myCmd->ExecuteReader();  //Execute the sending
 
		while (myReader->Read())
		{
			Console::WriteLine();
			for(Int32 i=0;i<myReader->FieldCount;i++)
			{
				Console::WriteLine("{0}:{1}",(myReader->GetName(i))->ToString(),(myReader->GetValue(i))->ToString());
			}
		}
		myReader->Close();
		Console::WriteLine("OutputParamVal={0};ReturnVal={1}",myCmd->Parameters->default[0]->Value,myCmd->Parameters->default[1]->Value);
	}
try{
		myCon->Open();
		OdbcCommand^ myCmd = gcnew OdbcCommand(MySP,myCon); //MySp is my store procedure and myCon is the SQL server connection string
		myCmd->Parameters->Add("xml",OdbcType::Char,200); 
		myCmd->Parameters->default[0]->Direction=ParameterDirection::ReturnValue;
		OdbcDataReader^ myReader = myCmd->ExecuteReader();  //Execute the sending

		while (myReader->Read())
		{
			Console::WriteLine();
			for(Int32 i=0;i<myReader->FieldCount;i++)
			{
				Console::WriteLine("{0}:{1}",(myReader->GetName(i))->ToString(),(myReader->GetValue(i))->ToString());
			}
		}
		myReader->Close();
		Console::WriteLine("OutputParamVal={0};ReturnVal={1}",myCmd->Parameters->default[0]->Value,myCmd->Parameters->default[1]->Value);
	}

The stored procedure will perform a series of operations on several of the tables within the database. Depending on the data it will sometimes return data in a table format back to my program. At other times it will not. My question is, how do I receive this data when the stored procedure sends it back to my program. I know I am correctly calling the stored procedure as the database shifts around the data within the tables during the times it does not send anything back to my program. My colleague has been able to receive the data returns when calling the same stored procedure, however he is using Visual Basic.

Additional info:
The stored procedure does not accept parameters.

If anyone has any suggestions with how to receive returned data from a stored procedure, I would greatly appreciate your help. If the ODBC class is unable to do what I am requesting, I would be happy to use something else as well.

Thanks

Last edited by cscgal; Sep 3rd, 2008 at 7:14 pm. Reason: Added code tags