Here is an example, using ODBC, and functions from sql.h

	SQLHENV   henv;
 	SQLHDBC   hdbc;
 	SQLRETURN rc;
 	SQLCHAR   server[12];
 	SQLCHAR   uid[12];
 	SQLCHAR   pwd[12];
 .
 .
 .
 	strcpy((char*)server, "test_db");
 	strcpy((char*)uid, "Admin");
 	strcpy((char*)pwd, "");
 	SDWORD cbName = SQL_NTS;
 
 	if (((rc = SQLAllocEnv(&henv)) == SQL_SUCCESS) &&
 	((rc = SQLAllocConnect(henv, &hdbc)) == SQL_SUCCESS)) 
 	{
 		if ((rc = SQLConnect(hdbc, server, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS)) != SQL_SUCCESS)
 			print_error (henv, hdbc, SQL_NULL_HSTMT, rc, __LINE__, __FILE__);
 				
 	}
 	else 
 	{
 		print_error (henv, SQL_NULL_HDBC, SQL_NULL_HSTMT, rc, __LINE__, __FILE__);
 	}
 

Have a look at this MSDN document:

Developing Access 2007 Solutions with Native C or C++

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window