It seems that SDL not only gets rid of the console, but redirects stdout and stderr to files. So even if you AttachConsole (or AllocConsole) you can't write to it with printf, etc. Does anyone know how to direct stdout and stderr back to the console? You could use the window console functions to write to it, though.
As for your SDL_GetVideoSurface() problem, it seems you need to call SDL_SetVideoMode() first.
Code:SDL_SetVideoMode(1280, 720, 32, SDL_DOUBLEBUF|SDL_FULLSCREEN);