Re: RE : [development-axapta] can we get exterior datasource in Axapta ?

[acloudy_yin]

Thank you a lot!

--- In development-axapta@yahoogroups.com, jun lee <[EMAIL PROTECTED]> 
wrote:
>
> Connect to database using ODBCConnection
> 
>  
> 
>     LoginProperty   loginProperty;
> 
> ODBCConnection  oDBCConnection;
> 
>  Statement       statement;
> 
>  ResultSet       results;
> 
> str             sql;
> 
> ;
> 
>  
> 
>  
> 
>         loginProperty = new LoginProperty();
> 
>  
> 
>         loginProperty.setServer(parmServerName);
> 
>         loginProperty.setDatabase(parmDatabaseName);
> 
>         loginProperty.setUsername(parmUserName);
> 
>         loginProperty.setPassword(parmPassword);
> 
>  
> 
>         oDBCConnection = new ODBCConnection(loginProperty);
> 
>  
> 
>       sql = "select * from " + backendTableName + " where 
dataareaid = " + strquotechar(dataareaid);
>         if (whereClause) {
>             sql = sql + " and " + whereClause;
>         }
>         statement = ODBCConnection.createStatement();
>         results = statement.executeQuery(sql);
> 
>  
> 
>         while (results.next()) 
> 
>        {
> 
>                ...
> 
>         }
> 
> 
> acloudy_yin <[EMAIL PROTECTED]> дµÀ£º
> Hi,Steeve!
> Thanks!
> But I am not used to the userconnection or odbcconnection.
> can you give me a way to learn it, or you can send me the
> tuitoral if you are free!
> Thanks!
> 
> 
> --- In development-axapta@yahoogroups.com, "Steeve Gilbert" 
> wrote:
> >
> > To my knowledge, the only way to read a table on another 
sqlserver 
> is to use a connection object like UserConnection, ODBCConnection, 
> etc...
> > 
> > Regards,
> > 
> > Steeve... 
> > 
> > 
> > -----Message d'origine-----
> > De? development-axapta@yahoogroups.com [mailto:development-
> [EMAIL PROTECTED] De la part de acloudy_yin
> > Envoyé : 25 octobre 2005 03:33
> > À : development-axapta@yahoogroups.com
> > Objet? [development-axapta] can we get exterior datasource in 
> Axapta ?
> > 
> > Dear all:
> > in my axapta development, I want get a datasource from other 
> sqlserver 
> > database in Axapta. how can I do ?
> > Thanks!
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > Yahoo! Groups Links
> >
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Yahoo! Groups Links
> 
> 
> 
> 
> 
> 
> 
>             
> ---------------------------------
>  ÑÅ»¢Ãâ·ÑGÓÊÏ䣭ÖйúµÚÒ»¾øÎÞÀ¬»øÓʼþɧÈų¬´óÓÊÏä
>  ÑÅ»¢ÖúÊÖ¡§DËÑË÷¡¢É±¶¾¡¢·ÀɧÈÅ  
> 
> [Non-text portions of this message have been removed]
>









    


  
  
    SPONSORED LINKS
  
          
                  
            
        Programming languages
      
                      
        Microsoft axapta
      
                      
        Support exchange
      
              
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "development-axapta" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.