Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-14 : 09:23:53
|
| Aditi writes "Hello, I am programming in Visual C++ 6.0.I need to call a stored procedure whick goes something like"select top 1 * from tbl where tbl.z = x order by z desc.I want to use ODBC Recordsets and open the recordset by calling this stored procedure.However ,I always do get an error. It works ok if i return a single field value though.Please give me a pointer as to what I'm doing wrong?Thanks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-14 : 10:39:52
|
| WHAT IS THE EXACT ERROR MESSAGE YOU'RE GETTING????When you say "ODBC recordsets", you mean you're strictly using ODBC calls to the database? Or are you using an ODBC driver, and perhaps using ADO recordsets? What version of SQL Server are you using (6.5, 7.0, 2000)?It may be that you need to update the ODBC driver. You can download and install the MDAC components here:http://www.microsoft.com/data/download.htmGet the MDAC 2.6 SP1 package and install it. This will also update the SQL Server ODBC driver. |
 |
|
|
|
|
|
Stored Procedures