Re: [Firebird-odbc-devel] Execute error in ODBC driver

[Terry A. <ta...@ch...>]

Hello,

Sorry about the Rich Text.....

I'm not a C programmer, so I can't try that, but I am using the most recent
driver from http://www.praktik.km.ua and ADO 2.7 and the code I sent you
will crash every time.

Terry

----- Original Message ----- 
From: "Vladimir Tsvigun" <pr...@hm...>
Newsgroups: sourceforge.firebird-odbc-devel
To: <fir...@li...>
Sent: Monday, January 26, 2004 2:47 PM
Subject: Re: [Firebird-odbc-devel] Execute error in ODBC driver


> Hello,
>    Please, write message Content-Type: Text/Plain; !!!
>
> > 'Using this code crashes:   =20
> >     Set rs =3D conn2.Execute("SELECT tblJobs.JobID, tblJobs.JobNumber =
> > FROM tblJobs;", , adCmdText)
> >    =20
>
> I have executed it on C ++ with use ADO 1.5,
> For me works without problems.
> Probably at you old version OdbcJdbc
>     Look http://www.praktik.km.ua
> Look below:
> ===================================
>    _bstr_t strCnn("Provider=MSDASQL.1;Persist Security Info=False;Data
> Source=TestLocal");
>     // Define ADO object pointers.
>     // Initialize pointers on define.
>     // These are in the ADODB::  namespace.
>     _ConnectionPtr  pConnection = NULL;
>     _CommandPtr     pCmdChange  = NULL;
>     _RecordsetPtr   pRstTitles  = NULL;
>
>     try
>     {
>     _bstr_t strSQLSelect("SELECT * FROM COUNTRY");
>         // Open connection.
>         TESTHR(pConnection.CreateInstance(__uuidof(Connection)));
>         pConnection->Open (strCnn, "", "", adConnectUnspecified);
>
>         // Create command object.
>         TESTHR(pCmdChange.CreateInstance(__uuidof(Command)));
>         pCmdChange->ActiveConnection = pConnection;
>         pCmdChange->CommandText = strSQLSelect;
>
>         // Open titles table, casting Connection pointer to an
>         // IDispatch type so converted to correct type of variant.
>         TESTHR(pRstTitles.CreateInstance(__uuidof(Recordset)));
>
>         pRstTitles = pCmdChange->Execute(NULL,NULL,adCmdText);
> <------------!!!!!!!
>         PrintOutput(pRstTitles);
>         pConnection->Errors->Clear();
>
>         // Clean up objects before exit.
>         pRstTitles->Close();
>         pConnection->Close();
>     }
>     catch (_com_error &e)
>     {
>         PrintProviderError(pConnection);
>         PrintComError(e);
>     }
> ===========================
> Results:
>         USA, Dollar
>         England, Pound
> ...
>         Belgium, BFranc
>         Austria, Schilling
>         Fiji, FDollar
> ===========================
>
> --
> Best regards,
> Vladimir Tsvigun
>
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel