t0003.c

来自「unix上的TDS协议实现」· C语言 代码 · 共 73 行

/* FreeTDS - Library of routines accessing Sybase and Microsoft databases
 * Copyright (C) 1998-1999  Brian Bruns
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Library General Public
 * License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Library General Public License for more details.
 *
 * You should have received a copy of the GNU Library General Public
 * License along with this library; if not, write to the
 * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
 * Boston, MA 02111-1307, USA.
 */

#include <stdio.h>
#include <tds.h>


static char  software_version[]   = "$Id: t0003.c,v 1.1.1.1 2001/10/12 23:29:03 brianb Exp $";
static void *no_unused_var_warn[] = {software_version,
                                     no_unused_var_warn};


int main()
{
   TDSLOGIN *login;
   TDSSOCKET *tds;
   int verbose = 0;
   int rc;
   int i, marker, type;
   char old[100], new[100]; /* WARNING: not properly allocated, possible buffer 
			    overflow...for testing only, do not use in real 
                            code */

   fprintf(stdout, "%s: Testing DB change -- 'use tempdb'\n", __FILE__);
   rc = try_tds_login(&login, &tds, __FILE__, verbose);
   if (rc != TDS_SUCCEED) {
      fprintf(stderr, "try_tds_login() failed\n");
      return 1;
   }

   rc = tds_submit_query(tds,"use tempdb");
   if (rc != TDS_SUCCEED) {
      fprintf(stderr, "tds_submit_query() failed\n");
      return 1;
   }

   /* warning: this mucks with some internals to get the env chg message */
   do {
      marker=tds_get_byte(tds);
      tds_process_default_tokens(tds,marker);
   } while (marker!=TDS_DONE_TOKEN);
 
   /* Test currently disabled during TDSENVINFO changes */
   if (tds && tds->env && tds->env->database) {
      if (verbose) {
         fprintf(stdout, "database changed to %s\n", tds->env->database);
      }
      if (strcmp(tds->env->database, "tempdb")) {
         fprintf(stderr, "Wrong database, %s != tempdb\n", new);
         return 1;
      }
   }

   try_tds_logout(login, tds, verbose);
   return 0;
}