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

Try connecting through SQLPLUS first. That will establish correct connectivity before you attempt ODBC.

• AMit

"Roland Zenner" <zenner_at_iff.fhg.de> wrote in message news:3E9BFE8C.8C691BBC_at_iff.fhg.de...
> 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 Thu Apr 17 2003 - 16:48:56 CDT