Peter J. Boettcher — Thu, 07 Mar 2002 14:49:04 +0000

That I don't know, sorry. Did you see the DESCRIBE example in books online?

#define NUM_RETURN_COLS 2
struct sqlda *mysqlda;
EXEC SQL BEGIN DECLARE SECTION;
char statement[] = "SELECT au_fname, au_lname FROM authors";
EXEC SQL END DECLARE SECTION;

mysqlda = malloc(SQLDASIZE(NUM_RETURN_COLS));
if (mysqlda == NULL)
{
   return;
}
mysqlda->sqln = NUM_RETURN_COLS;
mysqlda->sqldabc = SQLDASIZE(NUM_RETURN_COLS);

EXEC SQL DECLARE c1 CURSOR FOR stmt1;
EXEC SQL PREPARE stmt1 FROM :statement;
EXEC SQL DESCRIBE stmt1 INTO :mysqlda;
// SQLDA now contains a description of the dynamic SQL statement //
EXEC SQL OPEN c1;
EXEC SQL FETCH c1 USING DESCRIPTOR :mysqlda;

ShinNathan — Thu, 07 Mar 2002 10:45:21 +0000

I fixed my problem with a format and reinstall of win2k...

Anyway I have a new question. What is the tsql version of mysql's describe function? Basically I want to get the same output as the generate sql script function but with tsql instead of using enterprise manager.

Thank you for all your help

Peter J. Boettcher — Tue, 05 Mar 2002 14:14:00 +0000

Check the Application log in the Event viewer it might give you a better error message and number (maybe). Just look for any entries with SQL Server in them.

ShinNathan — Tue, 05 Mar 2002 01:44:18 +0000

Thanks. I found out that I could not install enterprise after I posted that but desktop should still work so says MS. I don't have another pc to test on...

The problem with desktop is when it tries to start the service just after installing it. There is a pop up message saying that 'an error occured while attempting to start the service'. Then in the cnfgsvr.out file the same thing is written. There could be an error code in there, I am not sure since when I open the file in notepad there are blocks all over like it is in word format. I think there might be (5) next to the error message.

Peter J. Boettcher — Mon, 04 Mar 2002 13:52:32 +0000

You shouldn't have any problems installing SQL 7 Desktop version on a Windows 2000 Pro box. You must have something else installed that is pooching the install. Maybe some left over files from the previous SQL 2000 install? Do you get the same error on another 2K pro box?