I can try i Need Connection string and structure/data
Oracle can give more way from ado
OLE DB Provider for Oracle (from Microsoft)
strConnect = _T("Provider=MSDAORA;Data Source=MyOracleDB;User Id=myUsername;"
"Password=myPassword;");
OLE DB Standard Provider for Oracle (from Oracle).
strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;"
"User Id=myUsername;Password=myPassword;");
OLE DB Trusted Provider for Oracle (from Oracle).
strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
and using Microsoft OLE DB Provider for ODBC Drivers we have a log of way
I can try mssql, and oracle from same customer
Why In your selection string you convert all value to char?
http://www.techonthenet.com/oracle/functions/to_char.php
2009/10/13 Horodyski Marek (PZUZ) <[email protected]>:
>>-----Original Message-----
>>From: Massimo Belgrano [mailto:[email protected]]
>>Sent: Tuesday, October 13, 2009 12:09 PM
>>To: Harbour Project Main Developer List.
>>Subject: Re: [Harbour] RDDADO on Beta3
>>
>>2009/10/13 Horodyski Marek (PZUZ) <[email protected]>:
>>>>-----Original Message-----
>>> I have tested ADO from contrib.
>>> >From Oracle correctly maps only field type CHARACTER.
>>> For others types, gives the value of U.
>>Can you post a sample (that recreate your problem )
>>http://forums.fivetechsupport.com/viewtopic.php?f=3&t=6814
>>follow my untested sample
>>
>>#include "adordd.ch"
>>REQUEST ADORDD
>>function Main(x_string)
>>OPEN CONNECTION x_string
>>aDbf := {}
>>AADD( aDbf, { "FN", "N", 10, 0 } )
>>AADD( aDbf, { "FNF", "N", 12, 4 } )
>>AADD( aDbf, { "FC", "C", 40, 0 } )
>>AADD( aDbf, { "FD", "D", 8, 0 } )
>>AADD( aDbf, { "FL", "L", 1, 0 } )
>>AADD( aDbf, { "FM", "M", 0, 0 } )
>>dbCreate("dbtest",aDbf)
>>? "Creating test database - inserting", nrec, " records"
>>use dbtest SHARED via "adordd"
>>IF NETERR()
>> ? "Unable to open DBTEST "
>>ENDIF
>>? "INSERT 10 "
>>for i = 1 to 10
>> append blank
>> replace fn with A
>> replace fnf with A*A
>> replace fc with replicate( CHR(65+A ), 40 )
>> replace fd with date() + A
>> replace fl with A*2
>>next
>>browse()
>>
>>> SQLMIX properly at the moment gives me a values of various types for
>>> ORACLE and MS SQL SERVER.
>
> Can you try it with Oracle ?
> Here is my query sended via ADO :
>
> select id_dekretacja, to_char( id_dekretacja, '99') dekret, opis,
> to_char( sum( case when gr_ik = '3' then kwota else 0 end ),
> '999999999999.99') kwota_ik,
> to_char( sum( case when gr_ik = '2' then kwota else 0 end ),
> '999999999999.99') kwota_gr,
> to_char( sum( kwota ),
> '999999999999.99') kwota_og
> from ( ...
>
> I must all converted to character type, and later to another type from
> character.
> When have you acces to Oracle server, I can prepare any example.
>
> Regards,
> Marek Horodyski
> _______________________________________________
> Harbour mailing list
> [email protected]
> http://lists.harbour-project.org/mailman/listinfo/harbour
>
--
Massimo Belgrano
_______________________________________________
Harbour mailing list
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
