× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




-----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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.