What do I need for an ODBC connection to Oracle 9i with VC++?

Hello!

I want to create a connection using ODBC and VC++. What do I need and how can I do that?
This code does not work...

	ret_code = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE,
&henv);								// Environment-Handle holen (ODBC-Manager installiert?)
	if ((ret_code==SQL_SUCCESS) || (ret_code==SQL_SUCCESS_WITH_INFO))
	{
		ret_code = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)
SQL_OV_ODBC3, SQL_NTS);
		if ((ret_code==SQL_SUCCESS) || (ret_code==SQL_SUCCESS_WITH_INFO))
		{
			ret_code = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);										if
((ret_code==SQL_SUCCESS) || (ret_code==SQL_SUCCESS_WITH_INFO))
			{
				ret_code = SQLConnect(hdbc, (SQLTCHAR*)dbname, SQL_NTS,
(SQLTCHAR*)name, SQL_NTS, (SQLTCHAR*)pw, SQL_NTS);
				if ((ret_code==SQL_SUCCESS) || (ret_code==SQL_SUCCESS_WITH_INFO))
					connection_flag=0L;

Greetz
Roland Received on Tue Apr 15 2003 - 07:43:56 CDT