IBM i Global

IBM i Global

Connect, learn, share, and engage with IBM Power.

 View Only

  • 1.  Modern .Net and DB2 for IBMi

    Posted Thu February 16, 2023 10:44 AM

    Can anyone tell me if they've been able to access IBM i DB2 via NetCore for .Net5-7?would appreciate a breakdown about what's required, or if it's even possible. Thanks



    ------------------------------
    Phillip Knox
    ------------------------------


  • 2.  RE: Modern .Net and DB2 for IBMi

    Posted Thu February 16, 2023 11:05 AM

    All I know is if you can do ODBC from that environment, you can do it.



    ------------------------------
    Jack Woehr
    IBM Champion 2021 - 2023
    IBM Qiskit Advocate
    ------------------------------

    Original Message


  • 3.  RE: Modern .Net and DB2 for IBMi

    Posted Thu February 16, 2023 12:48 PM

    We were looking at ODBC. Do you have any pointers for connecting and processing me? It's a 9009-41A w/V7R3M0.



    ------------------------------
    Phillip Knox
    ------------------------------

    Original Message


  • 4.  RE: Modern .Net and DB2 for IBMi

    Posted Thu February 16, 2023 12:59 PM

    Sorry, meant to say 'for me'. Also the IBM i is a 8286-41A, not 9009-41A. Apologies.



    ------------------------------
    Phillip Knox
    ------------------------------

    Original Message


  • 5.  RE: Modern .Net and DB2 for IBMi

    Posted Fri February 17, 2023 04:21 AM 
    You can see www.aumerial.com there is a new product called Link2i that works on all .Net environments (framework 4.8, core 3.1, .Net 5.0, 6.0, 7.0) with ALL .Net technologies (from desktop to containers).
Link2i allows access and use of ALL IBM i resources (data, programs, S36, CLP, printers, stored procedures, source codes...).
AUMERIAL is an IBM partner working with IBM Montpellier in France.
You can contact them on lrt@aumerial.net
    



    ------------------------------
    Laurent ROUILLOT
    ------------------------------

    
                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                        
                                                        Original Message
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    • 
                
                    
  • 
			                                
                                
                                
    
                                    
    
                                        
    
                                            
                                            6.  
                                            RE: Modern .Net and DB2 for IBMi
                                            
                                            
                                            
                                        
    
                                    
    
                                    
    
                                        
    
				
                                                
    
                                                    
    
					
        
        
        
        
        
        
        
            
        
    
				
    
                                                
    
                                            
			
    
                                    
    
                                
    
                                
                                

                                
    
                                    
    
                                        
                                    
    

                                    
    
				

                                        
    
                                            
    
                                                
    
                                                    
    
                                                        Posted Fri February 17, 2023 01:07 PM
                                                        
                                                    
    
                                                
    
                                            
    
                                            
    
                                                

                                                
                                            
    
                                        
    

                                        
    
                                            
    
                                                
    This page lays out the options: 
    

    ibm.com/support/pages/ibm-i-net-data-provider-and-net-core
    

    

    In future, you might want to try this Power SQL Community for your SQL & Db2 for i questions:  ibm.biz/SQLonIBMi 


    ------------------------------
    Kent Milligan
    ------------------------------

    
                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                        
                                                        Original Message
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    • 
                
                    
  • 
			                                
                                
                                
    
                                    
    
                                        
    
                                            
                                            7.  
                                            RE: Modern .Net and DB2 for IBMi
                                            
                                            
                                            
                                        
    
                                    
    
                                    
    
                                        
    
				
                                                
    
                                                    
    
					
        
        
        
        
        
        
        
            
        
    
				
    
                                                
    
                                            
			
    
                                    
    
                                
    
                                
                                

                                
    
                                    
    
                                        
                                    
    

                                    
    
				

                                        
    
                                            
    
                                                
    
                                                    
    
                                                        Posted Fri February 17, 2023 01:51 PM
                                                        
                                                    
    
                                                
    
                                            
    
                                            
    
                                                

                                                
                                            
    
                                        
    

                                        
    
                                            
    
                                                
     
     
    Thank you, Kent. I wasn't exactly sure which group to post to. 
     
     
     

     
     
     
    Thank you,
     

     
     
    Phillip Knox
     
    Software Engineer
     
    Motorcity Systems
     
    313-324-6376
     
     
     



    
                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                        
                                                        Original Message
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    • 
                
                    
  • 
			                                
                                
                                
    
                                    
    
                                        
    
                                            
                                            8.  
                                            RE: Modern .Net and DB2 for IBMi
                                            
                                            
                                            
                                        
    
                                    
    
                                    
    
                                        
    
				
                                                
    
                                                    
    
					
        
        
        
        
        
        
        
            
        
    
				
    
                                                
    
                                            
			
    
                                    
    
                                
    
                                
                                

                                
    
                                    
    
                                        
    
				
                                            

    
    
    
    
        
    
            
    
					
                




                
            
				
    
            
        
    
    
    
    
    
    

    

                                        
			
    
                                    
    

                                    
    
				

                                        
    
                                            
    
                                                
    
                                                    
    
                                                        Posted Fri February 17, 2023 04:13 PM
                                                        
                                                    
    
                                                
    
                                            
    
                                            
    
                                                

                                                
                                            
    
                                        
    

                                        
    
                                            
    
                                                
    .Net 5-7 and beyond work just fine with the IBM i Access ODBC drivers. 
    

    Just install:
    -IBM i ODBC Driver on Windows, Linux or Mac
    -Visual Studio or VS Code if that's your IDE of choice and start developing. 
    

    I'm making an assumption your team already has some VB or C# experience. 
    

    If not you will need to find some .Net education courses. 
    

    



    ------------------------------
    Richard Schoen
    ------------------------------

    
                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                        
                                                        Original Message
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    • 
                
                    
  • 
			                                
                                
                                
    
                                    
    
                                        
    
                                            
                                            9.  
                                            RE: Modern .Net and DB2 for IBMi
                                            
                                            
                                            
                                        
    
                                    
    
                                    
    
                                        
    
				
                                                
    
                                                    
    
					
        
        
        
        
        
        
        
            
        
    
				
    
                                                
    
                                            
			
    
                                    
    
                                
    
                                
                                

                                
    
                                    
    
                                        
                                    
    

                                    
    
				

                                        
    
                                            
    
                                                
    
                                                    
    
                                                        Posted Fri February 17, 2023 05:05 PM
                                                        
                                                    
    
                                                
    
                                            
    
                                            
    
                                                

                                                
                                            
    
                                        
    

                                        
    
                                            
    
                                                
     
     
     
    Richard,
     

     
     
    My thanks sir! Appreciate the effort.
     
     
     
     

     
     
     
    Thank you,
     

     
     
    Phillip Knox
     
    Software Engineer
     
    Motorcity Systems
     
    313-324-6376
     
     
     



    
                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                        
                                                        Original Message
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    •