Desperate: SQL Server on Win2K Pro
Is there any way I can run SQL Server 7 on win2k pro? I run the set up program and try to install the Enterprise Edition but that just tells me that "Enterprise Edition server component can not be installed on NT Workstation".
When trying to install the desktop version it gets to the end and then when it tries to establish a server connection it fails saying just that it has failed to establish a connection.
I am in desperate need of help. I am half way through a project and the trial version of SQL Server 2000 ended. I have brought SQL Server 7 because I could not afford 2000 but it does not seem to work at all with win2k. HELP!
Peter J. Boettcher posted this at 13:52 — 4th March 2002.
They have: 812 posts
Joined: Feb 2000
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?
PJ | Are we there yet?
pjboettcher.com
ShinNathan posted this at 01:44 — 5th March 2002.
They have: 46 posts
Joined: Dec 2000
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.
Nasanu.org
Peter J. Boettcher posted this at 14:14 — 5th March 2002.
They have: 812 posts
Joined: Feb 2000
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.
PJ | Are we there yet?
pjboettcher.com
ShinNathan posted this at 10:45 — 7th March 2002.
They have: 46 posts
Joined: Dec 2000
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
Nasanu.org
Peter J. Boettcher posted this at 14:49 — 7th March 2002.
They have: 812 posts
Joined: Feb 2000
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;
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.