>-----Original Message----- >From: Massimo Belgrano [mailto:[email protected]] >Sent: Tuesday, October 13, 2009 4:37 PM >To: Harbour Project Main Developer List. >Subject: Re: [Harbour] RDDADO on Beta3 > >I can try i Need Connection string and structure/data Oracle
... >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 HB_AdoSetEngine( 'ORACLE' ) HB_AdoSetServer( "ALIAS_FROM_FILE_TNSNAMES.ORA" ) HB_AdoSetUser( "USER_SCHEMA_NAME_IN_DATABASE" ) HB_AdoSetPassword( "PASSWORD" ) HB_AdoSetQuery( "here long query or name variabel") dbUseArea( .T., "ADORDD", "ALIAS_NAME",, Nil, .F. ) >Why In your selection string you convert all value to char? >http://www.techonthenet.com/oracle/functions/to_char.php Why ? >From another types than character, fields in "ALIAS_NAME" have no value. Regards, Marek Horodyski P.S. Promises to me reading from DB2 _______________________________________________ Harbour mailing list [email protected] http://lists.harbour-project.org/mailman/listinfo/harbour
