my_connect.c

unix上的ODBC实现

/***************************************************************************
                          my_connect.c  -  description
                             -------------------
    begin                : Wed Sep 8 2001
    copyright            : (C) MySQL AB 1995-2002, www.mysql.com
    author               : venu ( [e-mail] )
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *  This is a basic sample to demonstrate how to connect to MySQL server   *
 *  using MySQL ODBC 3.51 driver                                           *
 *                                                                         *
 ***************************************************************************/

#include "my_utility.h" /* MyODBC 3.51 sample utility header */

/********************************************************
* main routine                                          *
*********************************************************/
int main(int argc, char *argv[])
{
  SQLHENV    henv;
  SQLHDBC    hdbc; 
  SQLCHAR    server_name[30];  
  SQLRETURN  rc;
  SQLINTEGER narg;
  
    /*
     *  show the usage string when the user asks for this
    */    
      printf("***********************************************\n");
      printf("usage: my_connect [DSN] [UID] [PWD] \n");  
      printf("***********************************************\n");     

    /*
     * if connection string supplied through arguments, overrite
     * the default one..
    */
    for(narg = 1; narg < argc; narg++)
    {     
      if ( narg == 1 )
        mydsn = argv[1];
      else if ( narg == 2 )
        myuid = argv[2];
      else if ( narg == 3 )
        mypwd = argv[3];      
          
    }   
    
    printf("\n allocating environment handle ...");

    rc = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv);
    myenv(henv, rc);
    
    printf("success..\n setting the environment version ...");

    rc = SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(SQLPOINTER)SQL_OV_ODBC3,0);
    myenv(henv, rc);

    printf("success..\n allocating the connection handle ...");

    rc = SQLAllocHandle(SQL_HANDLE_DBC,henv, &hdbc);   
    myenv(henv, rc);
    
    printf("success..\n connecting to server using DSN '%s'...",mydsn);

    rc = SQLConnect(hdbc, mydsn, SQL_NTS, myuid, SQL_NTS,  mypwd, SQL_NTS);
    mycon(hdbc, rc);
          
    printf("success..\n");

    rc = SQLGetInfo(hdbc,SQL_DBMS_NAME,&server_name,40,NULL);
    mycon(hdbc, rc);

    printf(" connection established successfully to server '%s'\n",server_name);
    
    rc = SQLDisconnect(hdbc); 
    mycon(hdbc, rc);
        
    rc = SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
    mycon(hdbc, rc);
      
    rc = SQLFreeHandle(SQL_HANDLE_ENV, henv);
    myenv(henv, rc);

  printf("\nSUCCESS ...\n\n");

  return(0);  
}