Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sahernandez

  1. sahernandez

    Update ORA DB with DataSet.Merge

    I have this Code: 'when I fill my OraDset for the firts time its empty 0 rows 'My MySql DataSet has 408 rows OleORAAdapt.AcceptChangesDuringFill = True OleORAAdapt.Fill(OraDset, "GDDATA_MYSQL") 'Here I try to pass my Data from MySQL to ORA Dataset 'I'd already wrote my InsertCommand...
  2. sahernandez

    About CrystalDecisions.Enterprise.Desktop.Report

    When I Build in my ASP.NET appl I got this error The dependency 'CrystalDecisions.Enterprise.Desktop.Report' could not be found. Can some body help me with this issue. Thxs Alexander
  3. sahernandez

    Need Help!! for Loop

    Hi, I have this information FREC orden Estacion DEMORAS TIPO 1 2 BOG -5 SOLO-93A 2 2 BOG -1 SOLO-93A 3 2 BOG -2 SOLO-93A 1 2 BZE -3 SOLO-93A 2 2 BZE -2 SOLO-93A 3 2 BZE -1 SOLO-93A 1 3 BOG 0 93A +OTRAS 2 3 BOG 0 93A +OTRAS 3 3 BOG 2 93A +OTRAS 1 3 BZE 0 93A +OTRAS 2 3 BZE 0 93A +OTRAS 3 3 BZE 0...
  4. sahernandez

    Procedure log

    Check this table "v$open_cursor" . (but you must be have a permision to read) select a.SID ,a.PROGRAM ,USERNAME, OSUSER, LOGON_TIME , machine ,STATUS, program , SQL_TEXT , -- ( to_char(round(last_call_et/1440,2)) ) last_call_HH , MIN_TO_HH24MI( TXTOMINUTE( to_char(round(last_call_et/1440,2))...
  5. sahernandez

    utility to transfer data from SQL Server into Oracle

    Can you tell what problem you have using DTS. For me the DTS works really nice. Which type of OLE DB are you using, ORACLE OLE DB or MSORA. Cheers sahernandez
  6. sahernandez

    Problem Connections (V$SESSION)

    I guest that I fix the problem, I change my ORA_OLDB by a MSORA connection. I don't know why the ORA_OLDB connection give this problem, but I will try to read or search it. Cheers Sahernandez
  7. sahernandez

    oracle error ORA-06502

    the problem is you are try to insert into a numeric value some character. can you show me the query. Bye sahernandez
  8. sahernandez

    Problem Connections (V$SESSION)

    Hi, I have a big problem, I have One VB appl program running over in XP and Win2K. select cOUNt(*) , osuser , MACHINE , PROGRAM , TERMINAL from V$SESSION where schemaname = 'OPERACIONES' group by osuser , MACHINE , PROGRAM , TERMINAL order by count(*) desc , osuser , TERMINAL; My...
  9. sahernandez

    running a appl in win2k problem

    Yes I already did it. I have a Bundled Version of CR9 and VS .NET 2002. And I added this merge module: Database_Access.msm Database_Access_enu.msm Managed.msm RegWiz.msm VC_CRT.msm VC_STL.msm But the point is, for XP run fine only in Win2k I found some problems Cheers
  10. sahernandez

    running a appl in win2k problem

    no, but I don´t need to install CR9 over each machine or should I install it. Over Win Xp works fine. thxs Dimandja
  11. sahernandez

    DataTable to Txt

    Dim myRow As DataRow For Each myRow In OraTb_Main.Rows Dato_TXT &= LTrim(Join(myRow.ItemArray),ControlChars.Tab)) & ControlChars.NewLine Next Response.Clear() Response.ContentType = "text/plain" Response.ContentEncoding = System.Text.Encoding.ASCII Response.Write(Dato_TXT)
  12. sahernandez

    running a appl in win2k problem

    Hi, I have some program to load CR9 (crystal report 9), when a Running this programs in a WinXP pc there is not problem, but when I run this program in a Win2k pc, I got this error System.NullReferenceException: Object reference not set to an instance of an object. at...
  13. sahernandez

    Using Crystal Rpt with .NET on client Machine

    I try to use my Reports on a client machine user (doesn't have a Visual Studio .NET) and I got this error ************** Exception Text ************** System.IO.FileNotFoundException: File or assembly name CrystalDecisions.Windows.Forms, or one of its dependencies, was not found. When I use...
  14. sahernandez

    DataTable to Txt

    Thxs Link9. But I guess there is another way to do, cause I don't want to loop this for each column. I know that put the information from DataTable into Array or ArrayList,and then use Join function I can avoid to loop for each column, but I don't know how to use it Thxs again Link9
  15. sahernandez

    DataTable to Txt

    Anybody know how can I do this, I have a DataTeble("Table") and this table have Field1 Field2 Field3 A B C D E F I want to transform this table to TXT , separate by comma or by TAB A,B,C D,E,F OR A B C D E F anybody know how can I do that, I have to save this into...

Part and Inventory Search

Back
Top