RE: SQL CLI: I'm puzzled.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James H H Lampert

I'm starting to read up on SQL CLI, and the SQLConnect 
call has me puzzled: it seems to assume the data is on any 
arbitrary server.

What if the data is sitting in a bunch of physical files 
on the same box that's executing the call, and the program 
making the call doesn't necessarily know the user-ID it's 
running under, much less the password?


-----------------------------------------------

     D hdbc            S             10i 0 inz         

     D SQL_SUCCESS     C                   const(  0)

      * Null Terminated string
     D SQL_NTS         C                   const( -3)


     D SQLConnect...
     D                 PR                  extproc('SQLConnect')
     D                               10i 0
     D  i_hdbc                       10i 0 value 
     D  i_szDSN                        *   value  options(*string)  
     D  i_cbDSN                       5i 0 value 
     D  i_szUID                        *   value  options(*string)  
     D  i_cbUID                       5i 0 value 
     D  i_szAuthStr                    *   value  options(*string)  
     D  i_cbAuthStr                   5i 0 value 



         // allocate environment handle...
       // allocate connection handle...

         // connect for current user
         If SQL_SUCCESS = SQLConnect( hdbc
                                   :"myserver"
                                   :SQL_NTS
                                   :*null
                                   :SQL_NTS
                                   :*null
                                   :SQL_NTS
                         );
               // we have a connection  
        Endif;

Regards,

John Taylor