Hi Marek i suggest you post a reduced working sample at fivewin forum where adonet seem live http://forums.fivetechsupport.com/viewtopic.php?f=3&t=6814&start=165 In your simplified sample i pleased you Use one field only (if problem occur) NO noise of other question that your problem Create your test_db in your reduced/working sample so is sufficient modify server,username,password and running the sample
2009/10/14 Horodyski Marek (PZUZ) <[email protected]>: >>-----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 > -- Massimo Belgrano _______________________________________________ Harbour mailing list [email protected] http://lists.harbour-project.org/mailman/listinfo/harbour
