1. Forum
  2. Usenet
  3. COMP.SYS.TANDEM

  • Accessing SQL/MP using pyodbc.

    From UDAY@21:1/5 to All on Wed Apr 14 06:07:12 2021
    I am getting error when using that NonStop Sql in driver field, help is very much aooreciated.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From UDAY@21:1/5 to Robert Hutchings on Wed Apr 14 06:04:32 2021
    On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
    OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Randall@21:1/5 to UDAY on Wed Apr 14 12:05:53 2021
    On Wednesday, April 14, 2021 at 9:07:13 a.m. UTC-4, UDAY wrote:
    I am getting error when using that NonStop Sql in driver field, help is very much aooreciated.

    Can you share the error that you are getting? I'm not sure help can be given if we don't know the error.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bill Honaker@21:1/5 to UDAY on Wed Apr 14 14:13:06 2021
    On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <[email protected]> wrote:

    On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
    OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bill Honaker@21:1/5 to UDAY on Wed Apr 14 14:11:55 2021
    On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <[email protected]> wrote:

    On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
    OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?

    Can you provide more details? Based only on the thread this was posted in, are you looking for the OSS ODBC driver to run on the NonStop within Python?
    Or are you looking for ODBC Drivers for Windows or Linux?

    If it's the OSS driver it should be installed on your server along with SQL/MX. It should be documented in the manual, search the Nonstop Manuals at HPE.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bill Honaker@21:1/5 to UDAY on Wed Apr 14 16:00:36 2021
    On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <[email protected]> wrote:

    On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
    OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?

    The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428

    It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
    However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.

    I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.

    If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.
    It's typically installed with an SPR or RVU, using Software Essentials.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From UDAY@21:1/5 to UDAY on Thu Apr 15 07:11:24 2021
    On Thursday, April 15, 2021 at 7:26:48 PM UTC+5:30, UDAY wrote:
    On Thursday, April 15, 2021 at 2:30:39 AM UTC+5:30, Bill Honaker wrote:
    On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <[email protected]> wrote:
    On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote: >> OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
    The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428

    It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
    However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.

    I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.

    If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.
    It's typically installed with an SPR or RVU, using Software Essentials.
    pyodbc.Error: ('01S00;,'[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)
    is the error i am getting


    code:
    import pyodbc
    usr = "xxx"
    pas = "xxx"
    conn = pyodbc.connect('DRIVER={NonStop ODBC/MX 3.6};SERVER=TCP:127.0.0.1/18000;UID=%s;PWD=%s' % (usr,pas))
    cursor = conn.cursor()

    same thing replacing server ip:port , username and pwd


    and i am able to connect to database using java and jdbc

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From UDAY@21:1/5 to Bill Honaker on Thu Apr 15 06:56:46 2021
    On Thursday, April 15, 2021 at 2:30:39 AM UTC+5:30, Bill Honaker wrote:
    On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <[email protected]> wrote: >On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote:
    OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
    The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428

    It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
    However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.

    I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.

    If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.
    It's typically installed with an SPR or RVU, using Software Essentials.


    pyodbc.Error: ('01S00;,'[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)
    is the error i am getting


    code:
    import pyodbc
    usr = "xxx"
    pas = "xxx"
    conn = pyodbc.connect('DRIVER={NonStop ODBC/MX 3.6};SERVER=TCP:127.0.0.1/18000;UID=%s;PWD=%s' % (usr,pas))
    cursor = conn.cursor()

    same thing replacing server ip:port , username and pwd

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bill Honaker@21:1/5 to UDAY on Fri Apr 16 15:33:28 2021
    Uday,

    Thank you for finally telling us this is for a client on Windows.

    The ODBC/MX Client Drivers manual should answer all your questions:

    https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=a00090058en_us

    Page 20 of the PDF tells you where on your NonStop you can find the client drivers, and details the installation procedures.
    Verification of the install is desceribed at the bottom of page 23.

    At the bottom of page 26, configuration of data sources is described for Windows.

    On page 33, the Data Source configuration is described. There is no automated discovery for SQL/MX ODBC sources.
    Your system managers will have to give you Network, Data Access, and credentials information.

    I hope that the information in the Manual is helpful to you.
    Bill

    On Thu, 15 Apr 2021 06:56:46 -0700 (PDT), UDAY <[email protected]> wrote:

    On Thursday, April 15, 2021 at 2:30:39 AM UTC+5:30, Bill Honaker wrote:
    On Wed, 14 Apr 2021 06:04:32 -0700 (PDT), UDAY <[email protected]> wrote: >> >On Friday, April 12, 2013 at 5:01:52 AM UTC+5:30, Robert Hutchings wrote: >> >> OK, thanks Andrew.
    How can i get DRIVER={NonStop ODBC/MX 3.6} driver?
    The latest manual I found is this one: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=c03682428

    It is for 3.2.1, but the location and usage is the same, I believe.It says that the driver is ZODBCDLL and is in $SYSTEM.ZMXODBC...
    However on the J series I just logged into it'sa actually YODBCDLL. It's probably different on L series.

    I would suspect that a symbolic link might be installed in /usr/lib... But I don't see any signs of that.

    If the version you have on your system is not 3.6, you will need to get the updated driver through HPE support. It has to be installed by your systems manager.
    It's typically installed with an SPR or RVU, using Software Essentials.


    pyodbc.Error: ('01S00;,'[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)
    is the error i am getting


    code:
    import pyodbc
    usr = "xxx"
    pas = "xxx"
    conn = pyodbc.connect('DRIVER={NonStop ODBC/MX 3.6};SERVER=TCP:127.0.0.1/18000;UID=%s;PWD=%s' % (usr,pas))
    cursor = conn.cursor()

    same thing replacing server ip:port , username and pwd

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)