This is an example of how to create a connection object and connect with it to SQL Anywhere.
// ********************************************************************* // Copyright 1994-2008 iAnywhere Solutions, Inc. All rights reserved. // This sample code is provided AS IS, without warranty or liability // of any kind. // // You may use, reproduce, modify and distribute this sample code // without limitation, on the condition that you retain the foregoing // copyright notice and disclaimer as to the original iAnywhere code. // // ********************************************************************* #include <stdlib.h> #include <stdio.h> #include <string.h> #include "sacapidll.h" int main( int argc, char * argv[] ) { SQLAnywhereInterface api; a_sqlany_connection *conn; unsigned int max_api_ver; if( !sqlany_initialize_interface( &api, NULL ) ) { printf( "Could not initialize the interface!\n" ); exit( 0 ); } if( !api.sqlany_init( "MyAPP", SQLANY_CURRENT_API_VERSION, &max_api_ver )) { printf( "Failed to initialize the interface! Supported version = %d\n", max_api_ver ); sqlany_finalize_interface( &api ); return -1; } /* A connection object needs to be created first */ conn = api.sqlany_new_connection(); if( !api.sqlany_connect( conn, "uid=dba;pwd=sql" ) ) { /* failed to connect */ char buffer[SACAPI_ERROR_SIZE]; int rc; rc = api.sqlany_error( conn, buffer, sizeof(buffer) ); printf( "Failed to connect: error code=%d error message=%s\n", rc, buffer ); } else { printf( "Connected successfully!\n" ); api.sqlany_disconnect( conn ); } /* Must free the connection object or there will be a memory leak */ api.sqlany_free_connection( conn ); api.sqlany_fini(); sqlany_finalize_interface( &api ); return 0; } |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |