ADO and ODBC newbie question! ;)

[flac0]

Hi!
I'm newbie in ADO and i´m trying to do a ADO connection with ODBC with a Excel file by database source... I get this example from MSDN but i can´t do it work.

In the ODBC Console I've defined a DSN=myExcel with a workbook in c:\myproject\user.xls, Provider=Microsoft Excel Driver,no UID and no PWD.

The code are crashing in line of ConnectionString. What i´m do it wrong?

:
:
_ConnectionPtr m_pConnection = NULL;

m_pConnection.CreateInstance( __uuidof(Connection) );

m_pConnection->ConnectionString = "DSN=myExcel;UID=;PWD=";

m_pConnection->Open("","","",adConnectUnspecified);
:
:

Thanks in advance...gabriel!

----------------------------------------
Other world it´s possible. Keep on fighting! >
----------------------------------------

 

[tchouch]

_ConnectionPtr m_pConnection = NULL; //pointer m_pConnection is NULL here

//This line can't make m_pConnection != NULL
m_pConnection.CreateInstance( __uuidof(Connection) );

//You use a NULL pointer m_pConnection here - it will not work
m_pConnection->ConnectionString = "DSN=myExcel;UID=;PWD=";

//You use a NULL pointer m_pConnection here - it will not work
m_pConnection->Open("","","",adConnectUnspecified);